Symptom
Replication Server reports Warning #5185 after rematerializing a database:
User 'DR_admin' writes: '** HADR operation: sap_materialize finish, PRI, SEC, <SID>,'
User 'DR_admin' writes: '** Message: is completed' User 'DR_admin' writes: '*******************************************************************************'
...
WARNING #5185 DSI EXEC(107(3) PRE_SEC.<SID>) - generic/dsi/hqexec.c(6086) Row count mismatch for the command executed on 'PRE_SEC.<SID>'.
The command impacted 0 rows but it should impact 1 rows.(HQ Error): update SAPSR3."table1" set xxxxx...
A parallel transaction has failed in database 'PRE_SEC.<SID>'. The transaction will be executed individually.
(427): HQCPL: HQ execution exception occurred while applying to table [nil][nil]...
(429): HQCPL: HQ execution exception occurred while applying to table [nil][nil]...
A parallel transaction has failed in database 'PRE_SEC.<SID>'. The transaction will be executed individually.
A parallel transaction has failed in database 'PRE_SEC.<SID>'. The transaction will be executed individually.
WARNING #5185 DSI EXEC(107(4) PRE_SEC.<SID>) - generic/dsi/hqexec.c(6086) Row count mismatch for the command executed on 'PRE_SEC.<SID>'. The command impacted 0 rows but it should impact 1 rows.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 with Always-on Option (HADR)
- SAP Replication Server (SRS) 16.0
Product
SAP Replication Server 16.0
Keywords
rematerialize, 5185, CR826114, CR#826114, 826114, sap_materialize , KBA , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , Known Error
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