2837 Table being Fast/Multi Loaded; no data dumped

Solution:

1. Check the SKIPPED table list 

2. Run checktable on the tables listed in SKIPPED table

3. Release the pending job.   

  •      Fastload pending -- DROP TABLE
  •      Multiload pending -- if it is work or temp table, DROP TABLE
    • If it data table then do "release mload ..." 

 

Example:

In Backup Server:

1. Check the SKIPPED table list 

 

# dsc list_job_history -name TestDBT

Data Stream Controller Command Line 16.20.00.03

Command parameters:

-name : TestDBT

Connected to DSC version 16.20.00.03

Listing job history...

 

There are "2" buckets. Use the bucket parameter to specify which bucket to display.

Current bucket displayed is "1".

 

Job history for "TestDBT"

 

 

JOB EXECUTION ID   START                  END                    DURATION   STATUS                   OBJECTS   SOURCE      TARGET

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

200661             06/12/19 04:36:43 AM   06/12/19 04:47:07 AM   00:10:24   COMPLETED_ERRORS         636       TestDB   EBSTargetGroup

100333             05/17/19 04:28:41 AM   05/17/19 04:36:24 AM   00:07:43   COMPLETED_SUCCESSFULLY   615       TestDB   EBSTargetGroup

……..     

……..

……..

 

#  dsc job_status_log -name TestDBT -I 200661 -E

Data Stream Controller Command Line 16.20.00.03

Command parameters:

-name : TestDBT

-job_execution_id : 200661

-full_export : true

Connected to DSC version 16.20.00.03

Getting Job Status Log...

 

Job Status log was exported in full to this path on the DSC Server: /var/opt/teradata/dsa/export/TestDBT_200661.csv

#  cat /var/opt/teradata/dsa/export/TestDBT_200661.csv|grep SKIPPED

2019-06-12 04:47:06.855,FINANCIAL_INFO_FromProd2,NO_PI_TABLE,DATA,SKIPPED,TESTDBT,0,0,2837,

2019-06-12 04:47:06.855,FINANCIAL_INFO_FromProd2_ET,TABLE,DATA,SKIPPED,TESTDBT,0,0,2837,

2019-06-12 04:47:06.855,FINANCIAL_INFO_FromProd2_UV,NO_PI_TABLE,DATA,SKIPPED,TESTDBT,0,0,2837,

2019-06-12 04:47:06.855,FINANCIAL_INFO_FromProd_UV,TABLE,DATA,SKIPPED,TESTDBT,0,0,2837,

2019-06-12 04:47:06.855,FINANCIAL_INFO_FromProd_ET,TABLE,DATA,SKIPPED,TESTDBT,0,0,2837,

 

In database server:

2. Run checktable on the tables listed in SKIPPED table

# cnsterm 6

Attempting to connect to CNS...Completed.

Hello

Input Supervisor Command:

> start checktable

start checktable

 

Started 'checktable' in window 3

 at Wed Jun 12 09:46:50 2019

 

Input Supervisor Command:

> ^C

# cnsterm 3

Attempting to connect to CNS...Completed.

Hello

 ========================================================================

 End of session state report

 Please enter a logical host id (? for help):

 _______

    |                                |              |

    |    ___     __     ____         |    ____    __|__    ____

    |   /      |/  \    ____|    ____|    ____|     |      ____|

    |   ---    |       /    |   /    |   /    |     |     /    |

    |   \___   |       \____|   \____|   \____|     |__   \____|

 

    Release 16.20.24.01 Version 16.20.24.01

    CHECK TABLE Utility (April 08)

 

CHECKTABLE will run in Workload Def: WD-Default

 

Enter a command, "QUIT;", "HELP;" or F7 for interactive help:

> CHECK TestDBT   AT LEVEL PENDINGOP;

CHECK TestDBT   AT LEVEL PENDINGOP;

 

Checktable defaults to concurrent mode

  on non-quiescent system with logons enabled.

 

Check beginning at 09:48:08 19/06/12.

CHECKTABLE will run from Host: 0  Session: 348,27351

"TESTDBT"."ASSOCIATE_LABOR_DETALS" was just processed. Processed 100 tables till                                                                                                                                                              now.

 

"TESTDBT"."COUPON_OFFER_DETAILS_B" was just processed. Processed 200 tables till now.

 

Table:  "TESTDBT"."FINANCIAL_INFO_FROMPROD2" checking at 09:48:33 19/06/12.

  Map No 1025, Table id 00FFH 3574H, Database id 0000H 0782H, Fallback.

  Table check bypassed due to pending FastLoad.

  Table Result:  Skipped

 

Table:  "TESTDBT"."FINANCIAL_INFO_FROMPROD2_ET" checking at 09:48:33 19/06/12.

  Map No 1025, Table id 00FFH 35B7H, Database id 0000H 0782H, Fallback.

  Table check bypassed due to pending FastLoad.

  Table Result:  Skipped

 

Table:  "TESTDBT"."FINANCIAL_INFO_FROMPROD2_UV" checking at 09:48:33 19/06/12.

  Map No 1025, Table id 00FFH 35B8H, Database id 0000H 0782H, Fallback.

  Table check bypassed due to pending FastLoad.

  Table Result:  Skipped

 

Table:  "TESTDBT"."FINANCIAL_INFO_FROMPROD_ET" checking at 09:48:33 19/06/12.

  Map No 1025, Table id 00FEH E133H, Database id 0000H 0782H, Fallback.

  Table check bypassed due to pending FastLoad.

  Table Result:  Skipped

 

Table:  "TESTDBT"."FINANCIAL_INFO_FROMPROD_UV" checking at 09:48:33 19/06/12.

  Map No 1025, Table id 00FEH E134H, Database id 0000H 0782H, Fallback.

  Table check bypassed due to pending FastLoad.

  Table Result:  Skipped

 

"TESTDBT"."JOURNAL_ENTRY_LINE" was just processed. Processed 300 tables till now.

 

"TESTDBT"."MINUTE_OF_DAY" was just processed. Processed 400 tables till now.

 

"TESTDBT"."PROMOTION_OFFER_VENDOR_FUND" was just processed. Processed 500 tables till now.

 

"TESTDBT"."TENDER_TRANS_COUPON" was just processed. Processed 600 tables till now.

 

 

Summary:

 

            633 table(s) checked.

            633 fallback table(s) checked.

              0 non-fallback table(s) checked.

              2 no primary-index table(s) checked.

 

              5 table(s) bypassed due to pending FastLoad.

 

              0 table(s) failed the check.

 

Check completed at 09:49:04 19/06/12.

Error file is '/var/opt/teradata/tdtemp/CheckTableErrors20190612094808'.

 

Enter a command, "QUIT;", "HELP;" or F7 for interactive help:

 

3. Release the pending job.   

  •      Fastload pending -- DROP TABLE
  •      Multiload pending -- if it is work or temp table, DROP TABLE
    • If it data table then do "release mload ..." 

Please visit http://www.nazmulhuda.info/release-mload-in-teradata to check how to release multiload.

Comments