'invalid column type' error in BPM product when oracle thin drivers are used (Doc ID 1271605.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Business Process Management Suite - Version 10.3 and later
Information in this document applies to any platform.
***Checked for relevance on 28-June-2013***

Symptoms

After following the steps in <Note 1251135.1> to change driver type from datadirect to oracle thin drivers, in the processadmin while saving the engine properties, you will see the following error in processadmin and webconsole.log


[ (cont) ] Main: Configuration 'engine_OneEngine1031_J2EE_FDI_FUEGOLABS_ARG' cannot be deleted since it is referenced by the following engines: [EngineThinDrivers].
[ (cont) ] Main: fuego.mami.exception.ConfigurationHasReferencesException: Configuration 'EngineThinDrivers_J2EE_FDI_FUEGOLABS_ARG' cannot be deleted since it is referenced by the following engines: [EngineThinDrivers].
[ (cont) ] Main: at fuego.mami.exception.ConfigurationHasReferencesException.create(ConfigurationHasReferencesException.java:65)
[ (cont) ] Main: at fuego.mami.ConfigurationManager.removeConfiguration(ConfigurationManager.java:420)
[ (cont) ] Main: at fuego.webconsole.model.J2EEJSFEngine.initConfs(J2EEJSFEngine.java:2265)
[ (cont) ] Main: at fuego.webconsole.model.J2EEJSFEngine.<init>(J2EEJSFEngine.java:105)
[ (cont) ] Main: at fuego.webconsole.model.EnginePaginateHandler.getJSFEngine(EnginePaginateHandler.java:368)
[ (cont) ] Main: at fuego.webconsole.model.EnginePaginateHandler.getPresentables(EnginePaginateHandler.java:81)
[ (cont) ] Main: at fuego.jsfcomponents.model.PaginateHandlerBase.filterAndAOrderPresentables(PaginateHandlerBase.java:89)
[ (cont) ] Main: at fuego.jsfcomponents.model.PaginateHandlerBase.totalItemsSize(PaginateHandlerBase.java:68)
[ (cont) ] Main: at fuego.jsfcomponents.ui.UIListComponent.getTotalPages(UIListComponent.java:186)
[ (cont) ] Main: at fuego.jsfcomponents.renderkit.ListRenderer.drawPaginateInfo(ListRenderer.java:863)
[ (cont) ] Main: at fuego.jsfcomponents.renderkit.ListRenderer.encodeBegin(ListRenderer.java:154)
[ (cont) ] Main: at javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:675)
[ (cont) ] Main: at javax.faces.webapp.UIComponentTag.encodeBegin(UIComponentTag.java:584)
[ (cont) ] Main: at javax.faces.webapp.UIComponentTag.doStartTag(UIComponentTag.java:471)
[ (cont) ] Main: at org.apache.jsp.jsf.engineList_jsp._jspService(org.apache.jsp.jsf.engineList_jsp:317)
[ (cont) ] Main: at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
[ (cont) ] Main: at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
[ (cont) ] Main: at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
[ (cont) ] Main: at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
[ (cont) ] Main: at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
[ (cont) ] Main: at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
[ (cont) ] Main: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
[ (cont) ] Main: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
[ (cont) ] Main: at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
[ (cont) ] Main: at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
[ (cont) ] Main: at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
[ (cont) ] Main: at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
[ (cont) ] Main: at com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322)
[ (cont) ] Main: at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:147)
[ (cont) ] Main: at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87)
[ (cont) ] Main: at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
[ (cont) ] Main: at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)
[ (cont) ] Main: at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)
[ (cont) ] Main: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
[ (cont) ] Main: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
[ (cont) ] Main: at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
[ (cont) ] Main: at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
[ (cont) ] Main: at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
[ (cont) ] Main: at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
[ (cont) ] Main: at com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322)
[ (cont) ] Main: at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:147)
[ (cont) ] Main: at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87)
[ (cont) ] Main: at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
[ (cont) ] Main: at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)
[ (cont) ] Main: at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)
[ (cont) ] Main: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
[ (cont) ] Main: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
[ (cont) ] Main: at fuego.web.filter.CharsetFilter.doFilter(CharsetFilter.java:48)
[ (cont) ] Main: at fuego.web.filter.BaseFilter.doFilter(BaseFilter.java:63)
[ (cont) ] Main: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
[ (cont) ] Main: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
[ (cont) ] Main: at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
[ (cont) ] Main: at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
[ (cont) ] Main: at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
[ (cont) ] Main: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
[ (cont) ] Main: at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
[ (cont) ] Main: at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
[ (cont) ] Main: at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
[ (cont) ] Main: at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
[ (cont) ] Main: at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
[ (cont) ] Main: at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
[ (cont) ] Main: at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
[ (cont) ] Main: at java.lang.Thread.run(Unknown Source)



Also, when trying to deploy the regenerated engine and workspace EAR, following error is seen in the webconsole.log:



 Main: Exception message in the remote host: class java.lang.RuntimeException: Error while deploying application [ear=Fuego-WebLogic-Deployer\01-eng-EngineThinDrivers.ear, name=01-eng-EngineThinDrivers].
[ (cont) ] Main: Exception detail in the remote host: java.lang.RuntimeException: Error while deploying application [ear=Fuego-WebLogic-Deployer\01-eng-EngineThinDrivers.ear, name=01-eng-EngineThinDrivers].
[ (cont) ] Main: at fuego.j2eedeployer.weblogic.WLDeployerExecutor.installApplication(WLDeployerExecutor.java:120)
[ (cont) ] Main: at fuego.j2eedeployer.weblogic.WLDeployer.installEar(WLDeployer.java:160)
[ (cont) ] Main: at fuego.j2eedeployer.weblogic.WLDeployer.installEngine(WLDeployer.java:97)
[ (cont) ] Main: at fuego.j2eedeployer.basedeployer.BaseDeployerServlet.doPost(BaseDeployerServlet.java:145)
[ (cont) ] Main: at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
[ (cont) ] Main: at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
[ (cont) ] Main: at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
[ (cont) ] Main: at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
[ (cont) ] Main: at weblogic.security.service.SecurityManager.runAs(Unknown Source)
[ (cont) ] Main: at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:122)
[ (cont) ] Main: at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
[ (cont) ] Main: at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
[ (cont) ] Main: at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3498)
[ (cont) ] Main: at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
[ (cont) ] Main: at weblogic.security.service.SecurityManager.runAs(Unknown Source)
[ (cont) ] Main: at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
[ (cont) ] Main: at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
[ (cont) ] Main: at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
[ (cont) ] Main: at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
[ (cont) ] Main: at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
[ (cont) ] Main: Caused by: weblogic.application.ModuleException: [HTTP:101216]Servlet: "engineStartup" failed to preload on startup in Web application: "/albpmServices/EngineThinDrivers".
[ (cont) ] Main: fuego.directory.DirectoryRuntimeException: Exception [java.sql.SQLException: Invalid column type].
[ (cont) ] Main: at fuego.directory.DirectoryRuntimeException.wrapException(DirectoryRuntimeException.java:85)
[ (cont) ] Main: at fuego.directory.provider.jdbc.oracle.OraclePersistenceManager.mapSQLException(OraclePersistenceManager.java:183)
[ (cont) ] Main: at fuego.directory.provider.jdbc.datadirect.oracle.DataDirectOraclePersistenceManager.mapSQLException(DataDirectOraclePersistenceManager.java:50)
[ (cont) ] Main: at fuego.directory.provider.jdbc.JDBCServiceAccessor.mapSQLException(JDBCServiceAccessor.java:78)
[ (cont) ] Main: at fuego.directory.provider.jdbc.JDBCParticipantsAccessor.fetchHumanParticipant(JDBCParticipantsAccessor.java:1428)
[ (cont) ] Main: at fuego.directory.provider.jdbc.JDBCParticipantsAccessor.authenticateHumanParticipant(JDBCParticipantsAccessor.java:369)
[ (cont) ] Main: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[ (cont) ] Main: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[ (cont) ] Main: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[ (cont) ] Main: at java.lang.reflect.Method.invoke(Method.java:597)
[ (cont) ] Main: at fuego.directory.provider.DirectorySessionImpl$AccessorProxy.invoke(DirectorySessionImpl.java:756)
[ (cont) ] Main: at $Proxy117.authenticateHumanParticipant(Unknown Source)
[ (cont) ] Main: at fuego.directory.provider.jdbc.JDBCAuthenticationAccessor.getSessionParticipant(JDBCAuthenticationAccessor.java:429)
[ (cont) ] Main: at fuego.directory.provider.jdbc.JDBCAuthenticationAccessor.authenticateInternal(JDBCAuthenticationAccessor.java:323)
[ (cont) ] Main: at fuego.directory.provider.jdbc.JDBCAuthenticationAccessor.authenticate(JDBCAuthenticationAccessor.java:73)
[ (cont) ] Main: at fuego.directory.provider.jdbc.JDBCAuthenticationAccessor.connect(JDBCAuthenticationAccessor.java:127)
[ (cont) ] Main: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[ (cont) ] Main: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[ (cont) ] Main: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[ (cont) ] Main: at java.lang.reflect.Method.invoke(Method.java:597)
[ (cont) ] Main: at fuego.directory.provider.DirectorySessionImpl$AccessorProxy.invoke(DirectorySessionImpl.java:756)
[ (cont) ] Main: at $Proxy114.connect(Unknown Source)
[ (cont) ] Main: at fuego.directory.provider.DirectorySessionImpl.connect(DirectorySessionImpl.java:250)
[ (cont) ] Main: at fuego.directory.provider.Factory.startSession(Factory.java:405)
[ (cont) ] Main: at fuego.directory.provider.jdbc.j2ee.RemoteJdbcDirectoryFactory.startSession(RemoteJdbcDirectoryFactory.java:122)
[ (cont) ] Main: at fuego.directory.Directory.startSession(Directory.java:268)
[ (cont) ] Main: at fuego.ejbengine.Engine.initDirectorySession(Engine.java:343)
[ (cont) ] Main: at fuego.ejbengine.Engine.start(Engine.java:129)
[ (cont) ] Main: at fuego.ejbengine.servlet.AbstractSchedulerServlet.init(AbstractSchedulerServlet.java:91)
[ (cont) ] Main: at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:283)
[ (cont) ] Main: at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
[ (cont) ] Main: at weblogic.security.service.SecurityManager.runAs(Unknown Source)
[ (cont) ] Main: at weblogic.servlet.internal.StubSecurityHelper.createServlet(StubSecurityHelper.java:64)
[ (cont) ] Main: at weblogic.servlet.internal.StubLifecycleHelper.createOneInstance(StubLifecycleHelper.java:58)
[ (cont) ] Main: at weblogic.servlet.internal.StubLifecycleHelper.<init>(StubLifecycleHelper.java:48)
[ (cont) ] Main: at weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.java:521)
[ (cont) ] Main: at weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppServletContext.java:1893)
[ (cont) ] Main: at weblogic.servlet.internal.WebAppServletContext.loadServletsOnStartup(WebAppServletContext.java:1870)
[ (cont) ] Main: at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1790)
[ (cont) ] Main: at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:2999)
[ (cont) ] Main: at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1371)
[ (cont) ] Main: at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:468)
[ (cont) ] Main: at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
[ (cont) ] Main: at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
[ (cont) ] Main: at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
[ (cont) ] Main: at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
[ (cont) ] Main: at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:117)
[ (cont) ] Main: at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
[ (cont) ] Main: at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
[ (cont) ] Main: at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
[ (cont) ] Main: at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
[ (cont) ] Main: at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:635)
[ (cont) ] Main: at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
[ (cont) ] Main: at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212)
[ (cont) ] Main: at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:16)
[ (cont) ] Main: at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:162)
[ (cont) ] Main: at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
[ (cont) ] Main: at weblogic.deploy.internal.targetserver.operations.AbstractOperation.activate(AbstractOperation.java:569)
[ (cont) ] Main: at weblogic.deploy.internal.targetserver.operations.ActivateOperation.activateDeployment(ActivateOperation.java:140)
[ (cont) ] Main: at weblogic.deploy.internal.targetserver.operations.ActivateOperation.doCommit(ActivateOperation.java:106)
[ (cont) ] Main: at weblogic.deploy.internal.targetserver.operations.AbstractOperation.commit(AbstractOperation.java:323)
[ (cont) ] Main: at weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploymentCommit(DeploymentManager.java:820)
[ (cont) ] Main: at weblogic.deploy.internal.targetserver.DeploymentManager.activateDeploymentList(DeploymentManager.java:1227)
[ (cont) ] Main: at weblogic.deploy.internal.targetserver.DeploymentManager.handleCommit(DeploymentManager.java:436)
[ (cont) ] Main: at weblogic.deploy.internal.targetserver.DeploymentServiceDispatcher.commit(DeploymentServiceDispatcher.java:163)
[ (cont) ] Main: at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doCommitCallback(DeploymentReceiverCallbackDeliverer.java:181)
[ (cont) ] Main: at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.access$100(DeploymentReceiverCallbackDeliverer.java:12)
[ (cont) ] Main: at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer$2.run(DeploymentReceiverCallbackDeliverer.java:67)
[ (cont) ] Main: at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
[ (cont) ] Main: at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
[ (cont) ] Main: at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

[ (cont) ] Main: Caused by: java.sql.SQLException: Invalid column type
[ (cont) ] Main: at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
[ (cont) ] Main: at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
[ (cont) ] Main: at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
[ (cont) ] Main: at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
[ (cont) ] Main: at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)
[ (cont) ] Main: at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:7931)
[ (cont) ] Main: at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:7511)
[ (cont) ] Main: at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:7984)
[ (cont) ] Main: at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:237)
[ (cont) ] Main: at weblogic.jdbc.wrapper.PreparedStatement.setObject(PreparedStatement.java:287)
[ (cont) ] Main: at fuego.jdbc.FaultTolerantPreparedStatement.setString(FaultTolerantPreparedStatement.java:436)
[ (cont) ] Main: at fuego.directory.provider.jdbc.JDBCPersistenceManager.setStringAttribute(JDBCPersistenceManager.java:896)
[ (cont) ] Main: at fuego.directory.provider.jdbc.JDBCParticipantsAccessor.fetchHumanParticipant(JDBCParticipantsAccessor.java:1422)
[ (cont) ] Main: ... 66 more


If the Engine was already deployed and the driver is changed, you might see the following error:

Caused by: Invalid column type
fuego.transaction.DatabaseException: An error occurred while accesing the database.
Detail:SQL statement: 'INSERT INTO PPROCINSTEVENT (PROCESSID,INSTID,THREADID,EVENTID,ACTIVITYNAME,EVENTTIME,PARTICIPANT,TYPE, EVENTDATA, CATEGORY, RECEIVETIME, ACTIVATETIME) VALUES (66, 200601, 0, 558, ?, ?, ?, ?, ?, ?, ?, ?)'

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms