[teiid-issues] [JBoss JIRA] Commented: (TEIID-1559) Dynamic VDB deployed in inactive state on Oracle11g

[Boris Belovic (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12596720#comment-12596720 ] 

Boris Belovic commented on TEIID-1559:
--------------------------------------

Just to sum up what my case is doing:

1. start SOA-P server
2. create Employees table in DB and insert 4 Employee object into DB (this is done through Hibernate)
3. deploy WAR file, ESB file and dynamic VDB
4. query VDB
5. undeploy everything and delete table from database.
6. stop SOA-P server

> Dynamic VDB deployed in inactive state on Oracle11g
> ---------------------------------------------------
>
>                 Key: TEIID-1559
>                 URL: https://issues.jboss.org/browse/TEIID-1559
>             Project: Teiid
>          Issue Type: Bug
>          Components: Server
>    Affects Versions: 7.1.1
>         Environment: Oracle 11g R2, driver version: 11.2.0.1.0
> Teiid 7.1.1 in SOA-P 5.1
>            Reporter: Boris Belovic
>            Assignee: Steven Hawkins
>         Attachments: mytext-ds.xml, myvdb-vdb.xml, oracle-ds.xml
>
>
> Dynamic VDB is deployed in inactive state on SOA-P 5.1 server configured with Oracle 11g R2 database. First I deploy both datasources required by VDB and then dynamic VDB itself. But the VDB remains in inactive state, despite all datasources referred by this VDB are in place (= deployed correctly). Few seconds after deployment of VDB I got this exception from the server.
> 08:42:24,335 INFO  [RUNTIME] VDB "myvdb-1" - "Employees" model metadata is currently being loaded. Start Time: 4/19/11 8:42 AM
> 08:42:24,355 INFO  [PROCESSOR] Clearing prepared plan cache
> 08:42:24,358 INFO  [RUNTIME] VDB "myvdb.1[Employees[oracle-connector/oracle/java:DefaultDS], TextFileData[text-connector/file/java:TxtFileDS]]" deployed in inactive state.
> 08:42:50,307 WARN  [RunnableTaskWrapper] Unhandled throwable for runnable: org.teiid.deployers.VDBDeployer$1 at 13bf30c
> java.lang.AssertionError: Duplicate Table APEX_ACTIVITY_LOG
> 	at org.teiid.metadata.Schema.addTable(Schema.java:42)
> 	at org.teiid.metadata.MetadataFactory.addTable(MetadataFactory.java:82)
> 	at org.teiid.translator.jdbc.JDBCMetdataProcessor.getTables(JDBCMetdataProcessor.java:195)
> 	at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:110)
> 	at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:268)
> 	at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:80)
> 	at org.teiid.dqp.internal.datamgr.ConnectorManager.getMetadata(ConnectorManager.java:125)
> 	at org.teiid.deployers.VDBDeployer.loadMetadata(VDBDeployer.java:310)
> 	at org.teiid.deployers.VDBDeployer.access$000(VDBDeployer.java:59)
> 	at org.teiid.deployers.VDBDeployer$1.run(VDBDeployer.java:293)
> 	at org.jboss.util.threadpool.RunnableTaskWrapper.run(RunnableTaskWrapper.java:147)
> 	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)
> I also tried deploying this VDB on MySQL 5.1 and PostgreSQL 8.3 and the VDB was deployed without any problems or exceptions.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira