Symptom
- IQ abort after a cancellation request and with the stack trace below.
- The process that crashed the IQ server runs regularly. Thus, the crash is not reproduceable at will.
Excerpt of IQMSG
Exception Thrown from slib/s_dpNBit.cxx:953, Err# 0, tid 24 origtid 24
O/S Err#: 0, ErrID: 519 (hos_attnexception); SQLCode: -299, SQLState: '57014', Severity: 16
[2188]: Statement interrupted by user
**************************************************
*** SAP IQ Abort:
*** Rethrown from: oslib/hos_throw.cxx:281
*** PID: 17667
*** Exception Location: 0xcee0b8
*** Error ID: 519, Exception Type: hos_attnexception
*** Thread: 202 (TID: 24, Original TID: 24)
*** Error #: 0, O/S Error #: 0
*** Argument:
-- (slib/s_dpNBit.cxx 953)
**************************************************
** Command text:
lock table "table_A" in write mode wait '00:30:00';
update "table_b"
set "col0" = :p0,
"col1" = :p1,
"col2" = :p2,
"col26" = :p26
where "col27" = :p27
void hos_ABORT
void Throw
void hos_attention::_Check
void*s_LOBCursor::Next
int hos_dmConvert_LONGVARCHAR_VCHAR
int hos_dmConvert
RWCString&dfe_HostVar::Display
void dfo::AttachStatsForDFE
void dfo::GatherPlanStats
void dfo_Root::Complete
st_cursor::~st_cursor
__SLIP.DELETER__AB
void db_sqlinsert::Shutdown
db_sqlinsert::~db_sqlinsert
void hos_ObjectStack::Throw
void Throw
void hos_attention::_Check
void s_dictionary::ReallocateStrTab
void s_dpNBit::Delete
int hs_dp::DeleteNBit
void hs_dp::DeleteInternal
void hs_dp::Delete
unsigned hs_dpUpdate::Prepare
void db_sqlinsert::UpdatePrepare
void db_sqlinsert::Prepare
void st_command::DoCmdThroughResourceGate
unsigned st_iqdml::Update
UIQDML_Update
Read more...
Environment
SAP IQ 16.1
Product
Keywords
827623; CR827623; CR#827623, 'SQL Anywhere Error -299: Statement interrupted by user' , KBA , BC-SYB-IQ , Sybase IQ , Known Error
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.