Solved

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

Posted on 2010-11-22
10
3,734 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
migrate a SQL 2008 to 2016, 2 26
write xml in vb.net 2 24
PowerShell script to remove string in xml file 8 20
While in ##Table - Help 4 12
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Read about achieving the basic levels of HRIS security in the workplace.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

785 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