I’m trying to configure the engine with Tomcat 8 and Oracle database. I’m using Camunda 7.7
bpm-platform.xml (3.5 KB)
server.xml (7.8 KB)
On the start up:
C:\Users\me\Desktop\camunda-77-tomcat\server\apache-tomcat-8.0.24\bin\catalina.bat run
[2017-06-06 03:36:05,780] Artifact loanapproval-spring:war: Server is not connected. Deploy is not available.
Using CATALINA_BASE: “C:\Users\me.IntelliJIdea2017.1\system\tomcat\Unnamed_loanapproval-spring”
Using CATALINA_HOME: “C:\Users\me\Desktop\camunda-77-tomcat\server\apache-tomcat-8.0.24”
Using CATALINA_TMPDIR: “C:\Users\me\Desktop\camunda-77-tomcat\server\apache-tomcat-8.0.24\temp”
Using JRE_HOME: “C:\Program Files\Java\jdk1.8.0_121”
Using CLASSPATH: “C:\Users\me\Desktop\camunda-77-tomcat\server\apache-tomcat-8.0.24\bin\bootstrap.jar;C:\Users\me\Desktop\camunda-77-tomcat\server\apache-tomcat-8.0.24\bin\tomcat-juli.jar”
06-Jun-2017 15:36:06.885 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.0.24
06-Jun-2017 15:36:06.886 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Jul 1 2015 20:19:55 UTC
06-Jun-2017 15:36:06.886 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.0.24.0
06-Jun-2017 15:36:06.886 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows 10
06-Jun-2017 15:36:06.886 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 10.0
06-Jun-2017 15:36:06.886 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
06-Jun-2017 15:36:06.886 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: C:\Program Files\Java\jdk1.8.0_121\jre
06-Jun-2017 15:36:06.888 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_121-b13
06-Jun-2017 15:36:06.888 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
06-Jun-2017 15:36:06.888 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: C:\Users\me.IntelliJIdea2017.1\system\tomcat\Unnamed_loanapproval-spring
06-Jun-2017 15:36:06.888 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: C:\Users\me\Desktop\camunda-77-tomcat\server\apache-tomcat-8.0.24
06-Jun-2017 15:36:06.889 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote=
06-Jun-2017 15:36:06.889 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.port=1099
06-Jun-2017 15:36:06.889 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.ssl=false
06-Jun-2017 15:36:06.889 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.authenticate=false
06-Jun-2017 15:36:06.889 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.rmi.server.hostname=127.0.0.1
06-Jun-2017 15:36:06.889 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Users\me.IntelliJIdea2017.1\system\tomcat\Unnamed_loanapproval-spring\conf\logging.properties
06-Jun-2017 15:36:06.889 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
06-Jun-2017 15:36:06.889 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx512m
06-Jun-2017 15:36:06.890 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:MaxPermSize=256m
06-Jun-2017 15:36:06.890 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:PermSize=256m
06-Jun-2017 15:36:06.890 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.endorsed.dirs=C:\Users\me\Desktop\camunda-77-tomcat\server\apache-tomcat-8.0.24\endorsed
06-Jun-2017 15:36:06.890 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Users\me.IntelliJIdea2017.1\system\tomcat\Unnamed_loanapproval-spring
06-Jun-2017 15:36:06.890 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\Users\me\Desktop\camunda-77-tomcat\server\apache-tomcat-8.0.24
06-Jun-2017 15:36:06.890 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\Users\me\Desktop\camunda-77-tomcat\server\apache-tomcat-8.0.24\temp
06-Jun-2017 15:36:06.890 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk1.8.0_121\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client;C:\Program Files\Intel\iCLS Client;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Program Files\Git\cmd;C:\apache-ant-1.10.1\bin;C:\Program Files\Java\jdk1.8.0_121\bin;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\WiFi\bin;C:\Program Files\Common Files\Intel\WirelessCommon;C:\Program Files\PuTTY;C:\Program Files\OpenVPN\bin;C:\apache-maven-3.5.0\bin;C:\Users\me\AppData\Local\Microsoft\WindowsApps;;.
06-Jun-2017 15:36:07.039 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler [“http-nio-8080”]
06-Jun-2017 15:36:07.060 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
06-Jun-2017 15:36:07.063 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler [“ajp-nio-8009”]
06-Jun-2017 15:36:07.067 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
06-Jun-2017 15:36:07.067 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 628 ms
06-Jun-2017 15:36:07.107 WARNING [main] org.apache.tomcat.jdbc.pool.ConnectionPool.init maxIdle is larger than maxActive, setting maxIdle to: 20
06-Jun-2017 15:36:12.231 INFO [main] org.camunda.commons.logging.BaseLogger.logInfo ENGINE-08046 Found camunda bpm platform configuration in CATALINA_BASE/CATALINA_HOME conf directory [C:\Users\me.IntelliJIdea2017.1\system\tomcat\Unnamed_loanapproval-spring\conf\bpm-platform.xml] at ‘file:/C:/Users/me/.IntelliJIdea2017.1/system/tomcat/Unnamed_loanapproval-spring/conf/bpm-platform.xml’
06-Jun-2017 15:36:12.613 INFO [main] org.camunda.commons.logging.BaseLogger.logInfo ENGINE-12003 Plugin ‘ProcessApplicationEventListenerPlugin’ activated on process engine ‘default’
06-Jun-2017 15:36:12.619 INFO [main] org.camunda.commons.logging.BaseLogger.logInfo ENGINE-12003 Plugin ‘SpinProcessEnginePlugin’ activated on process engine ‘default’
06-Jun-2017 15:36:12.623 INFO [main] org.camunda.commons.logging.BaseLogger.logInfo SPIN-01010 Discovered Spin data format provider: org.camunda.spin.impl.json.jackson.format.JacksonJsonDataFormatProvider[name = application/json]
06-Jun-2017 15:36:12.766 INFO [main] org.camunda.commons.logging.BaseLogger.logInfo SPIN-01010 Discovered Spin data format provider: org.camunda.spin.impl.xml.dom.format.DomXmlDataFormatProvider[name = application/xml]
06-Jun-2017 15:36:12.778 INFO [main] org.camunda.commons.logging.BaseLogger.logInfo SPIN-01009 Discovered Spin data format: org.camunda.spin.impl.xml.dom.format.DomXmlDataFormat[name = application/xml]
06-Jun-2017 15:36:12.779 INFO [main] org.camunda.commons.logging.BaseLogger.logInfo SPIN-01009 Discovered Spin data format: org.camunda.spin.impl.json.jackson.format.JacksonJsonDataFormat[name = application/json]
06-Jun-2017 15:36:12.779 INFO [main] org.camunda.commons.logging.BaseLogger.logInfo ENGINE-12003 Plugin ‘ConnectProcessEnginePlugin’ activated on process engine ‘default’
06-Jun-2017 15:36:12.948 INFO [main] org.camunda.commons.logging.BaseLogger.logInfo CNCT-01004 Discovered provider for connector id ‘http-connector’ and class ‘org.camunda.connect.httpclient.impl.HttpConnectorImpl’: ‘org.camunda.connect.httpclient.impl.HttpConnectorProviderImpl’
06-Jun-2017 15:36:12.952 INFO [main] org.camunda.commons.logging.BaseLogger.logInfo CNCT-01004 Discovered provider for connector id ‘soap-http-connector’ and class ‘org.camunda.connect.httpclient.soap.impl.SoapHttpConnectorImpl’: ‘org.camunda.connect.httpclient.soap.impl.SoapHttpConnectorProviderImpl’
06-Jun-2017 15:36:15.901 SEVERE [main] org.camunda.commons.logging.BaseLogger.logError ENGINE-03078 No history cleanup lock property found in databse
06-Jun-2017 15:36:17.677 INFO [main] org.camunda.commons.logging.BaseLogger.logInfo ENGINE-00001 Process Engine default created.
06-Jun-2017 15:36:17.678 INFO [main] org.camunda.commons.logging.BaseLogger.logInfo ENGINE-14014 Starting up the JobExecutor[org.camunda.bpm.engine.impl.jobexecutor.RuntimeContainerJobExecutor].
06-Jun-2017 15:36:17.680 INFO [Thread-30] org.camunda.commons.logging.BaseLogger.logInfo ENGINE-14018 JobExecutor[org.camunda.bpm.engine.impl.jobexecutor.RuntimeContainerJobExecutor] starting to acquire jobs
06-Jun-2017 15:36:19.411 INFO [main] org.camunda.commons.logging.BaseLogger.logInfo ENGINE-08048 Camunda BPM platform sucessfully started at ‘Apache Tomcat/8.0.24’.
06-Jun-2017 15:36:19.429 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service Catalina
06-Jun-2017 15:36:19.429 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.0.24
06-Jun-2017 15:36:19.437 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler [“http-nio-8080”]
06-Jun-2017 15:36:19.444 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler [“ajp-nio-8009”]
06-Jun-2017 15:36:19.446 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 12378 ms
Connected to server
[2017-06-06 03:36:19,659] Artifact loanapproval-spring:war: Artifact is being deployed, please wait…
06-Jun-2017 15:36:24.637 INFO [RMI TCP Connection(3)-127.0.0.1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
06-Jun-2017 15:36:24.751 INFO [RMI TCP Connection(3)-127.0.0.1] org.springframework.web.context.ContextLoader.initWebApplicationContext Root WebApplicationContext: initialization started
06-Jun-2017 15:36:24.771 INFO [RMI TCP Connection(3)-127.0.0.1] org.springframework.web.context.support.AnnotationConfigWebApplicationContext.prepareRefresh Refreshing Root WebApplicationContext: startup date [Tue Jun 06 15:36:24 CEST 2017]; root of context hierarchy
06-Jun-2017 15:36:24.842 INFO [RMI TCP Connection(3)-127.0.0.1] org.springframework.web.context.support.AnnotationConfigWebApplicationContext.loadBeanDefinitions Registering annotated classes: [class com.onwelo.raptor.camunda.config.ApplicationConfig]
06-Jun-2017 15:36:25.759 INFO [RMI TCP Connection(3)-127.0.0.1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped “{[/]}” onto public java.lang.String com.onwelo.raptor.camunda.StartProcessController.welcome()
06-Jun-2017 15:36:25.761 INFO [RMI TCP Connection(3)-127.0.0.1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped “{[/connectDeploymentWithThisApp/{deploymentId}]}” onto public java.lang.String com.onwelo.raptor.camunda.StartProcessController.registerThisProcessApplication(java.lang.String)
06-Jun-2017 15:36:25.761 INFO [RMI TCP Connection(3)-127.0.0.1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped “{[/sendContinueSignal/{processInstanceId}]}” onto public boolean com.onwelo.raptor.camunda.StartProcessController.sendMessageToTheProcessInstance(java.lang.String)
06-Jun-2017 15:36:26.161 INFO [RMI TCP Connection(3)-127.0.0.1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.initControllerAdviceCache Looking for @ControllerAdvice: Root WebApplicationContext: startup date [Tue Jun 06 15:36:24 CEST 2017]; root of context hierarchy
06-Jun-2017 15:36:26.381 INFO [RMI TCP Connection(3)-127.0.0.1] org.camunda.commons.logging.BaseLogger.logInfo ENGINE-08024 Found processes.xml file at file:/C:/Users/me/Desktop/camunda-77-tomcat/server/apache-tomcat-8.0.24/webapps/ROOT/WEB-INF/classes/META-INF/processes.xml
06-Jun-2017 15:36:26.397 INFO [RMI TCP Connection(3)-127.0.0.1] org.camunda.commons.logging.BaseLogger.logInfo ENGINE-08023 Deployment summary for process archive ‘loan-approval’:
loanApproval.bpmn
06-Jun-2017 15:36:26.808 INFO [RMI TCP Connection(3)-127.0.0.1] org.camunda.commons.logging.BaseLogger.logInfo ENGINE-07021 ProcessApplication ‘processApplication’ registered for DB deployments [23a687e8-4abd-11e7-a199-34f39ad831c7]. Will execute process definitions
loanApproval[version: 1, id: loanApproval:1:23c162ea-4abd-11e7-a199-34f39ad831c7]Deployment does not provide any case definitions.
06-Jun-2017 15:36:26.979 SEVERE [RMI TCP Connection(3)-127.0.0.1] org.camunda.commons.logging.BaseLogger.logError ENGINE-16004 Exception while closing command context: ENGINE-03004 Exception while executing Database Operation ‘INSERT ProcessDefinitionEntity[loanApproval:1:23c162ea-4abd-11e7-a199-34f39ad831c7]’ with message ’Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-00904: “HISTORY_TTL_”: niepoprawny identyfikator
The error may involve org.camunda.bpm.engine.impl.persistence.entity.ProcessDefinitionEntity.insertProcessDefinition-Inline
The error occurred while setting parameters
SQL: insert into ACT_RE_PROCDEF(ID_, CATEGORY_, NAME_, KEY_, VERSION_, DEPLOYMENT_ID_, RESOURCE_NAME_, DGRM_RESOURCE_NAME_, HAS_START_FORM_KEY_, SUSPENSION_STATE_, TENANT_ID_, VERSION_TAG_, HISTORY_TTL_, REV_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 1 )
Cause: java.sql.SQLSyntaxErrorException: ORA-00904: “HISTORY_TTL_”: niepoprawny identyfikator
'. Flush summary:
[
INSERT DeploymentEntity[23a687e8-4abd-11e7-a199-34f39ad831c7]
INSERT ResourceEntity[23a687e9-4abd-11e7-a199-34f39ad831c7]
INSERT ProcessDefinitionEntity[loanApproval:1:23c162ea-4abd-11e7-a199-34f39ad831c7]
]
org.camunda.bpm.engine.ProcessEngineException: ENGINE-03004 Exception while executing Database Operation ‘INSERT ProcessDefinitionEntity[loanApproval:1:23c162ea-4abd-11e7-a199-34f39ad831c7]’ with message ’Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-00904: “HISTORY_TTL_”: niepoprawny identyfikator
The error may involve org.camunda.bpm.engine.impl.persistence.entity.ProcessDefinitionEntity.insertProcessDefinition-Inline
The error occurred while setting parameters
SQL: insert into ACT_RE_PROCDEF(ID_, CATEGORY_, NAME_, KEY_, VERSION_, DEPLOYMENT_ID_, RESOURCE_NAME_, DGRM_RESOURCE_NAME_, HAS_START_FORM_KEY_, SUSPENSION_STATE_, TENANT_ID_, VERSION_TAG_, HISTORY_TTL_, REV_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 1 )
Cause: java.sql.SQLSyntaxErrorException: ORA-00904: “HISTORY_TTL_”: niepoprawny identyfikator
'. Flush summary:
[
INSERT DeploymentEntity[23a687e8-4abd-11e7-a199-34f39ad831c7]
INSERT ResourceEntity[23a687e9-4abd-11e7-a199-34f39ad831c7]
INSERT ProcessDefinitionEntity[loanApproval:1:23c162ea-4abd-11e7-a199-34f39ad831c7]
]
at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationException(EnginePersistenceLogger.java:115)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperationManager(DbEntityManager.java:305)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flush(DbEntityManager.java:281)
at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:203)
at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:132)
at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:113)
at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:66)
at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30)
at org.camunda.bpm.engine.impl.RepositoryServiceImpl.deployWithResult(RepositoryServiceImpl.java:99)
at org.camunda.bpm.engine.impl.repository.DeploymentBuilderImpl.deployWithResult(DeploymentBuilderImpl.java:266)
at org.camunda.bpm.engine.impl.repository.DeploymentBuilderImpl.deploy(DeploymentBuilderImpl.java:262)
at org.camunda.bpm.engine.impl.repository.ProcessApplicationDeploymentBuilderImpl.deploy(ProcessApplicationDeploymentBuilderImpl.java:59)
at org.camunda.bpm.container.impl.deployment.DeployProcessArchiveStep.performOperationStep(DeployProcessArchiveStep.java:141)
at org.camunda.bpm.container.impl.spi.DeploymentOperation.execute(DeploymentOperation.java:116)
at org.camunda.bpm.container.impl.jmx.MBeanServiceContainer.executeDeploymentOperation(MBeanServiceContainer.java:156)
at org.camunda.bpm.container.impl.spi.DeploymentOperation$DeploymentOperationBuilder.execute(DeploymentOperation.java:212)
at org.camunda.bpm.container.impl.RuntimeContainerDelegateImpl.deployProcessApplication(RuntimeContainerDelegateImpl.java:95)
at org.camunda.bpm.application.AbstractProcessApplication.deploy(AbstractProcessApplication.java:59)
at org.camunda.bpm.engine.spring.application.SpringProcessApplication.start(SpringProcessApplication.java:104)
at org.camunda.bpm.engine.spring.application.SpringServletProcessApplication.start(SpringServletProcessApplication.java:46)
at org.camunda.bpm.engine.spring.application.SpringServletProcessApplication.afterPropertiesSet(SpringServletProcessApplication.java:52)
at org.camunda.bpm.engine.spring.application.SpringProcessApplication.onApplicationEvent(SpringProcessApplication.java:90)
at org.camunda.bpm.engine.spring.application.SpringProcessApplication.onApplicationEvent(SpringProcessApplication.java:48)
at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:167)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:139)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:383)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:337)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:882)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:545)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4727)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
at org.apache.catalina.startup.HostConfig.manageApp(HostConfig.java:1648)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:300)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)
at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:463)
at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:413)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:300)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)
at javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1468)
at javax.management.remote.rmi.RMIConnectionImpl.access$300(RMIConnectionImpl.java:76)
at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1309)
at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1401)
at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:829)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:346)
at sun.rmi.transport.Transport$1.run(Transport.java:200)
at sun.rmi.transport.Transport$1.run(Transport.java:197)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:196)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:568)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:826)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:683)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:682)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.ibatis.exceptions.PersistenceException:Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-00904: “HISTORY_TTL_”: niepoprawny identyfikator
The error may involve org.camunda.bpm.engine.impl.persistence.entity.ProcessDefinitionEntity.insertProcessDefinition-Inline
The error occurred while setting parameters
SQL: insert into ACT_RE_PROCDEF(ID_, CATEGORY_, NAME_, KEY_, VERSION_, DEPLOYMENT_ID_, RESOURCE_NAME_, DGRM_RESOURCE_NAME_, HAS_START_FORM_KEY_, SUSPENSION_STATE_, TENANT_ID_, VERSION_TAG_, HISTORY_TTL_, REV_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 1 )
Cause: java.sql.SQLSyntaxErrorException: ORA-00904: “HISTORY_TTL_”: niepoprawny identyfikator
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:154)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:141)
at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.executeInsertEntity(DbSqlSession.java:146)
at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.insertEntity(DbSqlSession.java:138)
at org.camunda.bpm.engine.impl.db.AbstractPersistenceSession.executeDbOperation(AbstractPersistenceSession.java:41)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperationManager(DbEntityManager.java:303)
… 75 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: “HISTORY_TTL_”: niepoprawny identyfikator
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:910)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:44)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:69)
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:105)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:71)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152)
… 80 more
Caused by: Error : 904, Position : 185, Sql = insert into ACT_RE_PROCDEF(ID_, CATEGORY_, NAME_, KEY_, VERSION_, DEPLOYMENT_ID_, RESOURCE_NAME_, DGRM_RESOURCE_NAME_, HAS_START_FORM_KEY_, SUSPENSION_STATE_, TENANT_ID_, VERSION_TAG_, HISTORY_TTL_, REV_)
values (:1 ,
:2 ,
:3 ,
:4 ,
:5 ,
:6 ,
:7 ,
:8 ,
:9 ,
:10 ,
:11 ,
:12 ,
:13 ,
1
), OriginalSql = insert into ACT_RE_PROCDEF(ID_, CATEGORY_, NAME_, KEY_, VERSION_, DEPLOYMENT_ID_, RESOURCE_NAME_, DGRM_RESOURCE_NAME_, HAS_START_FORM_KEY_, SUSPENSION_STATE_, TENANT_ID_, VERSION_TAG_, HISTORY_TTL_, REV_)
values (?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
1
), Error Msg = ORA-00904: “HISTORY_TTL_”: niepoprawny identyfikator
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
… 99 more
06-Jun-2017 15:36:27.046 SEVERE [RMI TCP Connection(3)-127.0.0.1] org.springframework.web.context.ContextLoader.initWebApplicationContext Context initialization failed
java.lang.RuntimeException: org.camunda.bpm.engine.ProcessEngineException: ENGINE-08043 Exception while performing ‘Deployment of Process Application processApplication’ => 'Deployment of process archive ‘loan-approval’: ENGINE-03004 Exception while executing Database Operation ‘INSERT ProcessDefinitionEntity[loanApproval:1:23c162ea-4abd-11e7-a199-34f39ad831c7]’ with message ’Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-00904: “HISTORY_TTL_”: niepoprawny identyfikator
The error may involve org.camunda.bpm.engine.impl.persistence.entity.ProcessDefinitionEntity.insertProcessDefinition-Inline
The error occurred while setting parameters
SQL: insert into ACT_RE_PROCDEF(ID_, CATEGORY_, NAME_, KEY_, VERSION_, DEPLOYMENT_ID_, RESOURCE_NAME_, DGRM_RESOURCE_NAME_, HAS_START_FORM_KEY_, SUSPENSION_STATE_, TENANT_ID_, VERSION_TAG_, HISTORY_TTL_, REV_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 1 )
Cause: java.sql.SQLSyntaxErrorException: ORA-00904: “HISTORY_TTL_”: niepoprawny identyfikator
'. Flush summary:
[
INSERT DeploymentEntity[23a687e8-4abd-11e7-a199-34f39ad831c7]
INSERT ResourceEntity[23a687e9-4abd-11e7-a199-34f39ad831c7]
INSERT ProcessDefinitionEntity[loanApproval:1:23c162ea-4abd-11e7-a199-34f39ad831c7]
]
at org.camunda.bpm.engine.spring.application.SpringProcessApplication.onApplicationEvent(SpringProcessApplication.java:99)
at org.camunda.bpm.engine.spring.application.SpringProcessApplication.onApplicationEvent(SpringProcessApplication.java:48)
at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:167)
…
Thanks for any help.