Talend Open Studio: Retrieve PostgreSQL error messages

Retrieve PostgreSQL error messages

When using the PostgresqlOutput component, sometimes you will only see “Call getNextException to see the cause” in the error log in case something goes wrong:
So how do we get a detailed error message?
The solution is to switch off the batch mode. Simply click on the Advanced settings of the PostgresqlOutput component and untick Batch size:

If you cannot see Use Batch Size, scroll all the way down!

Now save your job and rerun it: You should now get a useful error message:

Now you have the right info to solve the problem! Once the problem is solved, don't forget to switch on the batch mode again.