Teradata SQL Error and Failure Codes from Error 6035 To 6058

6035 Warning: The Default Cluster size results in a cluster with multiple Amps on the same Clique.
Explanation: This warning occurs if a DEFAULT CLUSTER command is entered and the size chosen for the default cluster
size resulted in Amps on the same Clique being assigned to the same cluster. If this Clique were to fail, processing could
not continue since two or more Amps in the same cluster would be down.
Currently, there are two situations that may cause this warning:
1) The cluster size specified is greater than the number of Cliques defined in the system.
2) The cluster size specified resulted in an insufficient number of Amps to fill at least 50% of the cluster. So, these amps
were added to a full cluster which then caused the cluster to have multiple Amps on the same clique.
Generated By: RCOCErr.
For Whom: End User.
Remedy: If possible, choose a different default cluster size.

6036 The range is invalid.
Explanation: This error occurs if the entered range had invalid input – the beginning vproc is bigger than the ending
vproc.
Generated By: RCOCErr.
For Whom: End User.
Remedy: Press the HELP function key to check syntax.

6037 Listing configuration map option should be either Long or Short.
Explanation: This error occurs if neither long or short option is specified.
Generated By: RCOCErr.
For Whom: End User.
Remedy: Press the HELP function key to check syntax.

6038 The total AMP virtual processors count exceeded.
Explanation: This error occurs if the total AMPs vprocs counts are exceeded 16200.
Generated By: RCOCErr.
For Whom: End User.
Remedy: The process is not allowed

6039 The total PE virtual processors count exceeded.
Explanation: This error occurs if the total PEs vprocs counts are exceeded 1023.
Generated By: RCOCErr.
For Whom: End User.
Remedy: The process is not allowed.

6051 Cluster number is not found in the configuration map.
Explanation: This error occurs if the cluster number is not found in the config map.
Generated By: RCOCDisp.
For Whom: End User.
Remedy: Use the LIST command to display configuration.

6052 Number of Vprocs moving from is not equal to number of Vprocs moving to.
Explanation: This error occurs if the number of VPROCs moving from is not equal to the number of VPROCs moving to.
Generated By: RCOCInpu.
For Whom: End User.
Remedy: Examine the configuration command

6053 Unable to rebuild reference index, needs to be rebuilt.
Explanation: This error occurs in RCOErrUt when a disk error is encountered on a reference index which cannot be
rebuilt on the fly.
Generated By: RCOErrUt.
For Whom: Support Representative.
Remedy: Contact your Support Representative. Drop Subtable and rebuild.

6056 Moved AMPs must follow added AMPs
Explanation: If you are adding and moving AMPs at the same time, the range of new amps must include added AMPs
first, and then the moved-to AMPs. The move-to AMPs must always be the highest numbered AMPs to prevent gaps in
AMP numbers after the reconfig.
Generated By: RCOCSESS.
For Whom: End User.
Remedy: Examine the end configuration command

6058 Reconfig stopped, active online archive table(s) found.
Explanation: This error occurs when the system contains one or more active online archive table(s).
Generated By: RCOCCFG.
For Whom: End User.
Remedy: Disable the online archive tables by submitting LOGGING ONLINE ARCHIVE OFF statement or complete the
online archive process.

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