SAP Knowledge Base Article - Preview

2933494 - Errors 30056 and 5185 after enabling parallel_dist - SRS 16.0

Symptom

  • In HADR system, after enabling parallel_dist for the inbound connection, the following messages are reported for the inbound queue in the SRS errorlog:

ERROR #30056 USER(DR_admin) - /generic/exec/dist.c(16132)
Change parallel_dist setting failed: Quiesce DIST timeout because there are still large transaction candidates in (SITE1_R2.DB) SQT cache.
Commit or rollback all existing large open transactions at primary database, then change parallel_dist setting again.

  • Few hours later, DSI EXEC get suspended with this message reported for the outbound queue:

WARNING #5185 DSI EXEC(107(5) SITE2.DB) - generic/dsi/hqexec.c(6086) 
Row count mismatch for the command executed on 'SITE2.DB'. The command impacted 0 rows but it should impact 1 rows

  • There is no error sent back to the DR_admin user and the parallel_dist setting is changed.


Read more...

Environment

  • SAP Replication Server (SRS) 16.0 
  • SAP Adaptive Server Enterprise (ASE) 16.0 with Always-On Option (HADR)

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 16.0

Keywords

CR821735, 821735, CR#821735 , KBA , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed

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.