SAP Knowledge Base Article - Preview

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

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

Product

SAP Adaptive Server Enterprise 16.0

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.