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.

 

Comments