DBXTRD "ERROR PROCESSING TABLE 'xxxxxxxx' TABLE COLUMNS NOT FOUND"

book

Article ID: 7032

calendar_today

Updated On:

Products

CA Repository

Issue/Introduction

The Teradata Catsync job is failing with a CC=8 in the SYNC step that executes program DBXTRD.

The output shows the following message listed for several tables

"ERROR PROCESSING TABLE 'xxxxxxxx' TABLE COLUMNS NOT FOUND. TABLE IS BEING BYPASSED"

Cause

This occurs when the extract file created by the Repository Teradata Exchange PC Scripts contains a TABLE entry but no COLUMN entries. 

Every Table extracted by the Teradata Exchange should have corresponding COLUMN entries.  

The Teradata script is composed of several individual SQL scripts that create the extract file.   There is a separate SQL statement for TABLE and COLUMN.

In this case, the SQL statement that extracts COLUMN is not returning any rows.

 

Environment

Release: DATASH00200-7.2-Repository-Webstation Option
Component:

Resolution

Examine the SQL statement that extracts COLUMN information from Teradata.

Copy this SQL statement and run outside of the script directly against Teradata for one of the tables in question.

If you are getting zero rows back then that is why COLUMN entries are not found.

Examine the SQL statement to determine why no COLUMNs are being extracted for the table(s) in question.

Modify the SQL statement as needed to return COLUMN records.