Teradata SQL Error and Failure Codes from Error 1017 to 1026

SQLServerF1

1017 Object was skipped because it was excluded during the archive.
Explanation: The object is skipped because the user specified that the object be excluded during the archive so it cannot
be restored.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Correct the object name and resubmit the job.

1018 An object of type %VSTR cannot be excluded during an archive.
Explanation: An object of this type cannot be excluded during an archive.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Correct the object name and resubmit the job.

1019 Cannot copy join or hash index.
Explanation: Join or hash indexes are not allowed to be copied.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: None.

1020 Not allowed to backup object.
Explanation: The object not allowed to be archived. The object will not be included in the backup.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: None.

1021 There is a Down Amp in the system, the job cannot continue.
Explanation: There is a down amp in the system.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Bring all the amps online and resubmit the job.

1022 XML Plan for execution of job contains no object list.
Explanation: XML Plan for execution of job contains no object list.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Check the objects in job and submit again.

1023 XML Plan for execution of job contains multiple objects with DBC.
Explanation: DBC objects are mentioned in job.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Remove the dbc objects and resubmit the job.

1024 XML Plan for execution of job does not allow dictionary only operations on DBC.
Explanation: Dump/restore of DICTIONARY only for database DBC is not allowed.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Remove dictionary only option and resubmit the job.

1025 Saveset Username is required for DBC Restore.
Explanation: Saveset user name is not defined.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Provide a saveset username and resubmit the job.

1026 Saveset Password is required for DBC Restore.
Explanation: Saveset password is not defined.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Provide a saveset password and resubmit the job.

Above are list of Teradata Errors or Failure Codes from Error 1017 to 1026  received while performing certain operation against Teradata Database or related products.

What are Teradata Database Errors?

In general, each Teradata error message contains the following information:
• The message number.
• The message text. This text is usually returned with the message number. Some messages employ word substitution, where the word substituted represents the system-replacement of a term more specific to the occurrence.
• An explanation of how the error may have occurred.
• Generated-by text that indicates the software module which initiated the message. This field serves a diagnostic purpose for support and development personnel.
• A remedy which suggests how to resolve the condition.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Teradata SQL Error and Failure Codes and Error Messages on Windows, Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *