SAP Knowledge Base Article - Preview

2268272 - SAP IQ Cockpit does not start and fails with "Failed to initialize SQLAnywhere installation environment" error.

Symptom

End-user tries to start SAP IQ cockpit using cockpit.sh. Cockpit does not start and shuts down immediately.

Following symptoms and error messages are observed.

  • Even though Cockpit did not start, SQL anywhere process is observed.


$ ps -ef | grep dbsrv16

enduser 15094 1 0 12:34 pts/3 00:00:37 /opt/sybase/COCKPIT-4/bin/sa16/linux64/bin64/dbsrv16 -n cockpit[myhost:4638] -o /opt/sybase/COCKPIT-4/log/sqlanywhere-server.log -qi -qw -z -ze -sb 0 -gn 100 -gm 500 -zl -zp -c 100m -ch 1G -xd -su @/opt/sybase/COCKPIT-4/services/SccSADataserver/utildb.cfg -gn 100 -x TCPIP{port=4638} -xd

  • Following errors are found in agent.log

    2016-01-18 12:34:47,317 [INFO ] [iqap.IQAgentPlugin ] [main] - OS bit: 64.
    2016-01-18 12:35:42,591 [ERROR] [asa.ASAEngine ] [main] - Failed to connect to dataserver engine. Failed to connect to utility_db
    com.sybase.ua.services.asa.ASAEngine$ConnectionFailedException: Failed to connect to utility_db
    at com.sybase.ua.services.asa.ASAEngine.getInternalConnection(Unknown Source)
    at com.sybase.ua.services.asa.ASAEngine.checkConnection(Unknown Source)
    at com.sybase.ua.services.asa.ASAEngine.startEngine(Unknown Source)
    at com.sybase.ua.services.asa.ASAInstanceManagerService.startEngine(Unknown Source)
    at com.sybase.ua.services.asa.ASAInstanceManagerService.doStart(Unknown Source)
    at com.sybase.ua.service.AgentServiceBase.start(Unknown Source)
    at com.sybase.ua.services.AgentLifecycleManager.startService(Unknown Source)
    at com.sybase.ua.services.AgentLifecycleManager.startServices(Unknown Source)
    at com.sybase.ua.services.AgentLifecycleManager.startAgent(Unknown Source)
    at com.sybase.ua.services.Agent.doStart(Unknown Source)
    at com.sybase.ua.service.AgentServiceBase.start(Unknown Source)
    ...

   2016-01-18 12:35:42,592 [FATAL] [asa.ASAInstanceManagerService ] [main] - Failed to start database engine java.lang.IllegalStateException: The "cockpit[myhost:4638]" dataserver Engine could not be started

   com.sybase.ua.service.AgentServiceException: Failed to start database engine java.lang.IllegalStateException: The "cockpit[myhost:4638]" dataserver Engine could not be started
   at com.sybase.ua.services.asa.ASAInstanceManagerService.startEngine(Unknown Source)
   at com.sybase.ua.services.asa.ASAInstanceManagerService.doStart(Unknown Source)
   at com.sybase.ua.service.AgentServiceBase.start(Unknown Source)
   at com.sybase.ua.services.AgentLifecycleManager.startService(Unknown Source)
   at com.sybase.ua.services.AgentLifecycleManager.startServices(Unknown Source)
   at com.sybase.ua.services.AgentLifecycleManager.startAgent(Unknown Source)
   at com.sybase.ua.services.Agent.doStart(Unknown Source)
   at com.sybase.ua.service.AgentServiceBase.start(Unknown Source)
   at com.sybase.ua.services.Agent.startAgent(Unknown Source)
   at com.sybase.ua.startup.Main.startAgent(Unknown Source)
   at com.sybase.ua.startup.Main.start(Unknown Source)
   ...

   2016-01-18 12:35:42,593 [FATAL] [asa.ASAInstanceManagerService ] [main] - Dumping Trace Queue for SQLAnywhere-init
   2016-01-18 12:35:42,593 [FATAL] [asa.ASAInstanceManagerService ] [main] - Number of Trace Entries is 26
   2016-01-18 12:35:42,593 [FATAL] [asa.ASAInstanceManagerService ] [main] - Number of Trace Puts is 26
   2016-01-18 12:35:42,593 [FATAL] [asa.ASAInstanceManagerService ] [main] - Trace Entries:
   ...

   2016-01-18 12:35:42,598 [FATAL] [asa.ASAInstanceManagerService ] [main] - *** END OF TRACE ***   2016-01-18 12:35:42,598 [ERROR] [services.Agent ] [main] - Failed to successfully start agent: Failed to start ASAInstanceManagerService. ...
   at com.sybase.ua.service.AgentBundleException: Failed to initialize SQLAnywhere installation environment
   at com.sybase.ua.service.AgentServiceException: Failed to start ASAInstanceManagerService. Failed to initialize SQLAnywhere installation environment com.sybase.ua.service.AgentBundleException: Failed to initialize SQLAnywhere installation environment
   at com.sybase.ua.services.AgentLifecycleManager.startService(Unknown Source)
   at com.sybase.ua.services.AgentLifecycleManager.startServices(Unknown Source)
   at com.sybase.ua.services.AgentLifecycleManager.startAgent(Unknown Source)
   at com.sybase.ua.services.Agent.doStart(Unknown Source)
   at com.sybase.ua.service.AgentServiceBase.start(Unknown Source)
   at com.sybase.ua.services.Agent.startAgent(Unknown Source)
   at com.sybase.ua.startup.Main.startAgent(Unknown Source)
   at com.sybase.ua.startup.Main.start(Unknown Source)
   ...

   2016-01-18 12:35:42,600 [INFO ] [services.Agent ] [main] - Scheduling immediate shutdown.
   2016-01-18 12:35:42,600 [INFO ] [services.Agent ] [main] - Shutting down now.


Read more...

Environment

  • IQ SP 08+
  • Any platform

Product

SAP IQ 16.0

Keywords

login ; dba ; password , KBA , BC-SYB-IQ , Sybase IQ , 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.