ARC1263 The error table name for table %s.%s has been truncated to %s.%s.

Archive/Recovery (ARC Prefix) Messages

brand
Teradata Tools and Utilities
prodname
Teradata Tools and Utilities
vrm_release
15.10
category
Programming Reference
featnum
B035-1096-151K

ARC1263 The error table name for table %s.%s has been truncated to %s.%s.

Explanation:

This is a warning during a RESTORE or COPY. ARCMAIN has generated a default error table name for the specified table because a name was not specified with the ERRORTABLES option. The default rules are to pre-pend a "RS_" to the name of the target table. This warning is generated when the target table name is 28 characters in length or longer since pre-pending "RS_" to the name will cause it to exceed the 30 character maximum table name length limit. When the maximum table name limit is exceeded, the error table name will be truncated from the right to a length of 30 characters and the RESTORE or COPY operation is allowed to continue.

For Whom:

End User.

Notes:

Only error table names that are generated by ARCMAIN are truncated and the RESTORE or COPY operation allowed to continue. If the user enters a table name that is longer than 30 characters in length, a fatal error is generated by ARCMAIN and the RESTORE or COPY operation is terminated. If an error table name is truncated, it is possible that a duplicate name could be generated which will cause a fatal error in the database. If this should occur, the user has two options for correcting this error. First, the user could use the ERRORTABLES option to specify a unique table name. Second, the user could use the ERRORDB or ERRORTABLES option to specify a unique database name or a unique database.table name pair.

Remedy:

None. If the database fails due to a duplicate error table name, specify a unique database name with the ERRORDB parameter or a unique database.table name pair with the ERRORTABLES option and re-submit the job.