Teradata SQL Error and Failure Codes from Error 5998 To 6010

5998 Buffer for the QUERY_BAND is too small.
Explanation: This error indicates that the buffer provided to return the queryband is too small.
Generated By: PAR modules.
For Whom: End User.
Remedy: Correct and re-submit the statement.

6000 A programming fault has occurred.
Explanation: This error occurs if a programming fault is encountered.
Generated By: FigBac1C, FigBaIds, FigHBAd1 FigPTC, FigRPR, FigSRR the Order Subsystem
For Whom: Support Representative.
Remedy: Contact your Support Representative.

6001 The Status field of an AMP descriptor contains invalid value.
Explanation: This error occurs if the status field of an AMP’s descriptor does not contain an appropriate value.
Generated By: RCOCkDwn, RCOCSess.
For Whom: Support Representative.
Notes: The configuration table may or may not be properly initialized.
Remedy: Contact your Support Representative.

6002 Command has syntax error.
Explanation: This error occurs if the input command has syntax errors.
Generated By: RCOCCTRK, RCOCInput, RCOParse.
For Whom: End User.
Notes: None.
Remedy: Check the syntax and resubmit the request.

6003 Configuration Map is not properly initialized.
Explanation: This error occurs if a configuration map is not properly initialized or if the specified map does not exist.
Generated By: AMPEven2
For Whom: End User.
Notes: None.
Remedy: Check the syntax and resubmit the request.

6004 No AMPs are in the configuration map.
Explanation: This error occurs if no AMP is configured in the new configuration during an END CONFIG command.
Generated By: RCOCErr.
For Whom: End User.
Remedy: Ensure that at least one AMP is configured before entering the END CONFIG command.6005 No PEs are in the configuration map.
Explanation: This error occurs if no PE is configured in the new configuration during an END CONFIG command.
Generated By: RCOCErr.
For Whom: End User.
Remedy: Ensure that PEs are configured before entering the END CONFIG command.

6006 Cluster size must not be greater than 8.
Explanation: This error occurs if the cluster size is greater than 8.
Generated By: RCOCErr.
For Whom: End User.
Notes: None.
Remedy: Rearrange the clustering of AMPs so that no cluster sizes exceed 8.

6007 All clusters must be size 2 to 8.
Explanation: This error occurs if a cluster size is 1.
Generated By: RCOCErr.
For Whom: End User.
Remedy: Examine the configuration map and make sure that there are no cluster sizes of 1.

6008 Some AMPs are not in any cluster.
Explanation: This error occurs if some AMPs do not belong to any cluster.
Generated By: RCOCErr.
For Whom: End User.
Remedy: Enter “Default Cluster” or “Mod AMP” command to assign the AMP a valid cluster number.

6009 Vproc number is duplicate.
Explanation: This error occurs if a Vproc number is a duplicate.
Generated By: RCOCErr.
For Whom: End User.
Remedy: Examine the configuration map and specify an appropriate Vproc number.

6010 Some AMPs with a higher Vproc number have not been deleted
Explanation: This error occurs in a DEL AMP or END CONFIG command if the configurations contains some AMP
Vprocs with a higher Vproc number than a deleted AMP.
Generated By: RCOCInpu & RCOCSess.
For Whom: End User.
Remedy: Examine the configuration map and either remove the AMP(s) with the higher Vproc number of ADD AMPs
with Vproc number that will fill in the gaps currently existing in the configuration.

Above are list of Teradata Errors or Failure Codes from Error 5998 To 6010 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 *