Troubleshooting an Error when Executing an ESP

If you receive an error when executing an ESP, check for processes that might be using the same port number.

Prerequisites

Use the netstat command to determine if the port number specified for XP Server is in use.

Task
If you attempt to execute an ESP (extended stored procedure), you may see:
00:00000:00008:1997/09/10 12:52:53.03 kernel  XP Server failed to start. Try bringing up XP Server manually. Check SQL Server documentation for more information on how to bring XP Server up.
  1. If you find no processes using the same port number:
    1. Restart SAP ASE.
    2. Execute the ESP that you attempted earlier.
      XP Server should start automatically.
  2. If you find a process using the same port number, you can:
    1. Change the interfaces file to use a new port number for the XP Server.
    2. Stop the process using the port number allotted to XP Server.
    3. Restart SAP ASE, and execute the ESP that you attempted earlier. XP Server should start automatically.