How to find problematic object in DSA backup/restore in Teradata when job_status says "There may be errors at object level"?
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.