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.
SAP Knowledge Base Article - Preview