Symptom
A query (DDL command or DML command) that runs from a writer node processes as a global transaction on a coordinator node via Internode Communication (INC).
If a coordinator node was restarted with a various cause, a query fails with the below error message when ran a query to occur a global transaction on a writer node before INC is resumed between a coordinator node and a writer node.
[Sample Error Message]
I. 12/20 10:12:36. 0000228231 Exception Thrown from dblib/db_catalog.cxx:824, Err# 5, tid 5 origtid 5
I. 12/20 10:12:36. 0000228231 O/S Err#: 0, ErrID: 12291 (inc_CommandHandlerException); SQLCode: -1006274, SQLState: 'QBC74', Severity: 14
I. 12/20 10:12:36. 0000228231 [22036]: Transaction cannot continue due to unrecoverable INC failure. Roll back current transaction.
-- (dblib/db_catalog.cxx 824)
Read more...
Environment
SAP IQ 16.0 Multiplex ( MPX )
Product
Keywords
KBA , BC-SYB-IQ , Sybase IQ , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.