2508976 - 'SQLCODE -210' error happens in a multiplex environment - SAP IQ

• In a multiplex environment, 'sqlcode -210' error happened when running an event.
• The event calls a procedure which inserts one rows into an IQ base table.
  Connect: SA connHandle: 9 SA connID: 16 IQ connID: 0000000853 User: dbo
  sqlcode -210
  string_id 2169
  _sqlstate 67792968
  odbc30state 67108865
  sybcode 8405
  severity 21
  odbc20state 67108865
  Exception Thrown from dblib/db_catalog.cxx:2972, Err# 0, tid 6 origtid 6
  O/S Err#: 0, ErrID: 5122 (st_sacbexception); SQLCode: 0, SQLState: '00000', Severity: 10
  .......................
  <,9,PREPARE,call "sp_iqmpxgloballocktable"(:?,:?,:?,:?,:?,:?,:?,:?)
  >,9,PREPARE,65539
  <,9,OPEN,65539
  E,9,-210,User 'another user' has the row in 'T1' locked
  ==========================================================================================
• The 'sqlcode -210' happens when any other connection tries to run a DML statement against the same table at the same time, but no connections were running any DMLs at that time.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP IQ 16.0
• Multiplex

SAP IQ, IQ, SQLCODE -210, -210, another user, locked, lock table , KBA , BC-SYB-IQ , Sybase IQ , How To