Invalid column name 'ID' after upgrade to 16.5.0

Peter_de_Vries

I am trying to upgrade my AppWorks-gateway from version 16.2.1 to 16.5.0 however this fails.
I can upgrade to 16.4.0 without problems, but when I upgrade to 16.5.0 (either directly from 16.2.1 or in 2-steps via 16.4.0) the AppWork-gateway wont's start.

The gateway.log shows an error:

2019-04-12 15:49:18,6192019-04-12T15:49:18,619 [localhost-startStop-1] INFO notifications.fcm.FcmConnectionManagerImpl - Db Connected - Registering known FirebaseProjects 2019-04-12 15:49:19,1342019-04-12T15:49:19,134 [localhost-startStop-1] INFO notifications.fcm.FcmProjectFileManagerImpl - Creating new FirebaseProject entry for project appworks-gateway165 2019-04-12 15:49:19,4462019-04-12T15:49:19,446 [localhost-startStop-1] ERROR services.impl.ClusterServiceImpl - eventRepository not available 2019-04-12 15:49:19,4462019-04-12T15:49:19,446 [localhost-startStop-1] ERROR web.context.ContextLoader - Context initialization failed com.opentext.otag.exception.OTAGException: Event Repository not available at com.opentext.otag.services.impl.ClusterServiceImpl.onDbSetup(ClusterServiceImpl.java:64) ~[classes/:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_161] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_161] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_161] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_161] at org.springframework.context.event.ApplicationListenerMethodAdapter.doInvoke(ApplicationListenerMethodAdapter.java:256) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.context.event.ApplicationListenerMethodAdapter.processEvent(ApplicationListenerMethodAdapter.java:177) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.context.event.ApplicationListenerMethodAdapter.onApplicationEvent(ApplicationListenerMethodAdapter.java:140) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:172) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:165) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:139) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:393) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:360) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at com.opentext.otag.events.EventPublisher.publishEvent(EventPublisher.java:39) ~[classes/:?] at com.opentext.otag.config.AWStartupMessageBean.startup(AWStartupMessageBean.java:55) ~[classes/:?] at com.opentext.otag.config.SpringStartupListener.onApplicationEvent(SpringStartupListener.java:28) ~[classes/:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_161] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_161] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_161] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_161] at org.springframework.context.event.ApplicationListenerMethodAdapter.doInvoke(ApplicationListenerMethodAdapter.java:256) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.context.event.ApplicationListenerMethodAdapter.processEvent(ApplicationListenerMethodAdapter.java:177) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.context.event.ApplicationListenerMethodAdapter.onApplicationEvent(ApplicationListenerMethodAdapter.java:140) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:172) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:165) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:139) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:393) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:347) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:883) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:546) ~[spring-context-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443) ~[spring-web-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325) [spring-web-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) [spring-web-4.3.20.RELEASE.jar:4.3.20.RELEASE] at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4842) [catalina.jar:8.0.36] at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5303) [catalina.jar:8.0.36] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147) [catalina.jar:8.0.36] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725) [catalina.jar:8.0.36] at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701) [catalina.jar:8.0.36] at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717) [catalina.jar:8.0.36] at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:587) [catalina.jar:8.0.36] at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1798) [catalina.jar:8.0.36] at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_161] at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_161] at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_161] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_161] at java.lang.Thread.run(Unknown Source) [?:1.8.0_161] Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.1.v20171221-bd47e8f): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'ID'. Error Code: 207 Call: SELECT MAX(ID) FROM EVENT Query: ReportQuery(referenceClass=Event sql="SELECT MAX(ID) FROM EVENT") at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:389) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:262) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:528) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:402) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at com.opentext.otag.persistence.impl.EventRepoImpl.mostRecentSeqNo(EventRepoImpl.java:57) ~[classes/:?] at com.opentext.otag.services.impl.ClusterServiceImpl.onDbSetup(ClusterServiceImpl.java:61) ~[classes/:?] ... 45 more Caused by: org.eclipse.persistence.exceptions.DatabaseException: Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'ID'. Error Code: 207 Call: SELECT MAX(ID) FROM EVENT Query: ReportQuery(referenceClass=Event sql="SELECT MAX(ID) FROM EVENT") at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:688) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:564) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2093) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:600) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:261) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:270) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:256) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:327) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:722) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2740) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllReportQueryRows(ExpressionQueryMechanism.java:2677) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.queries.ReportQuery.executeDatabaseQuery(ReportQuery.java:852) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:911) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1180) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:464) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1268) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2979) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1892) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1874) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:528) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:402) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at com.opentext.otag.persistence.impl.EventRepoImpl.mostRecentSeqNo(EventRepoImpl.java:57) ~[classes/:?] at com.opentext.otag.services.impl.ClusterServiceImpl.onDbSetup(ClusterServiceImpl.java:61) ~[classes/:?] ... 45 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'ID'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc4-4.0.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) ~[sqljdbc4-4.0.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) ~[sqljdbc4-4.0.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) ~[sqljdbc4-4.0.jar:?] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc4-4.0.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) ~[sqljdbc4-4.0.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) ~[sqljdbc4-4.0.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) ~[sqljdbc4-4.0.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285) ~[sqljdbc4-4.0.jar:?] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1012) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:648) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:564) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2093) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:600) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:261) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:270) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:256) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:327) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:722) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2740) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllReportQueryRows(ExpressionQueryMechanism.java:2677) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.queries.ReportQuery.executeDatabaseQuery(ReportQuery.java:852) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:911) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1180) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:464) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1268) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2979) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1892) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1874) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:528) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:402) ~[eclipselink-2.7.1.jar:2.7.1.v20171221-bd47e8f] at com.opentext.otag.persistence.impl.EventRepoImpl.mostRecentSeqNo(EventRepoImpl.java:57) ~[classes/:?] at com.opentext.otag.services.impl.ClusterServiceImpl.onDbSetup(ClusterServiceImpl.java:61) ~[classes/:?] ... 45 more 2019-04-12 15:49:19,4782019-04-12T15:49:19,478 [localhost-startStop-1] INFO component.servletlistener.CamelServletContextListener - CamelContextServletListener initializing ... 2019-04-12 15:49:20,3992019-04-12T15:49:20,399 [localhost-startStop-1] INFO component.servletlistener.CamelServletContextListener - There are 2 ServletContext init parameters, unknown to Camel. Maybe they are used by other frameworks? [{contextConfigLocation=com.opentext.otag.config.SpringConfig, contextClass=org.springframework.web.context.support.AnnotationConfigWebApplicationContext}] 2019-04-12 15:49:20,3992019-04-12T15:49:20,399 [localhost-startStop-1] INFO component.servletlistener.ServletCamelContext - Apache Camel 2.20.2 (CamelContext: camel-1) is starting 2019-04-12 15:49:20,3992019-04-12T15:49:20,399 [localhost-startStop-1] INFO camel.management.ManagedManagementStrategy - JMX is enabled 2019-04-12 15:49:20,8042019-04-12T15:49:20,804 [localhost-startStop-1] INFO impl.converter.DefaultTypeConverter - Type converters loaded (core: 192, classpath: 12) 2019-04-12 15:49:23,0682019-04-12T15:49:23,068 [localhost-startStop-1] INFO component.http4.HttpComponent - Created ClientConnectionManager org.apache.http.impl.conn.PoolingHttpClientConnectionManager@15f22e4 2019-04-12 15:49:23,1152019-04-12T15:49:23,115 [localhost-startStop-1] INFO component.servletlistener.ServletCamelContext - StreamCaching is not in use. If using streams then its recommended to enable stream caching. See more details at http://camel.apache.org/stream-caching.html 2019-04-12 15:49:23,1622019-04-12T15:49:23,162 [Thread-6] INFO service.impl.StatusBeanImpl - ==Attempting to jump start Gateway services, this node may already be configured 2019-04-12 15:49:23,3022019-04-12T15:49:23,302 [localhost-startStop-1] INFO component.servletlistener.ServletCamelContext - Route: route1 started and consuming from: servlet:/?httpBinding=awgCamelHttpBinding&matchOnUriPrefix=true 2019-04-12 15:49:23,3022019-04-12T15:49:23,302 [localhost-startStop-1] INFO component.servletlistener.ServletCamelContext - Total 1 routes, of which 1 are started 2019-04-12 15:49:23,3022019-04-12T15:49:23,302 [localhost-startStop-1] INFO component.servletlistener.ServletCamelContext - Apache Camel 2.20.2 (CamelContext: camel-1) started in 2.903 seconds 2019-04-12 15:49:23,3182019-04-12T15:49:23,318 [localhost-startStop-1] INFO component.servletlistener.CamelServletContextListener - CamelContextServletListener initialized 2019-04-12 15:49:23,3182019-04-12T15:49:23,318 [localhost-startStop-1] INFO component.servletlistener.CamelServletContextListener - CamelContextServletListenerdestroying ...
2019-04-12 15:49:23,3182019-04-12T15:49:23,318 [localhost-startStop-1] INFO component.servletlistener.ServletCamelContext - Apache Camel 2.20.2 (CamelContext: camel-1) is shutting down
2019-04-12 15:49:23,3182019-04-12T15:49:23,318 [localhost-startStop-1] INFO camel.impl.DefaultShutdownStrategy - Starting to graceful shutdown 1 routes (timeout 300 seconds)
2019-04-12 15:49:23,3652019-04-12T15:49:23,365 [Camel (camel-1) thread #1 - ShutdownTask] INFO camel.impl.DefaultShutdownStrategy - Route: route1 shutdown complete, was consuming from: servlet:/?httpBinding=awgCamelHttpBinding&matchOnUriPrefix=true
2019-04-12 15:49:23,3652019-04-12T15:49:23,365 [localhost-startStop-1] INFO camel.impl.DefaultShutdownStrategy - Graceful shutdown of 1 routes completed in 0 seconds
2019-04-12 15:49:23,5212019-04-12T15:49:23,521 [localhost-startStop-1] INFO component.servletlistener.ServletCamelContext - Apache Camel 2.20.2 (CamelContext: camel-1) uptime 3.122 seconds
2019-04-12 15:49:23,5212019-04-12T15:49:23,521 [localhost-startStop-1] INFO component.servletlistener.ServletCamelContext - Apache Camel 2.20.2 (CamelContext: camel-1) is shutdown in 0.203 seconds
2019-04-12 15:49:23,5212019-04-12T15:49:23,521 [localhost-startStop-1] INFO component.servletlistener.CamelServletContextListener - CamelContextServletListener destroyed
2019-04-12 15:49:23,5212019-04-12T15:49:23,521 [localhost-startStop-1] INFO context.support.AnnotationConfigWebApplicationContext - Closing Root WebApplicationContext: startup date [Fri Apr 12 15:48:47 CEST 2019]; root of context hierarchy
2019-04-12 15:49:23,5522019-04-12T15:49:23,552 [localhost-startStop-1] INFO notifications.fcm.FcmApplicationServerImpl - Shutting down HttpClient instance
2019-04-12 15:49:23,5522019-04-12T15:49:23,552 [localhost-startStop-1] INFO contract.notifications.NotificationsMonitorService - Shutting down notification purge threads
2019-04-12 15:49:23,5522019-04-12T15:49:23,552 [localhost-startStop-1] INFO api.tracker.WipeTimerManagerImpl - Destroying WipeTimerManager, stopping any running WipeTimerThreads
2019-04-12 15:49:23,5682019-04-12T15:49:23,568 [localhost-startStop-1] INFO services.impl.MailServiceImpl - Destroying MailService service
2019-04-12 15:49:23,6142019-04-12T15:49:23,614 [localhost-startStop-1] INFO otag.config.ExecutorWrapper - Destroying ExecutorWrapper service
2019-04-12 15:49:23,6462019-04-12T15:49:23,646 [SdkEventConsumer] ERROR deployments.events.DeploymentsApiEventSink - An unexpected exception was thrown while processing event - null
java.lang.InterruptedException: null
at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(Unknown Source) ~[?:1.8.0_161]
at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(Unknown Source) ~[?:1.8.0_161]
at java.util.concurrent.LinkedBlockingDeque.takeFirst(Unknown Source) ~[?:1.8.0_161]
at java.util.concurrent.LinkedBlockingDeque.take(Unknown Source) ~[?:1.8.0_161]
at com.opentext.otag.api.endpoints.deployments.events.DeploymentsApiEventSink.lambda$onConstruct$2(DeploymentsApiEventSink.java:115) ~[classes/:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_161]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_161]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_161]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_161]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_161]
2019-04-12 15:49:23,6462019-04-12T15:49:23,646 [SdkEventConsumer] INFO deployments.events.DeploymentsApiEventSink - Exiting the SDK event bus loop

It looks like it's excpecting an ID column on the EVENT table which doesn't exist.
Did anyone encounter the same problem or even better has a solution to fix this?

Peter

DThorn11

I see an error like this when the appworks database is not reachable. Check both Tomcat error logs.