5 Replies Latest reply on Feb 25, 2014 12:18 PM by davidredhat

    Unable to start Dashboard in jBPM6

    thiagz
    thiagz Feb 16, 2014 12:18 AM

      Hi Guys,

       

      I integrated my jBPM together with Oracle 11g DB and JBoss application server, but while I was starting up my jBPM console and tried to access the dashboard I was getting 404 error. In the server logs I can see the following exceptions. Does anyone have any idea about this?

       

      06:48:34,538 ERROR [org.jboss.dashboard.error.ErrorManager] (MSC service thread 1-4) UNEXPECTED ERROR.

      Thread id=MSC service thread 1-4

      Thread begin date=Thu Feb 13 06:48:23 GMT 2014

      Thread group=main

      Tx id=1368071436

      Tx Isolation=2

      Tx Auto commit=false

      Error id=1392274114536

      Error date=Thu Feb 13 06:48:34 GMT 2014

      Error stack trace=org.hibernate.HibernateException: JDBC connection object must be a oracle.jdbc.OracleConnection a org.jboss.jca.adapters.jdbc.WrappedConnectiona org.apache.commons.dbcp.PoolableConnectionor a com.mchange.v2.c3p0.impl.NewProxyConnection. Connection class is $Proxy45

      at org.jboss.dashboard.database.hibernate.LOBHelper.oracleNullSafeSet(LOBHelper.java:129)

      at org.jboss.dashboard.database.hibernate.LOBHelper.nullSafeSet(LOBHelper.java:170)

      at org.jboss.dashboard.database.hibernate.LOBHelper$Proxy$_$$_WeldClientProxy.nullSafeSet(LOBHelper$Proxy$_$$_WeldClientProxy.java)

      at org.jboss.dashboard.database.hibernate.BinaryBlobType.nullSafeSet(BinaryBlobType.java:55)

      at org.hibernate.type.CustomType.nullSafeSet(CustomType.java:155)

      at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2593)

      at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2846)

      at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3290)

      at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:80)

      at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:272)

      at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:264)

      at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:186)

      at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326)

      at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)

      at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1081)

      at org.jboss.dashboard.database.hibernate.HibernateTransaction.flush(HibernateTransaction.java:184)

      at org.jboss.dashboard.database.hibernate.HibernateTransaction.complete(HibernateTransaction.java:155)

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeInitiator(HibernateTxFragment.java:182)

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:167)

      at org.jboss.dashboard.workspace.GraphicElementManagerImpl.deployBaseElements(GraphicElementManagerImpl.java:146)

      at org.jboss.dashboard.workspace.GraphicElementManagerImpl.start(GraphicElementManagerImpl.java:86)

      at org.jboss.dashboard.workspace.LayoutsManagerImpl.start(LayoutsManagerImpl.java:34)

      at org.jboss.dashboard.workspace.LayoutsManagerImpl$Proxy$_$$_WeldClientProxy.start(LayoutsManagerImpl$Proxy$_$$_WeldClientProxy.java)

      at org.jboss.dashboard.annotation.StartableProcessor.wakeUpStartableBeans(StartableProcessor.java:48)

      at org.jboss.dashboard.Application.start(Application.java:107)

      at org.jboss.dashboard.Application$Proxy$_$$_WeldClientProxy.start(Application$Proxy$_$$_WeldClientProxy.java)

      at org.jboss.dashboard.ui.controller.ControllerServlet$1.doWork(ControllerServlet.java:73)

      at org.jboss.dashboard.factory.Factory.runWork(Factory.java:295)

      at org.jboss.dashboard.factory.Factory.doWork(Factory.java:321)

      at org.jboss.dashboard.ui.controller.ControllerServlet.init(ControllerServlet.java:70)

      at javax.servlet.GenericServlet.init(GenericServlet.java:242)

      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202)

      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1102)

      at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3655)

      at org.apache.catalina.core.StandardContext.start(StandardContext.java:3873)

      at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:90)

      at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811)

      at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)

      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

      at java.lang.Thread.run(Thread.java:662)

       

      ERROR [org.jboss.dashboard.kpi.KPIInitialModule] (MSC service thread 1-4) Error importing KPIs file (WEB-INF/etc/appdata/initialData/jbpmKPIs.xml) from initial module.: org.hibernate.HibernateException: Error in oracleNullSafeSet

      at org.jboss.dashboard.database.hibernate.LOBHelper.oracleNullSafeSet(LOBHelper.java:161) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.LOBHelper.nullSafeSet(LOBHelper.java:170) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.LOBHelper$Proxy$_$$_WeldClientProxy.nullSafeSet(LOBHelper$Proxy$_$$_WeldClientProxy.java) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.StringBlobType.nullSafeSet(StringBlobType.java:59) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.hibernate.type.CustomType.nullSafeSet(CustomType.java:155) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2593) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2846) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3290) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:80) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:272) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:264) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:186) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1081) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.jboss.dashboard.provider.DataProviderImpl$2.txFragment(DataProviderImpl.java:214) [dashboard-provider-core-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTransaction.executeFragment(HibernateTransaction.java:254) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeChild(HibernateTxFragment.java:194) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:168) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.provider.DataProviderImpl.persist(DataProviderImpl.java:205) [dashboard-provider-core-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.provider.DataProviderImpl$1.txFragment(DataProviderImpl.java:192) [dashboard-provider-core-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTransaction.executeFragment(HibernateTransaction.java:254) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeChild(HibernateTxFragment.java:194) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:168) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.provider.DataProviderImpl.save(DataProviderImpl.java:189) [dashboard-provider-core-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.export.ImportManagerImpl.saveOrUpdate(ImportManagerImpl.java:109) [dashboard-displayer-core-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.export.ImportManagerImpl.save(ImportManagerImpl.java:65) [dashboard-displayer-core-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.export.ImportManagerImpl$Proxy$_$$_WeldClientProxy.save(ImportManagerImpl$Proxy$_$$_WeldClientProxy.java) [dashboard-displayer-core-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.kpi.KPIInitialModule.installOrUpgrade(KPIInitialModule.java:84) [dashboard-displayer-core-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.kpi.KPIInitialModule.install(KPIInitialModule.java:55) [dashboard-displayer-core-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.factory.InitialModule$1.txFragment(InitialModule.java:61) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTransaction.executeFragment(HibernateTransaction.java:254) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeChild(HibernateTxFragment.java:194) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:168) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.factory.InitialModule.doTheInstall(InitialModule.java:59) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.factory.InitialModulesManager$1.txFragment(InitialModulesManager.java:73) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTransaction.executeFragment(HibernateTransaction.java:254) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeInitiator(HibernateTxFragment.java:179) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:167) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.factory.InitialModulesManager.start(InitialModulesManager.java:67) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.factory.InitialModulesManager$Proxy$_$$_WeldClientProxy.start(InitialModulesManager$Proxy$_$$_WeldClientProxy.java) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.annotation.StartableProcessor.wakeUpStartableBeans(StartableProcessor.java:48) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.Application.start(Application.java:107) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.Application$Proxy$_$$_WeldClientProxy.start(Application$Proxy$_$$_WeldClientProxy.java) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.ui.controller.ControllerServlet$1.doWork(ControllerServlet.java:73) [dashboard-ui-core-6.0.1.Final.jar:]

      at org.jboss.dashboard.factory.Factory.runWork(Factory.java:295) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.factory.Factory.doWork(Factory.java:321) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.ui.controller.ControllerServlet.init(ControllerServlet.java:70) [dashboard-ui-core-6.0.1.Final.jar:]

      at javax.servlet.GenericServlet.init(GenericServlet.java:242) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202) [jbossweb-7.0.13.Final.jar:]

      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1102) [jbossweb-7.0.13.Final.jar:]

      at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3655) [jbossweb-7.0.13.Final.jar:]

      at org.apache.catalina.core.StandardContext.start(StandardContext.java:3873) [jbossweb-7.0.13.Final.jar:]

      at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:90) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

      at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811)

      at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)

      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [rt.jar:1.6.0_31]

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [rt.jar:1.6.0_31]

      at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_31]

      Caused by: org.hibernate.HibernateException: JDBC connection object must be a oracle.jdbc.OracleConnection a org.jboss.jca.adapters.jdbc.WrappedConnectiona org.apache.commons.dbcp.PoolableConnectionor a com.mchange.v2.c3p0.impl.NewProxyConnection. Connection class is $Proxy45

      at org.jboss.dashboard.database.hibernate.LOBHelper.oracleNullSafeSet(LOBHelper.java:129) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      ... 58 more

       

      06:48:38,449 WARN [org.jboss.dashboard.factory.InitialModulesManager] (MSC service thread 1-4) Error installing module org.jboss.dashboard.jbpm.jbpmKPIs version 1

      06:48:38,453 INFO [org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl] (MSC service thread 1-4) HHH000010: On release of batch it still contained JDBC statements

      06:48:40,248 ERROR [org.jboss.dashboard.workspace.export.WorkspaceBuilder] (MSC service thread 1-4) Error:: org.hibernate.HibernateException: Error in oracleNullSafeSet

      at org.jboss.dashboard.database.hibernate.LOBHelper.oracleNullSafeSet(LOBHelper.java:161) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.LOBHelper.nullSafeSet(LOBHelper.java:170) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.LOBHelper$Proxy$_$$_WeldClientProxy.nullSafeSet(LOBHelper$Proxy$_$$_WeldClientProxy.java) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.StringBlobType.nullSafeSet(StringBlobType.java:59) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.hibernate.type.CustomType.nullSafeSet(CustomType.java:155) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2593) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2846) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3290) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:80) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:272) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:264) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:186) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1081) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

      at org.jboss.dashboard.workspace.WorkspacesManager$5.txFragment(WorkspacesManager.java:255) [dashboard-ui-core-6.0.1.Final.jar:]

      at org.jboss.dashboard.database.hibernate.HibernateTransaction.executeFragment(HibernateTransaction.java:254) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeChild(HibernateTxFragment.java:194) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:168) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.workspace.WorkspacesManager.store(WorkspacesManager.java:258) [dashboard-ui-core-6.0.1.Final.jar:]

      at org.jboss.dashboard.workspace.WorkspacesManager$Proxy$_$$_WeldClientProxy.store(WorkspacesManager$Proxy$_$$_WeldClientProxy.java) [dashboard-ui-core-6.0.1.Final.jar:]

      at org.jboss.dashboard.workspace.export.WorkspaceBuilder.createPanelInstance(WorkspaceBuilder.java:358) [dashboard-ui-core-6.0.1.Final.jar:]

      at org.jboss.dashboard.workspace.export.WorkspaceBuilder.createWorkspace(WorkspaceBuilder.java:128) [dashboard-ui-core-6.0.1.Final.jar:]

      at org.jboss.dashboard.workspace.export.WorkspaceBuilder$1.txFragment(WorkspaceBuilder.java:62) [dashboard-ui-core-6.0.1.Final.jar:]

      at org.jboss.dashboard.database.hibernate.HibernateTransaction.executeFragment(HibernateTransaction.java:254) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeChild(HibernateTxFragment.java:194) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:168) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.workspace.export.WorkspaceBuilder.create(WorkspaceBuilder.java:71) [dashboard-ui-core-6.0.1.Final.jar:]

      at org.jboss.dashboard.workspace.export.WorkspaceBuilder$Proxy$_$$_WeldClientProxy.create(WorkspaceBuilder$Proxy$_$$_WeldClientProxy.java) [dashboard-ui-core-6.0.1.Final.jar:]

      at org.jboss.dashboard.workspace.export.ExportManager.create(ExportManager.java:202) [dashboard-ui-core-6.0.1.Final.jar:]

      at org.jboss.dashboard.workspace.export.ExportManager$Proxy$_$$_WeldClientProxy.create(ExportManager$Proxy$_$$_WeldClientProxy.java) [dashboard-ui-core-6.0.1.Final.jar:]

      at org.jboss.dashboard.workspace.export.ImportWorkspacesModule.install(ImportWorkspacesModule.java:74) [dashboard-ui-core-6.0.1.Final.jar:]

      at org.jboss.dashboard.factory.InitialModule$1.txFragment(InitialModule.java:61) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTransaction.executeFragment(HibernateTransaction.java:254) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeChild(HibernateTxFragment.java:194) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:168) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.factory.InitialModule.doTheInstall(InitialModule.java:59) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.factory.InitialModulesManager$1.txFragment(InitialModulesManager.java:73) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTransaction.executeFragment(HibernateTransaction.java:254) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeInitiator(HibernateTxFragment.java:179) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:167) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.factory.InitialModulesManager.start(InitialModulesManager.java:67) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.factory.InitialModulesManager$Proxy$_$$_WeldClientProxy.start(InitialModulesManager$Proxy$_$$_WeldClientProxy.java) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.annotation.StartableProcessor.wakeUpStartableBeans(StartableProcessor.java:48) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.Application.start(Application.java:107) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.Application$Proxy$_$$_WeldClientProxy.start(Application$Proxy$_$$_WeldClientProxy.java) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.ui.controller.ControllerServlet$1.doWork(ControllerServlet.java:73) [dashboard-ui-core-6.0.1.Final.jar:]

      at org.jboss.dashboard.factory.Factory.runWork(Factory.java:295) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.factory.Factory.doWork(Factory.java:321) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      at org.jboss.dashboard.ui.controller.ControllerServlet.init(ControllerServlet.java:70) [dashboard-ui-core-6.0.1.Final.jar:]

      at javax.servlet.GenericServlet.init(GenericServlet.java:242) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202) [jbossweb-7.0.13.Final.jar:]

      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1102) [jbossweb-7.0.13.Final.jar:]

      at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3655) [jbossweb-7.0.13.Final.jar:]

      at org.apache.catalina.core.StandardContext.start(StandardContext.java:3873) [jbossweb-7.0.13.Final.jar:]

      at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:90) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

      at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811)

      at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)

      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [rt.jar:1.6.0_31]

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [rt.jar:1.6.0_31]

      at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_31]

      Caused by: org.hibernate.HibernateException: JDBC connection object must be a oracle.jdbc.OracleConnection a org.jboss.jca.adapters.jdbc.WrappedConnectiona org.apache.commons.dbcp.PoolableConnectionor a com.mchange.v2.c3p0.impl.NewProxyConnection. Connection class is $Proxy45

      at org.jboss.dashboard.database.hibernate.LOBHelper.oracleNullSafeSet(LOBHelper.java:129) [dashboard-commons-6.0.1.Final.jar:6.0.1.Final]

      ... 60 more

        • 1. Re: Unable to start Dashboard in jBPM6
          anton.giertli
          anton.giertli Feb 21, 2014 2:57 PM (in response to thiagz)

          Hi,

           

          can you please provide related configuration files ? This would probably include:

           

          - datasource configuration in JBoss

          - jboss-web.xml from the dashboard.war

           

          Cheers,

          Anton

            • Actions
          • 2. Re: Re: Unable to start Dashboard in jBPM6
            thiagz
            thiagz Feb 24, 2014 1:18 AM (in response to anton.giertli)

            Hi Anton,

             

            Attached the standalone.xml and jboss-web.xml. Thanks for the assistance

             

            Regards,

            Thiagz

              • Actions
            • 3. Re: Unable to start Dashboard in jBPM6
              davidredhat
              davidredhat Feb 24, 2014 11:33 AM (in response to thiagz)

              Hi Sinniah,

               

              Let me explain how we do to setup an installation on Oracle:

               

              1.- Deploy the driver's module on EAP as a module.

              You have to download and packages as a module the Oracle driver's jar.

               

              2.- Register the driver

               

              Edit & modify the target EAP/standalone/configuration/standalone-*.xml file.

               

              Add the Oracle driver definition under the <drivers> section:

               

                              <drivers>

                                  ...

                                  <driver name="oracle" module="oracle.jdbc"/>

                              </drivers>

               

              3.- Add the Oracle module as a dependency into the webapp.

              Modify the file dashbuilder.war/WEB-INF/jboss-deployment-structure.xml.

               

              Add the following snippet of configuration within the deployment tag:

               

                <dependencies>

                    <module name="oracle.jdbc" />

                </dependencies>

               

              4.- Specify the datasource to use.

               

              I don't know if you're using the EAP's default ExampleDS data source or creating a new one.

              In case you want to create a brand new data source you will need to follow this instructions:https://github.com/droolsjbpm/dashboard-builder/blob/master/builder/src/main/jbossas7/README.md#deploy-the-dashboard-builder

              If you're just reusing the existing ExampleDS data source then you should change the driver used.

               

              This is an example of an Oracle datasource definition in EAP's standalone-*.xml:

               

                             <datasource jndi-name="java:jboss/datasources/OracleDS" pool-name="OracleDS" enabled="true" use-java-context="true">

                                  <connection-url>jdbc:oracle:thin:@192.168.1.7:1521:ORCL</connection-url>

                                  <driver>oracle</driver>

                                  <security>

                                      <user-name>DASHBUILDER</user-name>

                                      <password>DASHBUILDER</password>

                                  </security>

                              </datasource>

               

               

              This is all and the only you need to do.

              The issue you're experiencing could be also caused by a wrong version of the Oracle driver.

              This is the jar I used: ojdbc6-11.2.0.3.jar


              Please, check your installation again and let me know if you find any differences.

               

              One last tip:

               

              .- As stated here: http://stackoverflow.com/questions/16033652/oracle-jdbc-driver-t4cconnection-cannot-be-cast-to-oracle-jdbc-oracleconnection

              Please check you don't have any copy of the Oracle driver jar into the webapp WEB-INF/lib dir.

               

              Hope this helps.

              Rgards,

               

              - David -

                • Actions
              • 4. Re: Re: Unable to start Dashboard in jBPM6
                thiagz
                thiagz Feb 24, 2014 11:56 PM (in response to davidredhat)

                Hi David,

                 

                Thanks for the valuable information, but I'm still encountering the same error as last time while I tried to open my dashboard. Attached the error logs and config files for your reference. Kindly help me out.

                 

                Regards,

                Sinniah

                  • Actions
                • 5. Re: Re: Re: Unable to start Dashboard in jBPM6
                  davidredhat
                  davidredhat Feb 25, 2014 12:18 PM (in response to thiagz)

                  I've checked your configuration files out and the only difference I see is how you define the driver inside the standalone.xml file.

                   

                  You have:

                   

                  <driver name="oracle" module="com.oracle">

                       <driver-class>oracle.jdbc.OracleDriver</driver-class>    
                       <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>

                  </driver>


                  And I just have:


                  <driver name="oracle" module="oracle.jdbc"/>



                  Regards,


                  - David -

                    • Actions