2508976 - 'SQLCODE -210' error happens in a multiplex environment. | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2508976 - 'SQLCODE -210' error happens in a multiplex environment.

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.

==========================================================================================
I. 07/05 01:53:00. 0000000853 Connect: SA connHandle: 9 SA connID: 16 IQ connID: 0000000853 User: dbo
I. 07/05 01:53:00. 0000000853 sqlcode -210
I. 07/05 01:53:00. 0000000853 string_id 2169
I. 07/05 01:53:00. 0000000853 _sqlstate 67792968
I. 07/05 01:53:00. 0000000853 odbc30state 67108865
I. 07/05 01:53:00. 0000000853 sybcode 8405
I. 07/05 01:53:00. 0000000853 severity 21
I. 07/05 01:53:00. 0000000853 odbc20state 67108865
I. 07/05 01:53:00. 0000000853 Exception Thrown from dblib/db_catalog.cxx:2972, Err# 0, tid 6 origtid 6
I. 07/05 01:53:00. 0000000853 O/S Err#: 0, ErrID: 5122 (st_sacbexception); SQLCode: 0, SQLState: '00000', Severity: 10
I. 07/05 01:53:00. 0000000853 [2000]:
.......................
.......................
I. 07/05 01:53:00. <,9,PREPARE,call "sp_iqmpxgloballocktable"(:?,:?,:?,:?,:?,:?,:?,:?)
I. 07/05 01:53:00. >,9,PREPARE,65539
I. 07/05 01:53:00. <,9,OPEN,65539
I. 07/05 01:53:00. 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.

SQLCODE -210.PNG


Read more...

Environment

16.0.102.6.1361/20130/P/sp10.11/Enterprise Linux64 - x86_64 - 2.6.18-194.el5/64bit/2016-03-10 22:33:35
Multiplex

Product

SAP IQ 16.0

Keywords

SAP IQ, IQ, SQLCODE -210, -210, another user, locked, lock table , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.