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