Data Virtualization Dashboard fails after configuring DashboardDS to external database

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.