SAP Knowledge Base Article - Preview

3150646 - WARNING #5185 after rematerializing a database - SRS 16.0

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.