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

• HADR command to materialize database master fails:
  sap_materialize auto, SITE1, SITE2, master
  
• Checking the execution of the command reports error:
  sap_status task
   TASKNAME                     TYPE                          VALUE                                                                                                                                                                                                                                  ---------------------------- ----------------------------- -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

   Status                       Start Time                    Tue Jun 28 13:02:48 EDT 20xx
   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 20xx
   Materialize                  Task End                      Tue Jun 28 13:02:50 EDT 20xx
   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)

• 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

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 , How To