Data Virtualization Dashboard fails after configuring DashboardDS to external database
Issue
- After changing DashboardDS definition to write audit logs to a remote Oracle database, receive errors
- server.log contains error similar to below when teiid-dashboard-builder.war is configured to use external database:
18:52:26,137 ERROR [org.jboss.dashboard.error.ErrorManager] (ServerService Thread Pool -- 65) UNEXPECTED ERROR.
Thread id=ServerService Thread Pool -- 65
Thread begin date=Mon May 11 18:52:23 UTC 2015
Thread group=ServerService ThreadGroup
Tx id=1390421374
Tx Isolation=2
Tx Auto commit=false
Error id=1431370346136
Error date=Mon May 11 18:52:26 UTC 2015
Error stack trace=java.lang.ClassNotFoundException: oracle.sql.BLOB from [Module "deployment.teiid-dashboard-builder.war:main" from Service Module Loader]
at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:213)
at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459)
at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408)
at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389)
at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:191)
at org.jboss.dashboard.database.hibernate.LOBHelper.oracleNullSafeSet(LOBHelper.java:92)
at org.jboss.dashboard.database.hibernate.LOBHelper.nullSafeSet(LOBHelper.java:200)
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:158)
at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2798)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3076)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3521)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:387)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:303)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1159)
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.SkinsManagerImpl.start(SkinsManagerImpl.java:35)
at org.jboss.dashboard.workspace.SkinsManagerImpl$Proxy$_$$_WeldClientProxy.start(SkinsManagerImpl$Proxy$_$$_WeldClientProxy.java)
at org.jboss.dashboard.annotation.StartableProcessor.wakeUpStartableBeans(StartableProcessor.java:48)
at org.jboss.dashboard.Application.start(Application.java:94)
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:1194)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1100)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3591)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3798)
at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:161)
at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:59)
at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:94)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Environment
- Red Hat JBoss Data Virtualization (DV) 6.1
- Oracle Datasource with driver deployed as a Module:
<driver name="oracle" module="com.oracle">
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.