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

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:

DECLARE @xml  VARCHAR(1000)
DECLARE @idoc INT
 
SET @xml =
            '< ROOT>
                < User Id="1" />
                < User Id="2" />
                < User Id="3" />
            < /ROOT>'

EXEC sp_xml_preparedocument @idoc OUTPUT, @xml
 
SELECT UserId
  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
RECONFIGURE
GO

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?
ShantiSmurfAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
so, your dev box is in SP4, while the prod is SP3...

now, was the SQL Server already restarted since the reconfiguration?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
what exact version of ms sql server are you using?
0
 
ShantiSmurfAuthor Commented:
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)
0
 
ShantiSmurfAuthor Commented:
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.
0
 
ShantiSmurfAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.