SAP Knowledge Base Article - Preview

2173244 - Scheduled events are running on all nodes - SAP IQ

Symptom

  • After scheduled event is created in a multiplex environment, if the event handler runs at certain time & has some writes on common table, all nodes will try to lock table at the same time. 
  • Some transactions are going to roll back with "table locked" message.
  • error message:
    Exception Thrown from dblib/db_catalog.cxx:2930, Err# 0, tid 19 origtid 19
    O/S Err#: 0, ErrID: 5122 (st_sacbexception); SQLCode: 0, SQLState: '00000', Severity: 10


Read more...

Environment

SAP IQ 16

Product

SAP IQ 16.0

Keywords

event, table locked , KBA , BC-SYB-IQ , Sybase IQ , How To

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.