SAP Knowledge Base Article - Preview

3261925 - When trying to insert duplicate value into primary key stored procedure doesn't return error.

Symptom

When trying to insert duplicate value into primary key column dbisql doesn't return any error. The duplicate row will not be inserted and the error is oly reported in iqmsg.
This phenomenon happens when the stored procedure is written by Transact-SQL language.

Exception Thrown from slib/s_ohcins.cxx:964, Err# 0, tid 569 origtid 569
O/S Err#: 0, ErrID: 6145 (hgex_dataexception); SQLCode: -1002003, SQLState: 'QGA03', Severity: 14
[20505]: Tried to insert a duplicate value into a unique index <user>.<table>.<index_HG> on row 2.
-- (slib/s_ohcins.cxx 964)


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ all versions

Keywords

KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem

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.