Symptom
- 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.
- 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: ''.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP03 with Always-On option
- SAP Replication Server (SRS) 16.0 SP03
Product
Keywords
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
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.