SELECT Failed. [7548] Insufficient memory to complete the XML operation

Database
Enthusiast

SELECT Failed. [7548] Insufficient memory to complete the XML operation

- version Teradata 14.10

- stored a 6Mb .xml file to a XML column (XML_col) on a row

- dbc control:  284.  MaxXML_MemoryLimit = 128 MB (4 - 128, Default 32)

- SELECT XML_col.EXISTSNODE('/tag', '')  results in subject error. 

- SELECT XML_col.ISDOCUMENT() returns 1

- SELECT XML_col.ISCONTENT() returns 1

- able to run SELECT XML_col.EXISTSNODE('/tag','') on smaller XML content and get expected return value

Tags (2)
1 REPLY
Enthusiast

Re: SELECT Failed. [7548] Insufficient memory to complete the XML operation

Getting same error message on Teradata 15.00