SAP Knowledge Base Article - Preview

3224065 - sap_materialize auto for master fails with error during copy of table master..syslogins - SRS

Symptom

  • HADR command to materialize database master fails :
          sap_materialize auto, SITE1, SITE2, master

  • Checking the execution of the command reports error :
     

    1> sap_status task
    2> go
     TASKNAME                     TYPE                          VALUE                                                                                                                                                                                                                                                       
     ---------------------------- ----------------------------- -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Status                       Start Time                    Tue Jun 28 13:02:48 EDT 2022
     Status                       Elapsed Time                  00:00:02
     Materialize                  Task Name                     Materialize
     Materialize                  Task State                    Error
     Materialize                  Short Description             Materialize database
     Materialize                  Long Description              Starting materialization of the master database from source 'SITE1' to target 'SITE2'.
     Materialize                  Task Start                    Tue Jun 28 13:02:48 EDT 2022
     Materialize                  Task End                      Tue Jun 28 13:02:50 EDT 2022
     Materialize                  Hostname                      hostname.xxx
     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              Importing the necessary tables to the 'master' database from source host 'SITE1' to target host 'SITE2'
     PerformMasterMaterialization Current Task Number           6
     PerformMasterMaterialization Total Number of Tasks         14
     PerformMasterMaterialization Hostname                      hostname.xxx
     RunMasterBCPLocally          Task Name                     Execute Bulk Copy for Master database
     RunMasterBCPLocally          Task State                    Error
     RunMasterBCPLocally          Short Description             Executes the Bulk Copy utility for all required Master database tables.
     RunMasterBCPLocally          Long Description              The bulk copy request to 'import' data from source host 'hostname.xxx' for table 'master..syslogins' failed.
     RunMasterBCPLocally          Current Task Number           5
     RunMasterBCPLocally          Total Number of Tasks         9
     RunMasterBCPLocally          Hostname                      hostname.xxx
     RunBcp                       Task Name                     Execute Bulk Copy
     RunBcp                       Task State                    Error
     RunBcp                       Short Description             Executes the Bulk Copy utility to import or export a table from or to a file.
     RunBcp                       Long Description              Running bulk copy procedure to import table 'master..syslogins' as user 'DR_admin' reading input from directory '/sybase/XXX/data'.
     RunBcp                       Failing Command               Running the following bulk copy command :'/sybase/XXX/DM/REP-16_0/install/bcp.sh master..syslogins in /sybase/XXX/data/BCP_syslogins.out -UDR_admin -P******** -SXXX -X -c -J --initstring "delete from master..syslogins where suid not in (1, 2) and name not in ('DR_admin', 'DR_maint')"'.
     RunBcp                       Failing Command Return Code   255
     RunBcp                       Failing Command Error Message The bulk copy routine for table 'master..syslogins' failed with an unexpected return code of '255'.
     RunBcp                       Hostname                      hostname.xxx

    (31 rows affected)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 with Always-on Option (HADR)
  • SAP Adaptive Server Enterprise (ASE) 16.0 with High Availability Disaster Recovery (HADR) for Business Suite

Product

SAP Adaptive Server Enterprise 16.0

Keywords

sap_materialize, master, 'master..syslogins', Execute Bulk Copy, BCP, syslogins, bcp.sh, 255, error , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , 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.