SAP Knowledge Base Article - Preview

2337503 - Writer abort in inc_CommandHandler::INCGlobalThrow - SAP IQ 16

Symptom

SAP IQ 16 MPX Writer could crash when cancelling a DDL statement.

In IQMSG, the stack trace below is generated and cancellation request message is seen.


**************************************************
***   Sybase IQ Abort:
***      From:  oslib/hos_except.cxx:721
***      PID: 47241
***      Message: more than HOS_ERROR_SUBSTITUTION_NUM args used
***      Thread: 2798069504  (TID: 19)
**************************************************

**  Parser command text: 

drop table "owner"."TableName"

    ***************** This is the STACKTRACE ***************

hos_exception::SetArgStr
inc_CommandHandlerException::inc_CommandHandlerException
inc_CommandHandler::INCGlobalThrow
db_iqddl::RunINCDDL
UIQDDL_RunINCDDL
st_SAIQInterfaceInfo::callFunction()
st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholdddl::RunGlobalDDL
iqmpx_dispatch_global_ddl
DoExecuteStmt
db__execute
RequestProcedure::call()


GiveForbid
Txn 13322 0 13956
Callback registered
Cancellation request received:  SA connHandle: 12  SA connID: 14  IQ connID: 0000005980  User: DBA
Elapsed time for running DDL over INC:  0:00:14.682753
INC ERROR: sqlcode=-299 error context = 3 file dblib/db_iqddl.cxx lineno 921
GThrow sqlcode : -299
Exception Thrown from dblib/db_iqddl.cxx:921, Err# 5, tid 9 origtid 9
    O/S Err#: 0, ErrID: 12291 (inc_CommandHandlerException); SQLCode: -299, SQLState: '57014', Severity: 16
[2188]: Statement interrupted by user
Rbck
PostRbck


Read more...

Environment

SAP IQ 16

Product

SAP IQ 16.0

Keywords

799201 ; CR 79920 ; MPX ; Multiplex ; Writer ; DDL ; GThrow ; Cancellation request ;
inc_CommandHandler::INCGlobalThrow ; inc_CommandHandler ; INCGlobalThrow ; Statement interrupted ;
iqmpx_dispatch_global_ddl ; UIQDDL_RunINCDDL ; saint_iqthresholdddl::RunGlobalDDL ; saint_iqthresholdddl ; RunGlobalDDL ; , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This 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.