Teradata SQL Error and Failure Codes from Error 9555 To 9570

9555 Single-column PARTITION Statistics are recollected. It is recommanded to collect multicolumn PARTITION Statistics.
Explanation: Modifying partitioning expression invalidates the PARTITION statistics. Single-column partition statistics
is automatically recollected. It is recommended to recollect multicolumn partition statistics.
Generated By: OPD modules.
For Whom: End User.
Notes: This warning is issued when modifying partitioning expression having multicolumn PARTITION statistics.
Remedy: Recollect the multicolumn PARTITION statistics.

9556 Collect SUMMARY statistics natively on the target table.
Explanation: SUMMARY statistics saves some physical attributes of the table. It is recommended to collect SUMMARY
statistics natively on the target table.
Generated By: OPD modules.
For Whom: End User.
Notes: This warning is issued when SUMMARY statistics are copied between the tables.
Remedy: Collect SUMMARY statistisc natively on the target table.

9557 Collect or refresh single and multicolumn PARTITION Statistics.
Explanation: Modifying the partitioning expression invalidates the PARTITION statistics. It is recommended to collect
or recollect single-column and multicolumn PARTITION statistics after modifying the partitioning expression.
Generated By: OPD modules.
For Whom: End User.
Notes: This warning is issued when modifying partitioning expression either when no statistics are available or when
when multicolumn PARTITION statistics are available.
Remedy: Collect or recollect single and multi column PARTITION statistics.

9558 Row Level Security operations are not supported on this system.
Explanation: The Row Level Security feature is disabled and user attempted to access an RLS table created before the
feature was disabled.
Generated By: RES module.
For Whom: End User.
Remedy: Do not resubmit the request.

9559 Temporal operations are not supported on a table without a primary index.
Explanation: Temporal operations on a table without a primary index can be done only when EnableNoPITemporal flag
in the cost profile is set to 1.
Generated By: resnamtb.c.
For Whom: User.
Remedy: Set EnableNoPITemporal flag in the cost profile to 1 and re-submit the statement.

9560 Collect SUMMARY, single and multicolumn PARTITION statistics natively on the target table.
Explanation: SUMMARY statistics saves some physical attributes of the table. Also, copying PARTITION statistics
between the tables having different partitioning expression invalidates them. It is recommended to collect SUMMARY and
PARTITION statistics natively on the target table.
Generated By: OPD modules.
For Whom: End User.
Notes: This warning is issued when copying SUMMARY, single and/or multicolumn PARTITION statistics with different
partitioning expression.
Remedy: Collect SUMMARY, single and multicolumn PARTITION statistics natively on the target table.

9561 Collect single and multicolumn PARTITION statistics natively on the target table.
Explanation: Single column and/or multicolumn PARTITION statisitcs that are copied between tables having different
partitioning expression are not valid. It is recommended to collect these statistics natively on the target table.
Generated By: OPD modules.
For Whom: End User.
Notes: This warning is issued when copying single and/or multicolumn PARTITION statistics between tables with different
partitioning expression.
Remedy: Collect single and multicolumn PARTIITON statistics natively on the target table.

9562 Internal error has occurred. Query will be retried with the following parser diagnostics enabled: %$Enum:0=,65535=,=364,2%d%$Enum:0=,65535=,=,366,2%d%$Enum:0=,65535=,=,368,2%d%$En
um:0=,65535=,=,370,2%d%$Enum:0=,65535=,=,372,2%d.%$Enum:0=,65535= Diag:374,2%d%$Enum:0=,65535= after DiagCount:376,2%d
Explanation: This error is similar to a 3610 error except that it will be retried with parser diagnostics enabled.
Generated By: CON and PAR modules.
For Whom: End User, and System Support Representative.

9563 Insufficient memory to construct the XML for this request.
Explanation: The request required too much memory to construct internal XML structures.
Generated By: DOM modules.
For Whom: End User.
Remedy: Increase the DBS Control Performance field DBQLXMLPlanMemLimit.

9570 A constraint defined in the table is invalid.
Explanation: This can happen when a constraint is dropped or recreated after a table defined with the constraint is
archived. When the archived table is restored, the referenced constraint’s internal id is not associated with an existing constraint in DBC.SecConstraints.
Generated By: RES module.
For Whom: End User.
Remedy: The restored table is inaccessible because of a dropped or recreated constraint. Identify the constraint that was
dropped or recreated after the archive was taken. Drop the constraint column and add back the constraint if it was recreated, then resubmit the request. For further help, contact your Support Representative.

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