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.