Teradata SQL Error and Failure Codes from Error 11557 to 11565

SQLServerF1

11557 Merge virtual processor heap sift-up failure.
Explanation: As the BNS merge subsystem processes a merge request, it must maintain a virtual processor heap on all
participating nodes. When called upon to place a new sort key into this heap, the function VPSiftup() is called. This function
encountered a logic error.
Generated By: BNS Merge subsystem.
For Whom: System Support Representative.
Remedy: Contact the Global Support Center.

11559 Merge coordinator heap sift-up failure.
Explanation: The BNS merge subsystem establishes a coordinator heap on the node which is to manage the merge
request. If this heap has been corrupted, or if the sift-up logic has failed, this diagnostic will be issued.
Generated By: BNS Merge subsystem.
For Whom: System Support Representative.
Remedy: Contact the Global Support Center.

11560 Merge encountered corrupted context chain.
Explanation: When a merge has run to completion, its context must be located and deallocated. In attempting to locate
the context, merge logic has detected a corrupted hash chain.
Generated By: BNS Merge subsystem.
For Whom: System Support Representative.
Remedy: Contact the Global Support Center.

11561 :Merge encountered corrupt application block.
Explanation: When the BNS merge subsystem builds the buffer of merged data, it must include the user-specified
response parcel. If the page list holding the application block data is null, a logic error has occurred.
Generated By: BNS Merge subsystem.
For Whom: System Support Representative.
Remedy: Contact the Global Support Center.

11562 Merge data block has inconsistent relvp id.
Explanation: When the BNS merge subsystem processes an incoming RCB from a participating virtual processor, it must
resolve the relative vporoc id of the RCB with the corresponding id in the virtual processor heap. In this instance, the resolution
has failed. This may mean that the virtual processor heap has been corrupted.
Generated By: BNS Merge subsystem.
For Whom: System Support Representative.
Remedy: Contact the Global Support Center.

11563 Merge encountered null RLOC buffer.
Explanation: When the buffer of merged rows is being sent to the host, merge validates that at least one row is present in
this buffer. If there are no rows, the merge logic has failed.
Generated By: BNS Merge subsystem.
For Whom: System Support Representative.
Remedy: Contact the Global Support Center.

11564 Merge found unexpected SendReq service.
Explanation: When the BNS merge subsystem allocates a SendReq merge service, it encounters an unexpected subop.
Generated By: BNS Merge subsystem.
For Whom: System Support Representative.
Remedy: Contact the Global Support Center.

11565 Merge encountered unaligned row location.
Explanation: A location within the buffer of merged rows has been identified as incompatible with memory alignment
requirements of merge.
Generated By: BNS Merge subsystem.
For Whom: System Support Representative.
Remedy: Contact the Global Support Center.

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