Output SQL statement

CloverDX Platform
1

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

2

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.