XML to Postgres ETL error - pstmt_tDBOutput_1

Two Stars

XML to Postgres ETL error - pstmt_tDBOutput_1



I'm trying to load an XML file to PostgreSQL db, but getting an error during the job execution. Screenshot and detailed note of the message are attached.


As a simulation for another xml migration i'm using a simple xml source file and mapping to a postgres db exactly replicating the article posted here by Oscar (Spice Works):



I can successfully import, parse and map the xml file as described. DB connection is also successful, but the etl job fails with the attached descriptions.


The error message suggests that there might be JVM incompatibility. I'm using Talend Open Studio  7.1.1 with JDK 1.8.0_191 installed.


Can someone provide suggestions what might be the issue?


Thank you in advance,

Best Regards,

Asen R.

Thirteen Stars

Re: XML to Postgres ETL error - pstmt_tDBOutput_1


without details about your job (not errors), it not possible to find - what you do wrong.

think about case from this point - it is work, it is definitely work, and if it return an error to you, it means - you do something wrong, but you not show for us - what exactly you try to do.





Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.