I tried to update data from a postgreSQl database using tDBOutput method and I have a mistake when I run the job.
L'élément du batch 0 UPDATE "public"."places" SET "expiration_date" = 2015-12-31 00:00:00.000000 +01:00:00 WHERE "null" = FRREGI_72 a été annulé. Appeler getNextException pour en connaître la cause. caused by: ERROR: column "null" does not exist
Can you help me please.
Solved! Go to Solution.
I think I may have a problem with the connection. Because when I restarted the job few hours later it's worked but today I have the same mistake for an insertion.
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.