?
Solved

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

Posted on 2007-07-31
5
Medium Priority
?
512 Views
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:

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?
0
Comment
Question by:ShantiSmurf
  • 3
  • 2
5 Comments
 
LVL 143

Expert Comment

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

Author Comment

by:ShantiSmurf
ID: 19600741
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
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 1500 total points
ID: 19600872
so, your dev box is in SP4, while the prod is SP3...

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

Author Comment

by:ShantiSmurf
ID: 19600975
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
 

Author Comment

by:ShantiSmurf
ID: 19655109
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

864 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