Forum Discussion

cesar_bolanos's avatar
cesar_bolanos
New Contributor
6 years ago

Insert error with JDBC insert and PGSQL

I have a pipeline that reads from Oracle and writes to PGSQL. When inserting to PGSQL, I get this error Batch entry 0 insert into “pg_temp”.“crmi002b_ut_pprs001” (“end_date”, “opportunity_type”, “s...
Anil's avatar
Anil
New Contributor III
6 years ago
Copy LinkReport

Hi @avellank,

I am not sure about changing the settings at once and reflecting accross all the pipelines.

But we can achieve it through snaplogic metadata snaps. Following are the steps.

  1. Create a pipeline which reads the metadata of the provided pipeline path and change the settings of PE snap and update the pipeline metadata using the pipeline path.

  2. Create a pipeline which gets the list of the pipelines in a project using Snaplogic List snap and call the above pipeline using PE snap and pass the pipeline paths.

Regards,
Anil Kumar