SAP Knowledge Base Article - Preview

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"(:?,:?,:?,:?,:?,:?,:?,:?)
    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.




  • SAP IQ 16.0
  • Multiplex


SAP IQ 16.0


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.