XML to Postgres ETL error - pstmt_tDBOutput_1

Two Stars

XML to Postgres ETL error - pstmt_tDBOutput_1

Hi,

 

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):

https://community.spiceworks.com/topic/1900865-process-xml-into-postgres

 

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.

Highlighted
Forteen Stars

Re: XML to Postgres ETL error - pstmt_tDBOutput_1

Hi,

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.

 

 

-----------

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads