SAP ASE Troubleshooting

From SEPsesam
Revision as of 16:27, 29 March 2022 by Unknown (talk | contribs) (Updating to match new version of source page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Other languages:
This page is a draft. Treat the information on this page with caution as it may be incomplete.

Copyright © SEP AG 1999-2022. All rights reserved.

Any form of reproduction of the contents or parts of this manual is allowed only with the express written permission from SEP AG. When compiling and designing user documentation SEP AG uses great diligence and attempts to deliver accurate and correct information. However, SEP AG cannot issue a guarantee for the contents of this manual.

Docs latest icon.png Welcome to the latest SEP sesam documentation version 4.4.3 Beefalo/5.0.0 Jaglion. For previous documentation version(s), check documentation archive.


SAP ASE backup fails with Requested server name not found


  • SAP ASE backup fails with CT-LIBRARY error: ... Requested server name not found.


  • The server name hasn't been added to the interface file or the given server name does not exist.


  • If source is set with {server_name} then you probably have mistyped the server name or server's port (default 5000).
  • If source is set without {server_name} then isql looks for the server specified by your DSQUERY environment variable.


  • You have to extend the source with the correct server name and if necessary also the port.
  • Source format [/{server_name}[:{port}]]/{database} For example, if the source is master, you have to add the server name as the first part, e.g. /SOL/master or /SYBASE16:5000/master.
  • Test the connection to SAP ASE server by running the isql utility. For details, see SAP ASE Utility Guide: isql.
  • isql -U<username> -P<password> -S<server_name> where <username> specifies a login name of a user with access to database (login names are case-sensitive!), <password> specifies your SAP ASE password, and <server_name> specifies the name of the SAP ASE server to which to connect. isql looks this name up in the interfaces file.
    If this test fails, use the dsedit utility that allows you to view and edit server entries in the interfaces file using a GUI in Adaptive Server Enterprise. For details, see SAP ASE Utility Guide: dsedit.

SAP ASE backup fails with Failed to load library '' error


  • A backup fails with Failed to load library '' or Failed to load library '%1' error.

Possible causes

  • The library is not copied to the SAP ASE lib directory.
  • A wrong binary library file is used.
  • The LD_LIBRARY_PATH is not set correctly.
  • The SAP ASE backup server is not running on the specified host.


  • Copy the library to the SAP ASE lib directory.
  • Check whether a necessary shared library is installed: file and how it is resolved: ldd
sybase16:/opt/sap/ASE-16_0/lib # file symbolic link to `/opt/sesam/bin/sesam/'
sybase16:/opt/sap/ASE-16_0/lib # file /opt/sesam/bin/sesam/
/opt/sesam/bin/sesam/ ELF 64-bit LSB shared object, x86-64, version 1 (SYSV), dynamically linked, not stripped
sybase16:/opt/sap/ASE-16_0/lib # ldd /opt/sesam/bin/sesam/ =>  (0x00007fffcd75c000) => /lib64/ (0x00007f65d0fa6000) => /lib64/ (0x00007f65d0d9c000) => /lib64/ (0x00007f65d0b7f000) => /lib64/ (0x00007f65d0803000)
       /lib64/ (0x00007f65d1cf3000)
  • Check if the LD_LIBRARY_PATH variable is set correctly in the file SYBASE.env (The SAP shared libraries are located in the installed component’s lib directory).
sybase16:/opt/sap # grep LD_LIBRARY_PATH SYBASE.env
  • Check if the SAP ASE backup server is running on the specified host -> check for the process named backupserver.
sybase16:/opt/sap # ps -ef | grep backupserver
root     15534 15533  0 Mar23 ?        00:00:00 /opt/sap/ASE-16_0/bin/backupserver -e/opt/sap/ASE-16_0/install/qsstor.log -N25 -C20 -I/opt/sap/interfaces -M/opt/sap/ASE-16_0/bin/sybmultbuf -Sqsstor

SAP ASE backup fails with ERROR: No Total: ... line found in LIS file


  • SAP ASE backup fails with the following error: No Total: ... line found in LIS file.


  • sm_backup tried to fetch the LIS file before the backup server has finished.


  • Use the SEP sesam Client ≥ Beefalo V2 SP2 and set the following backup option in the SAP ASE backup task properties -> Options tab -> Backup options field:
  • -a action=sleep:20
    Information sign.png Note
    If the backup option -a action=sleep:xx does not work, use the FTP interface instead of HTTP.

See also

Analyzing SEP sesam Log FilesSAP ASE