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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content