Symptom
- 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.
Read more...
Environment
- SAP IQ 16.0
- Multiplex
Product
SAP IQ 16.0
Keywords
SAP IQ, IQ, SQLCODE -210, -210, another user, locked, lock table , 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.