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
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.