SAP Knowledge Base Article - Preview

1910174 - IIn multiplex, a Writer node receives an exception with SQLCode -299, SQLState 57014 and a client query is aborted. - SAP IQ

Symptom

  • A Writer node in a multiplex is receiving many errors with SQLCode -299 and SQLState 57014 throughout the day. 
  • Though the error in the message file indicates the statement was interrupted by a user (such as control-C), no user has issued an abort of the operation.
  • When the same (failed) job is restarted, it runs to completion without any problems.
  • This is a fragment from the .iqmsg file:

Exception Thrown from st_command.cxx:618, Err# 0, tid 117 origtid 117
O/S Err#: 0, ErrID: 5125 (st_commandException); SQLCode: -299, SQLState: '57014', Severity: 16
[2188]: Statement interrupted by user
Exception Thrown from st_command.cxx:618, Err# 0, tid 123 origtid 123
O/S Err#: 0, ErrID: 5125 (st_commandException); SQLCode: -299, SQLState: '57014', Severity: 16
[2188]: Statement interrupted by user
Rbck.


Read more...

Environment

  • SAP IQ 15.x
  • SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

interrupt, cancel, ct_cancel, coordinator, resource, host , 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.