SAP Knowledge Base Article - Preview

2045367 - Error "The row count in the Master database does not match between source and target systems" - SAP SRS

Symptom

  • During installing HADR, below error occurs at the 'Materialization' step, when trying to materialize Master database

    INFO       2014-04-15 13:11:44.565
               CJSlibModule::writeInfo_impl()
    Execution of the command "isql64 -w999 -UDR_admin -S<SID>:<port> -X" finished with return code 0. Output:
    Password:
     TaskName                      Type                           Value
     ----------------------------- ------------------------------ -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Materialize                   Start Time                     2014-04-15 13:11:07.665
     Materialize                   Elapsed Time                   00:00:34
     Materialize                   Task Name                      Materialize
     Materialize                   Task State                     Error
     Materialize                   Short Description              Materialize database
     Materialize                   Long Description               Starting materialization of the master database from source '<primary_hostname>' to target '<standby_hostname>'.
     Materialize                   Hostname                       '<primary_hostname>'
     PerformMasterMaterialization  Task Name                      Materialize the Master database
     PerformMasterMaterialization  Task State                     Error
     PerformMasterMaterialization  Short Description              Materializes the Master database by using a bulk copy utility to copy necessary tables.
     PerformMasterMaterialization  Long Description               Comparing the rows counts after the bulk copy operations for the 'master' database between source host '<primary_host_name'>and target host '<standby_host_name>'
     PerformMasterMaterialization  Failing Command Error Message  The row count in the Master database does not match between source and target systems.  Table 'master..sysloginroles' has source row count '20' but target row count '21'., The row count in the Master database does not match between source and target systems.  Table 'master..sysprotects' has source row count '378' but target row count '380'.
     PerformMasterMaterialization  Corrective Action              Verify no user or security request are being performed on the source system and retry materialization.
     PerformMasterMaterialization  Current Task Number            5
     PerformMasterMaterialization  Total Number of Tasks          7
     PerformMasterMaterialization  Hostname                       <host_name>

    (16 rows affected)

  • Note the table reported in the error could also be 'master..syslogins' , 'master..sysloginroles' or 'master..sysattributes'


Read more...

Environment

  • SAP ASE for Business Suite 15.7 SP110 and higher
  • SAP Replication Server 15.7.1 SP 111 and higher - Certified for Business Suite

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Replication Server 15.7

Keywords

Perform Master Materialization, Disaster Recovery, row count mismatch , KBA , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.