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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview