2127757 - Forced merge failing on RLV enabled table - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2127757 - Forced merge failing on RLV enabled table - SAP IQ

Symptom

Forced merge on RLV enabled table is failing due to duplicate key conflict while rows from RLV part of table get merged into base table part ?

Errors can be like this.

------
(DBA)> sp_iqmergerlvstore 'BLOCKING', 'TCAReportData', 'TCA';
Could not execute statement.
Tried to insert a duplicate value into a unique index TCA.TCAReportData.ASIQ_IDX_T766_I328_HG on row 67640301.
--
(slib/s_ohcins.cxx 1999)
SQLCODE=-1002003, ODBC 3 State="HY000"

------
DBA)> ALTER TABLE TCA.TCAReportData DISABLE RLV STORE;
Could not execute statement.
An RLV forced merge on table 'TCAReportData' has failed
SQLCODE=-1712, ODBC 3 State="HY000"
------


Read more...

Environment

SAP IQ 16

Product

SAP IQ 16.0

Keywords

sp_iqmergerlvstore , 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.