7 Replies Latest reply on Jan 20, 2017 3:47 PM by rhn-engineering-rareddy

    Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1

    rahulsharma1392
    rahulsharma1392 Jan 18, 2017 5:08 AM

      Hello,

       

      After creating view, while i am going to view it's data using preview. below exception is coming.

       

      java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1[NonActiveOfficerPaid{}, employee{employee=employee, mysql5, mySql_DS}, g4sSchedular{g4sSchedular=g4sSchedular, mysql5, mySql_DS}, contract{contract=contract, mysql5, mySql_DS}, countryModel{countryModel=countryModel, mysql5, java:/mySql_DS}] is not active, but FAILED.  If loading you can resubmit your query after loading has completed or after the errors have been corrected.

        • 1. Re: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1
          rareddy
          rareddy Jan 18, 2017 9:43 AM (in response to rahulsharma1392)

          Looks like there are errors in your model, they need to be corrected before view can work.

            • Actions
          • 2. Re: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1
            rahulkumarsharma
            rahulkumarsharma Jan 18, 2017 11:36 PM (in response to rareddy)

            But there is no error, displayed by TEIID Designer.

            Sql Script is correct, looks all fine. but still not running

              • Actions
            • 3. Re: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1
              rareddy
              rareddy Jan 19, 2017 10:34 AM (in response to rahulkumarsharma)

              What are errors from server side of the log? look in "jvd/standalone/logs" directory for "server.log" file.

                • Actions
              • 4. Re: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1
                rahulkumarsharma
                rahulkumarsharma Jan 20, 2017 12:13 AM (in response to rareddy)

                I am using aggregate functions in query and some other features of sql like group by and order by. I am also fetching data from multiple databases.

                It seems that it is throwing due to this.

                  • Actions
                • 5. Re: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1
                  rhn-engineering-rareddy
                  rhn-engineering-rareddy Jan 20, 2017 8:38 AM (in response to rahulkumarsharma)

                  No, it will not. Basically those are the features that Teiid/JDV is designed to provide. According to your first comment, the VDB is not active, it only means one thing, the model has errors/invalid. You been saying otherwise, so please provide the logs so that we can further help with the issue. If there are no details in the logs, turn on log level to DEBUG and then capture the logs in the server.

                   

                  To turn debug, edit the standalone.xml and add below in the logging section.

                  <logger category="org.teiid.COMMAND_LOG">

                               <level name="DEBUG"/>

                  </logger>

                   

                  If not use the web-console to do the same.

                    • Actions
                  • 6. Re: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1
                    rahulsharma1392
                    rahulsharma1392 Jan 20, 2017 1:46 PM (in response to rhn-engineering-rareddy)

                    This is error log:

                     

                     

                     

                    13:47:45,615 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-5) TEIID40118 VDB PREVIEW-f2144ff4-1068-46a2-a29b-aa6478f48168.1 added to the repository

                    13:47:45,616 INFO  [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50029 VDB PREVIEW-f2144ff4-1068-46a2-a29b-aa6478f48168.1 model "g4sSchedulerModel" metadata is currently being loaded. Start Time: 20/1/17 1:47 PM

                    13:47:45,619 WARN  [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50036 VDB PREVIEW-f2144ff4-1068-46a2-a29b-aa6478f48168.1 model "g4sSchedulerModel" metadata failed to load. Reason:TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "boolean DEFAULT 'b'[*]1[*]'' OPTIONS" at line 19, column 38.

                    Was expecting: "options" | "," | ")": org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "boolean DEFAULT 'b'[*]1[*]'' OPTIONS" at line 19, column 38.

                    Was expecting: "options" | "," | ")"

                      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(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_80]

                      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_80]

                      at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_80]

                      at org.jboss.threads.JBossThread.run(JBossThread.java:122)

                    Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "boolean DEFAULT 'b'[*]1[*]'' OPTIONS" at line 19, column 38.

                    Was expecting: "options" | "," | ")"

                      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

                      • Actions
                    • 7. Re: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1
                      rhn-engineering-rareddy
                      rhn-engineering-rareddy Jan 20, 2017 3:47 PM (in response to rahulsharma1392)

                      Fix the error being presented by

                       

                      TEIID31100 Parsing error: Encountered "boolean DEFAULT 'b'[*]1[*]'' OPTIONS" at line 19, column 38.

                      Was expecting: "options" | "," | ")": org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "boolean DEFAULT 'b'[*]1[*]'' OPTIONS" at line 19, column 38.

                      Was expecting: "options" | "," | ")"

                       

                      If I see the whole DDL I can tell what you are doing wrong. Post the VDB contents, at least that section of it.

                        • Actions