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.