On 8/3/23 21:22, Sai Teja wrote:
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.
That sounds like it has to do with locale differences between the two systems.
*Exactly* what Pg version (including patch level) and locale are in each of
the two systems?
Even if it's not that, *something* is configured differently between the two
systems.
--
Born in Arizona, moved to Babylonia.
