Solved

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

Posted on 2010-11-22
10
3,835 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 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

740 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