Output SQL statement

oldforum

• July 16, 2007 00:00

• Answered

Follow

Is there any way to display queries generated by ColverETL when running the graph?

I got the following exception when my graph copies not all columns from one database table to another database table. By checking both tables and columns mapped, this kind of error should not be occurring.

java.sql.SQLException: Maximum # of errors exceeded when inserting record: ORA-01401: inserted value too large for column

Thanks,
Wendy

• 

  avackova

  • December 18, 2009 12:11

  0

  Comment actions Permalink

  The exact queries can't be obtained from DBOutputTable, but setting maxErrors attribute greater then zero and connectiong output port to DBOutputTable you can get offending values with detailed error message.

Please sign in to leave a comment.