Retrieve PostgreSQL error messagesWhen 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.