pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: org.postgresql.util.PSQLException: ERROR: invalid XML content. Huge Input lookup
Date: Thu, 3 Aug 2023 21:33:03 -0500
Message-ID: <30d2d7d1-47c2-386c-2ee3-06b338f1c7b3@gmail.com> (raw)
In-Reply-To: <CADBXDMV_D3pBaSA5ZfUWnQP42ZO1YsbP9GZv8t1FncdGTiLMug@mail.gmail.com>
References: <CADBXDMV_D3pBaSA5ZfUWnQP42ZO1YsbP9GZv8t1FncdGTiLMug@mail.gmail.com>

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.

view thread (11+ messages)  latest in thread

Message-ID: <30d2d7d1-47c2-386c-2ee3-06b338f1c7b3@gmail.com>
Permalink:  ../30d2d7d1-47c2-386c-2ee3-06b338f1c7b3@gmail.com/
Also on:    postgresql.org/message-id/30d2d7d1-47c2-386c-2ee3-06b338f1c7b3@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: ronljohnsonjr@gmail.com
  Subject: Re: org.postgresql.util.PSQLException: ERROR: invalid XML content. Huge Input lookup
  In-Reply-To: <30d2d7d1-47c2-386c-2ee3-06b338f1c7b3@gmail.com>
  References: <CADBXDMV_D3pBaSA5ZfUWnQP42ZO1YsbP9GZv8t1FncdGTiLMug@mail.gmail.com> <30d2d7d1-47c2-386c-2ee3-06b338f1c7b3@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox