"XML stored procedures are not supported in fibers mode." - Fibers mode is not enabled.

Posted on 2007-07-31
Last Modified: 2010-05-10
On my development server I was able to create a stored procedure that takes an XML document in as a string and parses it into a table variable that I then use in the procedure.  Everything worked great.  Here's a mocked-up version of what I'm doing:

SET @xml =
            '< ROOT>
                < User Id="1" />
                < User Id="2" />
                < User Id="3" />
            < /ROOT>'

EXEC sp_xml_preparedocument @idoc OUTPUT, @xml
  FROM OPENXML (@idoc, '/ROOT/User', 2)  
  WITH (UserId INT '@Id')

When I moved the procedure to my production environment I got this error: "XML stored procedures are not supported in fibers mode."  After a little searching I tried two things, but now I'm stumped.  The option to "Use Windows NT fibers" is not enabled, and just in case I tried running the following in Query Analyzer:

sp_configure 'lightweight pooling', 0

I got the message:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Configuration option 'lightweight pooling' changed from 0 to 0. Run the RECONFIGURE statement to install.

Does anyone know why I'd be getting an error about fibers when they aren't even enabled?
Question by:ShantiSmurf
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    what exact version of ms sql server are you using?

    Author Comment

    Sorry, I should have included that.  The production server is:

     Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

    The dev box is:

    Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)   May  3 2005 23:18:38   Copyright (c) 1988-2003 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
    LVL 142

    Accepted Solution

    so, your dev box is in SP4, while the prod is SP3...

    now, was the SQL Server already restarted since the reconfiguration?

    Author Comment

    No, I can't restart Production until after hours.  I thought that fibers were not enabled before I ran the configure, but now that I try to think back what my steps were, I am not 100% sure that I checked the Processor settings before I ran the command in QA.  I guess I'll have to restart the service tonight and see if that resolves it.

    Author Comment

    Since a deadline was breathing down my neck and my boss wanted testing done that day I ended up restructuring my stored procedure to read from a permanent table that I updated via recordset update in my ASP code.  Not as elegant and the XML, but it will do.  The problem was most likely that I had run the query to reconfigure lightweight pooling before I actually looked at the server properties, and all that was needed at that point is a reboot.  I'll get around to testing it eventually, but I didn't want to leave this hanging open.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now