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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.