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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.