Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4145
  • Last Modified:

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

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
hmra
Asked:
hmra
1 Solution
 
udaya kumar laligondlaTechnical LeadCommented:
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
 
hmraAuthor Commented:
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
 
aikimarkCommented:
>>...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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
hmraAuthor Commented:
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
 
aikimarkCommented:
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
 
hmraAuthor Commented:
We are using SQL 2008 R2

OK I will send you a copy of the code we are using
0
 
aikimarkCommented:
0
 
Kevin CrossChief Technology OfficerCommented:
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now