-
1. Re: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1
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.
-
2. Re: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1
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
-
3. Re: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1
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.
-
4. Re: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1
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.
-
5. Re: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1
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.
-
6. Re: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1
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
-
7. Re: Remote org.teiid.core.TeiidProcessingException: TEIID31099 VDB PREVIEW-74aaa130-73f0-4bee-a7d6-6f27538c8a26.1
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.