Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2010-11-22
10
Medium Priority
?
4,046 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 
LVL 12

Expert Comment

by:udaya kumar laligondla
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 46

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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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
 
LVL 46

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 46

Accepted Solution

by:
aikimark earned 2000 total points
ID: 34303503
0
 
LVL 60

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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
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.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

722 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