Troubleshooting
Problem
After deploying the configuration, when starting the services using the toolkit command (setup -t start), an error is generated with the following exceptions: ... # [onyx-services-ar] Servlet registered # [onyx-services-ar] Application initializing... # [onyx-services-ar] ApplicationLifecycleManager encountered a problem communicating with the database that it cannot recover from. # [onyx-services-ar] Exception during initialization. The application is in an unusable state. # [onyx-services-ar] Errors occurred accessing system resources from ApplicationLifecycleManager: # [onyx-services-ar] Failed Resource Type: [DATABASE]: Unable to perform an operation against one of the data sources for the ApplicationLifecycleManager.
Symptom
The wlp\usr\servers\onyx\server\logs\messages.log shows the following:
[16-04-18 12:14:17:439 CLST] 0000003c com.ibm.ws.concurrent.internal.SubmittedTask E CWWKC1101E: La tarea com.i2group.apollo.servlet.ApplicationLifecycleManager$2@e751990d, enviada al servicio ejecutor wm/startupExecutor, ha fallado con el error siguiente: java.lang.IllegalStateException: I2ANALYZE_STATUS:0005 - Exception during initialization. The application is in an unusable state.
at com.i2group.apollo.servlet.ApplicationLifecycleManager.startServicesOrThrow(ApplicationLifecycleManager.java:385)
at com.i2group.apollo.servlet.ApplicationLifecycleManager.access$200(ApplicationLifecycleManager.java:57)
at com.i2group.apollo.servlet.ApplicationLifecycleManager$2.run(ApplicationLifecycleManager.java:269)
at com.ibm.ws.concurrent.internal.SubmittedTask.run(SubmittedTask.java:275)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:522)
at java.util.concurrent.FutureTask.run(FutureTask.java:277)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.lang.Thread.run(Thread.java:785)
Caused by: com.i2group.apollo.common.exception.SystemResourceRuntimeException: Failed Resource Type: [DATABASE]: Unable to perform an operation against one of the data sources for the ApplicationLifecycleManager. Check stack trace for further details.
at com.i2group.apollo.common.exception.SystemResourceRuntimeException.createNewExceptionOutOfContext(SystemResourceRuntimeException.java:319)
at com.i2group.apollo.common.exception.SystemResourceRuntimeException.createNewDatabaseExceptionOutOfContext(SystemResourceRuntimeException.java:88)
at com.i2group.apollo.service.internal.ExceptionLogger.logAndGetException(ExceptionLogger.java:174)
at com.i2group.apollo.service.internal.ExceptionLogger.translateAndLog(ExceptionLogger.java:120)
at com.i2group.apollo.servlet.ApplicationLifecycleManager.startServicesOrThrow(ApplicationLifecycleManager.java:375)
... 8 more
Caused by: <openjpa-2.2.3-SNAPSHOT-r422266:1802153 nonfatal user error> org.apache.openjpa.persistence.ArgumentException: No se ha podido ejecutar la consulta "null". Compruebe que la sintaxis de consulta sea correcta. Consulte la excepci�n anidada para conocer los detalles.
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:879)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:801)
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:286)
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:302)
at com.ibm.ws.persistence.QueryImpl.getResultList(QueryImpl.java:118)
at org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:330)
at com.i2group.apollo.versioncheck.internal.VersionCheckDAO.retrieveVersion(VersionCheckDAO.java:54)
at com.i2group.apollo.versioncheck.internal.CodeAndDatabaseVersionValidator.checkDatabaseVersionMatchesCodeVersionOrThrow(CodeAndDatabaseVersionValidator.java:51)
at com.i2group.apollo.versioncheck.internal.VersionCheckDelegate.checkDatabaseVersionMatchesCodeVersionOrThrow(VersionCheckDelegate.java:38)
at com.i2group.apollo.jta.internal.SessionInterceptorBase.invoke(SessionInterceptorBase.java:81)
at com.i2group.apollo.service.AccessibleScopeInterceptor.invoke(AccessibleScopeInterceptor.java:42)
at com.i2group.apollo.servlet.VersionCheckInitializer.checkDatabaseVersionMatchesCodeVersion(VersionCheckInitializer.java:44)
at com.i2group.apollo.servlet.ApolloWriteSideContextListenerHelper.performCustomValidation(ApolloWriteSideContextListenerHelper.java:22)
at com.i2group.apollo.servlet.ApplicationLifecycleManager$3.execute(ApplicationLifecycleManager.java:523)
at com.i2group.apollo.servlet.ApplicationLifecycleManager$3.execute(ApplicationLifecycleManager.java:519)
at com.i2group.apollo.common.orm.internal.RobustDatabaseTaskExecutor.execute(RobustDatabaseTaskExecutor.java:106)
at com.i2group.apollo.servlet.ApplicationLifecycleManager.startServices(ApplicationLifecycleManager.java:479)
at com.i2group.apollo.servlet.ApplicationLifecycleManager.startServicesOrThrow(ApplicationLifecycleManager.java:357)
... 8 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: "DB2ADMIN.DATABASE_VERSIONS" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=4.21.29 {prepstmnt -1506548140 SELECT MAX(t0.database_version) FROM Database_Versions t0 optimize for 1 row} [code=-204, state=42704]
...
Cause
This error occurred because the AR database (WRITESTO) did not get created or updated with the tables. This can occur if you set create-database="false" in the topology.xml file when you deployed the configuration.
Resolving The Problem
Modify the ...\toolkit\configuration\environment\topology.xml file to set create-database="true", then rerun the toolkit command to deploy again: setup -t deploy
Historical Number
TS000214264
Product Synonym
EIA
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg22016221