org.postgresql.util.PSQLException: ERROR: invalid XML content. Huge Input lookup

From: Sai Teja <saitejasaichintalapudi(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: org.postgresql.util.PSQLException: ERROR: invalid XML content. Huge Input lookup
Date: 2023-08-04 02:22:50
Message-ID: CADBXDMV_D3pBaSA5ZfUWnQP42ZO1YsbP9GZv8t1FncdGTiLMug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi team,

I am trying to migrate the data from db2 to postgreSQL in which one of the
table is having XML data.
For one of the file (13MB) I'm facing an error with

ERROR: invalid XML content
Detail: line 418061: internal error: Huge input lookup
nested exception is org.postgresql.util.PSQLException: ERROR: invalid XML
content

I even tried with more size of XML data (30MB) but for this case I can able
to migrate the date successfully.

But only for that file I'm facing the issue.
Later, I got to know that there are some special characters in that file
not sure whether this can be the issue or not.

I'm using java.sql.preparedstatement
Preparedstatement.setSQLXML(iterator, xmlobject) to migrate the data from
db2 to postgreSQL
When I tried in my local postgreSQL (which is windows and located in APAC
region. I can able to migrate successfully)
But when I'm trying to migrate into azure postgreSQL (Linux OS, located in
Germany) facing an issue.

I request you to please look into this and help me to resolve this error.

Please let me know if any queries.

Looking forward for the resolution.

Thanks & regards,
Sai Teja

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-08-04 02:33:03 Re: org.postgresql.util.PSQLException: ERROR: invalid XML content. Huge Input lookup
Previous Message Zhijie Hou (Fujitsu) 2023-08-04 02:12:53 RE: Runaway Initial Table Syncs in Logical Replication?