4 Replies Latest reply on Oct 10, 2016 12:27 PM by Debashish Saha

    Preview Data step in Jboss Data virtualization throwing error TEIID31100.Why?

    Debashish Saha Newbie

      The Eap 6.4 server is up and running.Test connection is also successful.Pic2.PNGPic1.PNG

      The error that is thrown is also shown here.

      Only the address table is showing all the data but rest all the tables is not showing.

      The server log while I tried to preview data for client is uploaded here

        • 1. Re: Preview Data step in Jboss Data virtualization throwing error TEIID31100.Why?
          Ramesh Reddy Master

          Debashish,

           

          I see the error in log as

           

          Was expecting: id
            at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
            at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:768) [teiid-api-8.12.5.redhat-8.jar:8.12.5.redhat-8]
            at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
            at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84) [teiid-runtime-8.12.5.redhat-8.jar:8.12.5.redhat-8]
            at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
            at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.12.5.redhat-8.jar:8.12.5.redhat-8]
            at org.teiid.jboss.VDBService$7.run(VDBService.java:446) [teiid-jboss-integration-8.12.5.redhat-8.jar:8.12.5.redhat-8]
            at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt.jar:1.8.0_101]
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.8.0_101]
            at java.lang.Thread.run(Unknown Source) [rt.jar:1.8.0_101]
            at org.jboss.threads.JBossThread.run(JBossThread.java:122)
          Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "), CONSTRAINT [*]PRIMARY[*] PRIMARY KEY" at line 7, column 20.
          Was expecting: id
            at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
            ... 11 more
          

           

          That means the Primary Key Name you used on tables is like "PRIMARY KEY" which is a reserved word. Change the name of it to something like "PK1" and then redeploy, that should work.


          Ramesh..

          1 of 1 people found this helpful
          • 2. Re: Preview Data step in Jboss Data virtualization throwing error TEIID31100.Why?
            Debashish Saha Newbie

            Firstly ,Thank you very much for Solving the Problem.

            But it seems there is an issue still existing.

            For all the table I can see the preview except <Client_type >table.

            the client_type table does not have any primary key or foreign key.

            the address table also does not have any keys.

            But address is previewing data but not client_type table.

             

            The server Log is :

            Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "'VARCHAR'), [*]value[*] string(" at line 4, column 9.

            Was expecting: "constraint" | "foreign" | "primary" | "unique" | id

              at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]

             

            the create table command for both table was :

             

            ClientType.PNGAdressTable.PNG

            • 3. Re: Preview Data step in Jboss Data virtualization throwing error TEIID31100.Why?
              Ramesh Reddy Master

              value keyword is also a reserved word. You can either define it in quotes like "value" or change that to something else. If you change to something else, then you also need to change "NameInSource" property of that column to represent the original vlaue as value