Get the Job Execution ID # dsc list_job_history -name DBTgtT Data Stream Controller Command Line 15.11.02.00 Command parameters: -name : DBTgtT Connected to DSC version 15.11.02.00 Listing job history...
There are "4" buckets. Use the bucket parameter to specify which bucket to display. Current bucket displayed is "1".
Job history for "DBTgtT"
JOB EXECUTION ID START END DURATION STATUS OBJECTS SOURCE TARGET ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 200045 07/03/18 08:12:38 AM 07/03/18 08:55:05 AM 00:42:26 COMPLETED_ERRORS 560 AWSDev EBSTargetGroup 300008 06/27/18 04:15:41 AM 06/27/18 04:58:35 AM 00:42:54 COMPLETED_ERRORS 560 AWSDev EBSTargetGroup 2734 05/25/18 04:14:44 AM 05/25/18 04:21:01 AM 00:06:16 COMPLETED_SUCCESSFULLY 546 AWSDev EBSTargetGroup 2726 05/24/18 04:17:17 AM 05/24/18 04:24:04 AM 00:06:46 COMPLETED_SUCCESSFULLY 546 AWSDev EBSTargetGroup ……….. ……….. ………..
Use the job Execution ID 200045 to check the error
# dsc job_status_log -name DBTgtT -I 200045 -E Data Stream Controller Command Line 15.11.02.00 Command parameters: -name : DBTgtT -job_execution_id : 200045 -full_export : true Connected to DSC version 15.11.02.00 Getting Job Status Log...
Job Status log was exported in full to this path on the DSC Server: /var/opt/teradata/dsa/export/DBTgtT_200045.csv
Check the csv file for error # cat /var/opt/teradata/dsa/export/DBTgtT_200045.csv Source AWSDev Target EBSTargetGroup Number of Objects Copied 560 Size 306006769664 Start Time 2018-07-03 08:12:38.405 End Time 2018-07-03 08:55:05.156 End,Object Name,Object Type,Phase,Status,Parent Name,Byte Count,Row Count,Error Code,Warning Code 2018-07-03 08:46:27.91,SALES_TRAN_CIRCUMSTANCE,TABLE,DATA,COMPLETE,DBTGTT,1609527296,110776209,, 2018-07-03 …………. …………. …………. …………. 2018-07-03 08:41:27.768,PARTY_SCORE_LEVEL_TYPE,TABLE,DATA,COMPLETE,DBTGTT,12288,4,, 2018-07-03 08:13:26.553,VENDOR_PURCHASE_ORDER,TABLE,DICTIONARY,SKIPPED,DBTGTT,0,0,1171, Errors 1171,Object DBTgtT.VENDOR_PURCHASE_ORDER is not archived because of unresolved RI.
|