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

Document ID : KB000007032
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.

 

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.