Troubleshooting
Problem
When the service is running, Cognos does not log any information in the Audit database tables even when the database tests OK. An error message seen in the logs and in the details of startup:
StartService LogService Failed Log Server socket error <parameters><item name="Port"><![CDATA[XXXX]]></item><item name="Error"><![CDATA[Address already in use: Cannot bind]]></item></parameters>
Symptom
While the service is stopped, you can check the current active ports via:
Windows - in the cmd window run the command "netstat -a" to give a list for the ports, look through this list to see if the port number XXXX is listening.
Unix - run the command " sudo netstat -tulpn | grep LISTEN " and see if the port XXXX is present.
Resolving The Problem
The error message above tells us that the logging port is already in use. This needs to be changed to a new port or the current process using the port needs to be stopped.
To change the port number, modify the following:
1) Go into Cognos configuration.
2) Under environment -> logging, change the value of the "local log server port number". The default is 9362 but if this does not work try 19362 or any other free port.
3) Save the configuration and re-start the services.
4) Check the audit database to ensure logging
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1.x, 11.0.x","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
01 May 2019
UID
ibm10883062