2757742 - sap_materialize fails at task 'Ase Dump and Load' with return code 3216

• You have configured ASE for multiple network handlers, so there're more than one IP address in interface file, but you only maintain one entry in /etc/hosts file.
• You are doing database materialization with auto option in an HADR system.
• Below errors occur in sap_status task for task name 'Ase Dump and Load':
  

  1> sap_status task
  2> go
  TASKNAME TYPE VALUE
  ---------------- ----------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  Status Start Time Sun Feb 17 17:44:25 CST 2019
  Status Elapsed Time 00:13:10
  Materialize Task Name Materialize
  Materialize Task State Error
  Materialize Short Description Materialize database
  Materialize Long Description Executing ASE dump and load task for database 'SID'.
  Materialize Task Start Sun Feb 17 17:44:25 CST 2019
  Materialize Task End Sun Feb 17 17:57:35 CST 2019
  Materialize Hostname host1.sap.com
  ASEDBDumpAndLoad Task Name Ase Dump and Load
  ASEDBDumpAndLoad Task State Error
  ASEDBDumpAndLoad Short Description Dump and Load an Adaptive Server Enterprise database
  ASEDBDumpAndLoad Long Description Attempting to bring database 'SID' online.
  ASEDBDumpAndLoad Failing Command Return Code 3216
  ASEDBDumpAndLoad Failing Command Error Message Error occurred during load process.
  ASEDBDumpAndLoad Failing Exception Message: 'Backup Server session id is: 42. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.' Cause: ''.
  ASEDBDumpAndLoad Current Task Number 2
  ASEDBDumpAndLoad Total Number of Tasks 2
  ASEDBDumpAndLoad Hostname host1.sap.com

• At same time you notice error in RMA log:
  

  [INFO ] [Materialize:30204][RMA] - [com.sybase.ua.plugins.dr.] - Executing 'load database SID from '/sybase/SID/data/SID_01.dmp' at 'host1:4902' stripe on '/sybase/SID/data/SID_02.dmp' at 'host1:4902' stripe on '/sybase/SID/data/SID_03.dmp' at 'host1:4902' stripe on '/sybase/SID/data/SID_04.dmp' at 'host1:4902'' on the ASE at host2:4901.
  [INFO ] [Thread-24980:29989][RMA] - [RuntimeCommandWrapper ] - TDS LANGUAGE: sap_status task
  [INFO ] [Thread-24980:29989][RMA] - [RuntimeCommandWrapper ] - TDS LANGUAGE: sap_status task
  [WARN ] [Materialize:30204][RMA] - [com.sybase.ua.plugins.dr.] - Failed executing load command from the remote host 'host1:4902'.
  [WARN ] [Materialize:30204][RMA] - [com.sybase.ua.plugins.dr.] - SQL ERROR -- Message: 'Backup Server: 5.16.2.2: Client-Library error: Error number 4, Layer 5, Origin 3, Severity 17179869189: ct_connect(): network packet layer: internal net library error: Net-Lib protocol driver call to connect two endpoints failed.' SQLState: 'null' Remote Code: '501602' Cause: ''.SQL ERROR -- Message: 'Backup Server: 5.3.2.1: Cannot open a connection to the subordinate* site 'host1 4902'.
  Start the remote Backup Server if it is not running.' SQLState: 'null' Remote Code: '500302' Cause: ''.SQL ERROR -- Message: 'Error encountered by Backup Server. Please refer to Backup Server messages for details.' SQLState: 'ZZZZZ' Remote Code: '8009' Cause: ''.SQL WARNING -- Message: 'Backup Server session id is: 76. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.' SQLState: '01ZZZ' Remote Code: '3216' Cause: ''.
  [INFO ] [Materialize:30204][RMA] - [com.sybase.ua.plugins.dr.] - Retry the load command with remote host name 'host1:4902'.
  [INFO ] [Materialize:30204][RMA] - [com.sybase.ua.plugins.dr.] - Executing 'load database SID from '/sybase/SID/data/SID_01.dmp' at 'host1:4902' stripe on '/sybase/SID/data/SID_02.dmp' at 'host1:4902' stripe on '/sybase/SID/data/SID_03.dmp' at 'host1:4902' stripe on '/sybase/SID/data/SID_04.dmp' at 'host1:4902'' on the ASE at host2:4901.
  [WARN ] [Materialize:30204][RMA] - [com.sybase.ua.plugins.dr.] - Failed retrying the load command with remote host name 'host1:4902'.
  [WARN ] [Materialize:30204][RMA] - [com.sybase.ua.plugins.dr.] - SQL ERROR -- Message: 'Backup Server: 5.16.2.2: Client-Library error: Error number 4, Layer 5, Origin 3, Severity 17179869189: ct_connect(): network packet layer: internal net library error: Net-Lib protocol driver call to connect two endpoints failed.' SQLState: 'null' Remote Code: '501602' Cause: ''.SQL ERROR -- Message: 'Backup Server: 5.3.2.1: Cannot open a connection to the subordinate* site 'host1 4902'.
  Start the remote Backup Server if it is not running.' SQLState: 'null' Remote Code: '500302' Cause: ''.SQL ERROR -- Message: 'Error encountered by Backup Server. Please refer to Backup Server messages for details.' SQLState: 'ZZZZZ' Remote Code: '8009' Cause: ''.SQL WARNING -- Message: 'Backup Server session id is: 78. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.' SQLState: '01ZZZ' Remote Code: '3216' Cause: ''.

SAP Adaptive Server Enterprise (ASE) 16.0 SP03

connection, communication, network interface cards, NIC, interfaces, network handlers, hosts , KBA , slave , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , BC-SYB-REP , Sybase Replication Server (standalone) , Problem