Troubleshooting Common Installation Problems

Identify the cause of installation problems and apply the recommended solutions.

If your installation fails, review error messages and your SAP ASE error log to determine the cause of the failure.

ProblemResolution
Cannot connect in a multiengine environment.
If you are using HP-UX Itanium 11.31, you may experience Client-Library (CTLIB) connection problems in a multiengine environment.
To correct the problem, install these patch bundles onto hpia209:
  • FEATURE11i – B.11.31.0803.318b Feature Enablement Patches for HP-UX 11i v3, March 2008
  • HWEnable11i – B.11.31.0803.318a Hardware Enablement Patches for HP-UX 11i v3, March 2008
  • QPKBASE – B.11.31.0803.318a Base Quality Pack Bundle for HP-UX 11i v3, March 2008
Cannot use X-Windows.
If the setup and configuration utilities do not show correctly, you may need to adjust the resolution on your monitor.
To change to a smaller font size, issue the following UNIX commands:
% cd $SYBASE/ASE-16_0
% chmod +w xappdefaults
% cd xappdefaults
% chmod +w *
% foreach i(*) 
? cat $i | sed -e "s/140/100/g" | sed -e "s/^#D/D/g" | sed -e "s/^#S/S/g" > p
? mv p $i
? end
%
The installation utilities will now use approximately 25 percent less window space.
Cannot eject the CD or DVD from the drive.
If you cannot eject the CD from the drive, check:
  • Whether the disk drive path is the current directory (pwd) in a UNIX terminal window. If it is, change (cd) to another directory.
  • For sybhelp processes. If these processes exist, kill them using the UNIX kill command.
DISPLAY environment variable not set correctly.
The resolution to the DISPLAY variable problem should instruct you to open Exceed (under Hummingbird Connectivity) and set DISPLAY equal to hostname:b, where b is the number in the parentheses following Exceed in the Exceed window.
Client not authorized to connect to server.
This error message means a remote machine does not have permission to display the user interface on the local machine where you start working:
Xlib: connection to "host_name" refused by server
Xlib: Client is not authorized to connect to Server
xhost: unable to open display "host_name"
To correct the problem:
  1. Enter the following command at the UNIX prompt of your local machine, where remote_machine is the machine on which you are running the installer:
    xhost +remote_machine
  2. Restart the installer.
Address already in use.
Enter a different port number on the srvbuild window. The command netstat -a produces a list of port numbers in use.
SAP ASE fails to start.
The shared memory of the operating system may not be set high enough. Adjust the shared memory value. Restart the installation or upgrade process.
The installer fails to start.

Verify that the operating system has all the patches required by the SAP JRE.

Cannot start XP Server.
You may receive the following message from XP Server when it is invoked by xp_cmdshell or some other extended stored procedure:
Msg 11018, Level 16, State 1:
Procedure "xp_cmdshell", Line 2:
XP Server must be up for ESP to execute.
(return status = -6)

Verify that there is an XP Server entry in the SAP ASE sysservers table. If you created XP Server in a different srvbuild session than SAP ASE and you did not specify a related SAP ASE server, srvbuild cannot update the sysservers table. Verify that the XP server exists in the interfaces file or LDAP server.

Use sp_addserver to add an entry to the sysservers table.

Troubleshooting resource file installations.
If you encounter problems during the build, configuration, or upgrade process while using the srvbuild[res], sqlloc[res], or sqlupgrade[res], it may be that these utilities did not allow enough time for a SAP ASE server to shut down properly. Set the SYBSHUTWAIT environment variable to force the utilities to wait for the SAP ASE server to shut down. For example, this command forces the utility to wait for two minutes before proceeding with the next task:
% setenv SYBSHUTWAIT 120
Parent topic: Troubleshoot the Server