Wednesday, March 21, 2012

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.

5 comments:

  1. This also worked in Pentaho Kettle. Thanks!

    ReplyDelete
    Replies
    1. Yes, exactly :) I think I published a similar blog post for Kettle as well some time ago.

      Delete
  2. Thank you! I can't believe how much time I've wasted troubleshooting problems based on this error.

    ReplyDelete
    Replies
    1. You are welcome! Glad to see that this post was of some use.

      Delete
  3. Thanks the solution did help track the error in my Talend job.

    ReplyDelete