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 : Transaction cannot continue due to unrecoverable INC failure. Roll back current transaction.
-- (dblib/db_catalog.cxx 824)
SAP IQ 16.0 Multiplex ( MPX )
KBA , BC-SYB-IQ , Sybase IQ , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.