[teiid-issues] [JBoss JIRA] (TEIID-3715) MongoDB metadata import fails

MongoDB metadata import fails ----------------------------- Key: TEIID-3715 URL: https://issues.jboss.org/browse/TEIID-3715 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 8.7.1.6_2 Reporter: Andrej Šmigala Assignee: Ramesh Reddy Deploying the following dynamic vdb fails when Teiid Connection importer is used: {code} <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <vdb name="mongo" version="1"> <description>Importer VDB</description> <property name="UseConnectorMetadata" value="true" /> <property name="deployment-name" value="mongo-vdb.xml" /> <model name="importVDBSrcModel"> <source name="importVDBSrcModel" translator-name="mongodb" connection-jndi-name="java:/mongoDS" /> </model> </vdb> {code} The resource adapter is defined as: {code} <resource-adapter id="mongoDS"> <module slot="main" id="org.jboss.teiid.resource-adapter.mongodb"/> <transaction-support>NoTransaction</transaction-support> <connection-definitions> <connection-definition class-name="org.teiid.resource.adapter.mongodb.MongoDBManagedConnectionFactory" jndi-name="java:/mongoDS" enabled="true" use-java-context="true" pool-name="mongoDS"> <config-property name="Database"> bqt </config-property> <config-property name="RemoteServerList"> vmgdb01.mw.lab.eng.bos.redhat.com:27017 </config-property> <config-property name="Username"> dv </config-property> <config-property name="Password"> dv </config-property> </connection-definition> </connection-definitions> </resource-adapter> {code} Server log: {code} 08:26:05,590 WARN [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB mongo.1 model "importVDBSrcModel" metadata failed to load. Reason:not authorized for query on bqt.system.users: com.mongodb.MongoException: not authorized for query on bqt.system.users at com.mongodb.MongoException.parse(MongoException.java:82) at com.mongodb.DBApiLayer$MyCollection.__find(DBApiLayer.java:292) at com.mongodb.DBApiLayer$MyCollection.__find(DBApiLayer.java:273) at com.mongodb.DBCursor._check(DBCursor.java:368) at com.mongodb.DBCursor._hasNext(DBCursor.java:459) at com.mongodb.DBCursor.hasNext(DBCursor.java:484) at org.teiid.translator.mongodb.MongoDBMetadataProcessor.process(MongoDBMetadataProcessor.java:58) at org.teiid.translator.mongodb.MongoDBMetadataProcessor.process(MongoDBMetadataProcessor.java:39) at org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:935) [teiid-api-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:73) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at org.teiid.jboss.VDBService$7.run(VDBService.java:442) [teiid-jboss-integration-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_60] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_60] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_60] at org.jboss.threads.JBossThread.run(JBossThread.java:122) {code}