Focal Point
[CASE-OPENED] DM failing bulk load giving return code 0

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/4447026876

September 28, 2015, 08:03 AM
Martin vK
[CASE-OPENED] DM failing bulk load giving return code 0
Hi,

Is have a DBMS SQL Flow in DataMigrator (7706M) with a DB2 bulk load as target.
Somehow this bulk load is not providing a return code > 0 when it runs into a sql error. See log below:

Starting bulk load procedure
09/27/2015 11:12:17 CONNECT TO DWHDB USER wsuser USING
09/27/2015 11:12:18 DB20000I The SQL command completed successfully.
09/27/2015 11:12:18 SQL0964C The transaction log for the database is full. SQL
STATE=57011
09/27/2015 11:12:18 CONNECT RESET
09/27/2015 11:12:18 DB20000I The SQL command completed successfully.
09/27/2015 11:12:18 QUIT
09/27/2015 11:12:18 DB20000I The QUIT command completed successfully.
SQL0964C The transaction log for the database is full. SQLSTATE=57011
Statistics not available for target file amd_etl/amd_babhis
Ending bulk load procedure
Return Code = 0

The SQL error is passed on to the ETL log, but nevertheless the return code = 0.
I would like to have a return code > 0, so in the process flow I can take appropriate action.
Is there a way to catch the error situation?

Martin.

This message has been edited. Last edited by: <Kathryn Henning>,


WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
October 05, 2015, 10:08 AM
Clif
Please open a hottrack case if you have not already done so.