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.