1 2 Previous Next 18 Replies Latest reply: May 21, 2013 8:09 AM by Ramesh Reddy RSS

Issue in creating and accessing data from VDB in Teiid 7.4

Mayank Gupta Newbie

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
    Ramesh Reddy Master

    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
    Mayank Gupta Newbie

    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
    Ramesh Reddy Master

    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
    Mayank Gupta Newbie

    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
    Mayank Gupta Newbie

    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
    Shamimuddin FNU Newbie

    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
    Ramesh Reddy Master

    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
    Shamimuddin FNU Newbie

    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
    Ramesh Reddy Master

    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
    Shamimuddin FNU Newbie

    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
    Ramesh Reddy Master

    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
    Shamimuddin FNU Newbie

    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
    Ramesh Reddy Master

    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
    Shamimuddin FNU Newbie

    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