Insufficient memory uploading XML

Database
Teradata Employee

Insufficient memory uploading XML

Hi all,

 

My client is trying to import an XML file but he runs into the error:

Error in function XMLTABLE: Insufficient memory to complete the XML operation. (error 9134)

 

We already increases his XML Memory Limit value to 32Mb, which should be sufficient because the file is around 6 Mb.

 

Does anybody have any idea what the reason could be of the memory full-ness?

 

Hope to hear from you!
kind regards,

Helena

 

1 REPLY
Junior Supporter

Re: Insufficient memory uploading XML

Hi.

 

XML_MemoryLimit is the maximum amount of memory TO PROCESS XML, not the XML size itself. It seems that the memory needed TO PROCESS your 6MB XML file may exceed this limit.

 

HTH.

 

Cheers.

 

Carlos.