Oracle connection VDB stays in Loading state when added support to execute direct query procedure

[kulbhushanc]

I am trying to deploy VDB for a oracle connection to support "SupportsDirectQueryProcedure" property.

My VDB file look like:

<?xml version="1.0" ?><vdb name="SvcSourceVdb_oracleTest" version="1"><description>VDB for: SvcSourceVdb_oracleTest, Version: 1</description><connection-type>BY_VERSION</connection-type><property name="deployment-name" value="SvcSourceVdb_oracleTest-vdb.xml"></property><model name="oracleTest" type="PHYSICAL" visible="true"><property name="importer.tableTypes" value="TABLE"></property><property name="importer.schemaPattern" value="USERNAME"></property><source name="oracleTest" translator-name="oracle" connection-jndi-name="java:/DSORACLE20161216223832036"></source></model><model name="oracleTestNative" type="PHYSICAL" visible="true"><source name="oracleTestNative" translator-name="oracle-native" connection-jndi-name="java:/DSORACLE20161216223832036"></source></model><translator name="oracle-native" type="oracle"><property name="SupportsDirectQueryProcedure" value="true"></property></translator></vdb>

It stays in Loading state for longer time and after it return VDB status as failed.

When I remove model "oracleTestNative" then it work fine.... i.e. VDB gets activated after some time of deployment.

Note: I am using teiid 8.13

Thanks,

Kulbhushan Chaskar

[rareddy]

What is error when it failed? You can look at the errors through web-console or it will also be on console where the server started.