Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3715

MongoDB metadata import fails

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Major
    • 8.12.5
    • 8.7.1.6_2
    • JDBC Connector
    • None

    Description

      Deploying the following dynamic vdb fails when Teiid Connection importer is used:

      <?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>
      

      The resource adapter is defined as:

                      <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>
      

      Server log:

      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)
      
      

      Attachments

        Issue Links

          Activity

            People

              rhn-engineering-rareddy Ramesh Reddy
              asmigala@redhat.com Andrej Smigala
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: