AnsweredAssumed Answered

Javelin: Bulkcopy DB2DataReader

Question asked by prince.munjal on Aug 11, 2017
Latest reply on Sep 12, 2017 by gilta03

Hi,

 

I am facing a strange issue with Db2DataReader for bulk copy records. My requirement is put BulkCopy in a try-catch block with a while loop to retry bulk copy for maximum 3 times incase of DB2 timeout errors.

 

My Code looks gud but when I am executing it.

 

In 1st try, DB2DataReader throws an error (Say DataRead successfully but failed to write in Stage table due to DDL Mismatch). My code jumps to Catch block and loops back to try bulk copy

 

In 2nd try, DB2DataReader is able read source data but javelin is skipping Copy to Stage step and making this block as success and come out. Ideally it should keep throwing same error in all 3 tries and code should come-out after 3rd try

 

Here screenshot of my code attached

 

Log::

Running flow...
2017-08-11 15:37:11 - Run flow: abc.vwf
2017-08-11 15:37:11 - Running Test Case: Flowchart
2017-08-11 15:37:12 - Executing Step: LogActivity
2017-08-11 15:37:12 - Querying TABLE1 for 1 time(s)

2017-08-11 15:37:12 - Executing Step: DB2ReadSrcData
2017-08-11 15:37:12 - Executing Step: Db2CopyToStg
2017-08-11 15:37:12 - Error executing Db2CopyToStg: There are more source columns the there are at the destination table.
2017-08-11 15:37:12 - Executing Step: Db2TruncateStgTbl
2017-08-11 15:37:12 - Connecting to DB2 database...
2017-08-11 15:37:12 - Executing query: TRUNCATE TABLE TDMTEMP1450.TABLE1
2017-08-11 15:37:12 - Executing Step: LogActivity
2017-08-11 15:37:12 - Querying TABLE1 for 2 time(s)

2017-08-11 15:37:12 - Executing Step: DB2ReadSrcData
2017-08-11 15:37:12 - Running Test Case: Flowchart
2017-08-11 15:37:12 - Test Case: Flowchart Execution Complete
Execution complete

Attachments

Outcomes