Teradata SQL Error and Failure Codes from Error 1027 to 1036

SQLServerF1

1027 XML Plan for execution of job does not allow dump/restore of individual objects in DBC.
Explanation: Individual dbc objects are not allowed to be dumped/restored.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Change the job and resubmit it.

1028 XML Plan for execution of job does not allow dump/restore of individual objects in SYSUDTLIB.
Explanation: Individual sysudtlib objects are not allowed to be dumped/restored.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Change the job and resubmit it.

1029 XML Plan for execution of job contains multiple objects with SYSUDTLIB.
Explanation: Sysudtlib objects are not allowed to be dumped/restored.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Change the job and resubmit it.

1030 XML job plan cannot contain any SYSUDTLIB objects.
Explanation: Sysudtlib objects are not allowed to be dumped/restored.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: SYSUDTLIB objects will be backed up with DBC.

1031 Job plan contains map_to or renamed_to without specifying the name.
Explanation: Did not include new names for map_to or rename_to.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Change the job and resubmit it.

1032 XML Plan for execution of job does not allow copy of DBC.
Explanation: Copy of DBC is not allowed.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Change the job and resubmit it.

1033 XML Plan for execution of job does not allow copy to DBC.
Explanation: Copy to DBC is not allowed.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Change the job and resubmit it.

1034 XML Plan for execution of job does not allow copy of SYSUDTLIB.
Explanation: Copy of SYSUDTLIB is not allowed.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Change the job and resubmit it.

1035 XML Plan for execution of job does not allow copy to SYSUDTLIB.
Explanation: Copy to SYSUDTLIB is not allowed.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Change the job and resubmit it.

1036 XML Plan for execution of job contains no streamlist.
Explanation: Streamlist is missing from job execution xml.
Generated By: BAR.
For Whom: End user.
Notes: None.
Remedy: Change the job and resubmit it.

Above are list of Teradata Errors or Failure Codes from Error 1027 to 1036  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 *