Solved

xml parsing error not enough storage is available to complete this operation

Posted on 2010-11-22
10
3,617 Views
Last Modified: 2013-11-10
I'm parsing a XML file that has 373 mb of size and I'm getting the following error. Any Idea why?

xml parsing error not enough storage is available to complete this operation
0
Comment
Question by:hmra
10 Comments
 
LVL 12

Expert Comment

by:udayakumarlm
ID: 34245386
how are you using the  XML. are you trying to store the XML in a single field or want to process and load the records in to a table.
if you are loading into single filed then use sp_tableoption to specify ''large value types out of row''  option to store the XML data not in the ROW. check the space available in the SQL Data drive.
if you are loading records from the XML, then break the XML file into multiple files and upload.
0
 

Author Comment

by:hmra
ID: 34257104
Thank you for your response.

Our process is doing a bulk load of the XML into a table and that part works well and then We get the XML and start getting records from the XML and putting them into a different table and we are getting that error “xml parsing error not enough storage is available to complete this operation”. Could you please explain me why this may be happening, the storage message within the error message is confusing me

Thank you very much
0
 
LVL 45

Expert Comment

by:aikimark
ID: 34275850
>>...that part works well
So you are successfully importing the XML data into a single table?
What part does the XML play in the distribution of the data to other tables?

Are you using the native XML functions or performing some custom XML-reading code?

Are you trying to populate all the tables in a single pass or making multiple passes of the XML?
0
 

Author Comment

by:hmra
ID: 34282468
The part that save the XML into a table works well.

We are using OpenXML, yes we are parsing the XML in a single pass.

The solution might be split the XML but How can I do it.

Thank you
0
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

 
LVL 45

Expert Comment

by:aikimark
ID: 34282877
I'm not sure you need to break up the XML.  You may only need to break up the importing process.

Since you are using SQL Server 2005, my first suggestion would be to import the data via its native XML services.  I don't know why or how you are using OpenXML, so this initial suggestion might change.

It would really help us to understand the XML and the tables which it populates.
0
 

Author Comment

by:hmra
ID: 34282918
We are using SQL 2008 R2

OK I will send you a copy of the code we are using
0
 
LVL 45

Accepted Solution

by:
aikimark earned 500 total points
ID: 34303503
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 34335372
Yes, I do believe it is an issue with OpenXML and having enough RAM to handle the parsing of the XML.  This may be of help: http:Q_23148098.html#a20851983
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

760 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

20 Experts available now in Live!

Get 1:1 Help Now