1 2 Previous Next 18 Replies Latest reply on May 21, 2013 8:09 AM by rareddy

    Issue in creating and accessing data from VDB in Teiid 7.4

    maytagu

      Hi

       

      I am exploring Data virtualization using Teiid 7.4 version. Following Quick Start example I have successfully deployed a VDB (VDB is up and active i.e. verified through jboss-admin console) but when I am trying to fetch data from tables through VDB it is throwing org.teiid.jdbc.TeiidSQLException and message is displyed that table Group does not exist. Can anyone tell me how to fetch data using VDB and in which Group server is searching for tables whereas they all exists in database. Data retreival is done through Simple Client example given in Teiid itself and fetched query is : run localhost 31000 DynamicPortfolio "Select * from Customer"

      Logs attached:

      org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryResolverException: Group does not exist: Customer

              at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)

              at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)

              at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:629)

              at org.teiid.jdbc.StatementImpl.access$000(StatementImpl.java:71)

              at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:543)

              at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)

              at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)

              at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)

              at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:218)

              at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:253)

              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

              at java.lang.reflect.Method.invoke(Unknown Source)

              at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:108)

              at $Proxy1.read(Unknown Source)

              at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:347)

              at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:333)

              at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:555)

              at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:354)

              at JDBCClient.execute(JDBCClient.java:106)

              at JDBCClient.main(JDBCClient.java:55)

      Caused by: [TeiidProcessingException]Remote org.teiid.api.exception.query.QueryResolverException: Group does not exist: Customer

              at org.teiid.query.resolver.util.ResolverUtil.handleUnresolvedGroup(ResolverUtil.java:824)

              at org.teiid.query.resolver.util.ResolverUtil.resolveGroup(ResolverUtil.java:911)

              at org.teiid.query.resolver.QueryResolver.isXMLQuery(QueryResolver.java:372)

              at org.teiid.query.resolver.QueryResolver.chooseResolver(QueryResolver.java:317)

              at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:291)

              at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:147)

              at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:283)

              at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:383)

              at org.teiid.dqp.internal.process.Request.processRequest(Request.java:452)

              at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:425)

              at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:224)

              at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:56)

              at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197)

              at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)

              at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)

              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:619)

        • 1. Re: Issue in creating and accessing data from VDB in Teiid 7.4
          rareddy

          Mayank,

           

          I believe you are working with Dynamic VDB. Did you check if you have created the Customer table in the source database  correctly and you can access it through any other SQL tool like SQuirreL?

           

          If yes to above, try fully qualifying the table name with any schema information, like "select * from schema.Customer"

           

          Ramesh..

          • 2. Re: Issue in creating and accessing data from VDB in Teiid 7.4
            maytagu

            Hi Ramesh , thx for reply.

             

            Yes I have checked the table Customer and it is accessble through SQL command prompt.

             

            I have tried creating VDB and Datasource through Eclipse installed Teiid Designer and there I am able to create VDB but when trying to access data error thrown is to validate the jdbc username and password in Teiid server, don't know where to validate them.

            • 3. Re: Issue in creating and accessing data from VDB in Teiid 7.4
              rareddy

              Mayank,

               

              If you are using Teiid Designer, it needs to connect to your server for deploying the VDB, datasource and execute queries. Teiid as two separate connections one for the administrative stuff (deploy, undeploy) and one for execution (jdbc connection), those need to setup these connections before you can execute. See the below picture, to see where those connection properties need be entered.

               

              Teiid.jpg

               

              HTH

               

              Ramesh..

              • 4. Re: Issue in creating and accessing data from VDB in Teiid 7.4
                maytagu

                yes I have given credentials for both Teiid server connection and Teiid JDBC connection. Also VDB is successfully deployed with Datasources but after that while executing the VDB it asks for validation of JDBC username and password. I think it is not able to establish connection with database.

                (here Parts2 is the name of VDB)

                Error log:

                Could not connect to Parts2 - localhost - Teiid Connection.

                Error creating SQL Model Connection connection to Parts2 - localhost - Teiid Connection. (Error: Unable to find a component used authenticate on to Teiid)

                Unable to find a component used authenticate on to Teiid

                Error creating JDBC Connection connection to Parts2 - localhost - Teiid Connection. (Error: Unable to find a component used authenticate on to Teiid)

                Unable to find a component used authenticate on to Teiid

                • 5. Re: Issue in creating and accessing data from VDB in Teiid 7.4
                  maytagu

                  I am following http://www.jboss.org/teiiddesigner/downloads/examples.html link for parts-project example with documentation.

                  If you can also try it out at your end (will hardly take much time) then it will be very helpful for me as we can examine it, is it working fine or not or i am missing some configuration setting somewhere.

                  • 6. Re: Issue in creating and accessing data from VDB in Teiid 7.4
                    sshahab

                    Hello Mayank,

                     

                    Did you get the answer? I also have the same problem, please help..

                     

                    Regards

                    • 7. Re: Issue in creating and accessing data from VDB in Teiid 7.4
                      rareddy

                      Shamimuddiin,

                       

                      What verion of JBoss AS you are using? You must use JBoss-AS 5.1.0 GA. The above indicates that Teiid is not installed correctly on JBoss AS. Start with fresh install of JBoss AS and unzip the Teiid, if one of profile directories like "default". Check out the installation instructions.

                       

                      Ramesh..

                      • 8. Re: Issue in creating and accessing data from VDB in Teiid 7.4
                        sshahab

                        Hello Ramesh,

                         

                        Yeah, I;m using  "jboss-5.1.0.GA"

                         

                        and I made a copy of "all" profile as "teiid"  and inside "teiid" unzipped "teiid-7.4.0.Final-jboss-dist.zip" and did some changed such as :

                         

                         

                        /sw/pkg/jboss-5.1.0.GA/server/teiid/deploy/messaging/messaging-service.xml:

                         

                         

                        (Modified)<attribute name="SuckerPassword">swJbossInstance1</attribute>

                         

                         

                        /sw/pkg/jboss-5.1.0.GA/server/teiid/deploy/messaging/

                        messaging-jboss-beans.xml:  

                        (Modified)<property name="suckerPassword">swJbossInstance1</property>

                         

                         

                         

                         

                         

                        /sw/pkg/jboss-5.1.0.GA/server/teiid/deploy/messaging/hsqldb-persistence-service.xml:

                         

                        (Changed)

                        <depends optional-attribute-name="ChannelFactoryName">jboss.jgroups:service=ChannelFactory</depends>

                         

                        <attribute name="ControlChannelName">jbm-control</attribute>

                         

                        <attribute name="DataChannelName">jbm-data</attribute>

                         

                        <attribute name="ChannelPartitionName">${jboss.partition.name:DefaultPartition}-JMS</attribute>

                         

                         

                         

                        (To)

                        <depends optional-attribute-name="ChannelFactoryName">jboss.jgroups:service=ChannelFactory</depends>

                         

                        <attribute name="ControlChannelName">tcp</attribute>

                         

                        <attribute name="DataChannelName">tcp</attribute>

                         

                        <attribute name="ChannelPartitionName">${jboss.partition.name:DefaultPartition}-JMS</attribute>

                         

                         

                         

                         

                        This change was made to enable the distributed cache service that Teiid provides.

                         

                        /sw/pkg/jboss-5.1.0.GA/server/teiid/deploy/teiid

                        :

                        (Change)mv teiid-cache-manager-jboss-beans-rename-me.xml teiid-cache-manager-jboss-beans.xml

                         

                         

                        and restart server as:

                         

                        run.sh -g teiid -b <IPof localhost> -c teiid -Djboss.Domain=teiid -Djboss.jvmRoute="node1nomulticast" -Djboss.default.jgroups.stack=tcp -Djboss.jgroups.tcp.tcpping.initial_hosts="<ip of node1>[7600],<ip of node 2>[7600]" -Djboss.messaging.ServerPeerID=1

                         

                         

                         

                         

                        I follow all instructions as metioned in the readme folder's HTML file.

                         

                        Simple client example works and it spit out the data. But when i try to deploy part project, I'm able to generate DDL and create table and Load data to tables on remote Linux box, but when I run Preview Data for VDB, it fails. It create  PREVIEW****.xml and PREVIEW.vdb file also under deploy folder on server.

                         

                        Please help what I'm missing.

                        • 9. Re: Issue in creating and accessing data from VDB in Teiid 7.4
                          rareddy

                          Shamimuddin,

                           

                          I do not think I know what exactly is the issue you are having? The solution above I mentioned is for

                           

                          "Error: Unable to find a component used authenticate on to Teiid"

                           

                          Looks like you are past that error, if you have made the simple client work. Now from you description you seem to having issues with previewing the data from Designer. What is the error you are seeing in message log panel?

                           

                          Ramesh..

                          • 10. Re: Issue in creating and accessing data from VDB in Teiid 7.4
                            sshahab

                            Hello Ramesh,

                             

                            here is the error I'm gettign when I start to PREEVIEW data.(Select the table(PARTS) usner view model PartsSourceA and right click Modeling>Preview Data)

                             

                            select * from "PartsSourceA"."PARTS"

                            Remote org.teiid.core.TeiidProcessingException: PartsSourceA: Unable to get managed connection for PREVIEW_35b8b5bf-321b-41b3-93b4-fdc20caee2be_PartsProject_PartsSourceA; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for PREVIEW_35b8b5bf-321b-41b3-93b4-fdc20caee2be_PartsProject_PartsSourceA)


                            Elapsed Time:  0 hr, 0 min, 0 sec, 0 ms.

                            Please help.

                             

                            Regards

                            • 11. Re: Issue in creating and accessing data from VDB in Teiid 7.4
                              rareddy

                              Shamimuddin,

                               

                              As the error says the designer is failing to find the connection to the source thus it is failing. We have seen this issue before, sometimes restarting the Designer will fix the issue. Otherwise Right Click on the source model for which the connection is not found, select

                               

                              Modeling ->View Connection Profile Info

                               

                              if that is not source you are going after then, use

                               

                              Modeling -> Set Connection Profile  Info

                               

                              to set the correct connection profile for your source, then use the preview.

                               

                               

                               

                              Ramesh..

                              • 12. Re: Issue in creating and accessing data from VDB in Teiid 7.4
                                sshahab

                                Here is the images for each steps:

                                Please let me know if you need any other information.

                                 

                                1. For database perspective:(It works fine)

                                database_perpestive.jpg

                                 

                                2. Connection information:(which is exactly same as in database perspective)

                                connection_info.jpg

                                3. One steps before preview data:

                                one_step_before_preview.jpg

                                 

                                4. And the preview data( with errors)

                                preview.jpg

                                 

                                I really appreciate your patience. Requesting to help me out with this please..

                                 

                                 

                                Regards

                                • 13. Re: Issue in creating and accessing data from VDB in Teiid 7.4
                                  rareddy

                                  They all look fine.

                                   

                                  Did you copy "mysql" JDBC jar into JBoss AS server's "<jboss-as>/server/<profile>/lib" directory, and restarted the server? If not please do. If you already did that then, do you see any errors on the server side?

                                   

                                  Ramesh..

                                  • 14. Re: Issue in creating and accessing data from VDB in Teiid 7.4
                                    sshahab

                                    A Very Big Thank you to You Ramesh,

                                     

                                    You are excellent!

                                     

                                    It is  done... The problem, I did not copy the JDBC driver to lib.

                                     

                                     

                                    Regards

                                    1 2 Previous Next