2 Replies Latest reply on Aug 25, 2017 6:03 PM by Anil Kumar AUP

    TEIID31100 Parsing Error

    Anil Kumar AUP Newbie

      Hi,

       

      First day with TEEID/Designer. I created a simple source model which is validating fine. But when I try to preview data I get the error below. I could try with other tables in the

      same data source which returned rows ok.

       

      I do not have any control over the schema as it belongs to a third party application.

       

      Appreciate some help.

       

      Anil

      -----------------------------------------------------------------------From console-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      13:03:52,921 INFO  [org.jboss.as.repository] (management-handler-thread - 42)  WFLYDR0001: Content added at location C:\Users\aedapara\Teiid91\teiid-9.1.1\standalone\data\content\b2\1e34f53dca75e3f6b497f5f2087488c7d2f7b2\content

      13:03:52,925 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3)  WFLYSRV0027: Starting deployment of "PREVIEW-16a30769-8cf7-4f37-a91a-0fe904af778d-vdb.xml" (runtime-name: "PREVIEW-16a30769-8cf7-4f37-a91a-0fe904af778d-vdb.xml")

      13:03:52,951 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-3)  TEIID40118 VDB PREVIEW-16a30769-8cf7-4f37-a91a-0fe904af778d.1 added to the repository

      13:03:52,952 INFO  [org.teiid.RUNTIME] (MSC service thread 1-3)  TEIID50029 VDB PREVIEW-16a30769-8cf7-4f37-a91a-0fe904af778d.1 model "OWWAUDIT" metadata is currently being loaded. Start Time: 8/24/17 1:03 PM

      13:03:52,953 WARN  [org.teiid.RUNTIME] (Worker23_async-teiid-threads35)  TEIID50036 VDB PREVIEW-16a30769-8cf7-4f37-a91a-0fe904af778d.1 model "OWWAUDIT" metadata failed to load. Reason:TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "NULL DEFAULT ''[*]N' '[*] OPTIONS(" at line 47, column 58.

      Was expecting: "and" | "between" | "in" | "is" | "like" | "like_regex" | "not" | "options" | "or" | "similar" ...: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "NULL DEFAULT ''[*]N' '[*] OPTIONS(" at line 47, column 58.

      Was expecting: "and" | "between" | "in" | "is" | "like" | "like_regex" | "not" | "options" | "or" | "similar" ...

      at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)

      at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:798)

      at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40)

      at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84)

      at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)

      at org.teiid.jboss.VDBService$6.run(VDBService.java:360)

      at org.teiid.jboss.VDBService$7.run(VDBService.java:411)

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

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

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

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at java.lang.Thread.run(Unknown Source)

      Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "NULL DEFAULT ''[*]N' '[*] OPTIONS(" at line 47, column 58.

      Was expecting: "and" | "between" | "in" | "is" | "like" | "like_regex" | "not" | "options" | "or" | "similar" ...

      at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214)

      ... 13 more

       

      13:03:52,979 INFO  [org.jboss.as.server] (management-handler-thread - 42)  WFLYSRV0010: Deployed "PREVIEW-16a30769-8cf7-4f37-a91a-0fe904af778d-vdb.xml" (runtime-name : "PREVIEW-16a30769-8cf7-4f37-a91a-0fe904af778d-vdb.xml")

      13:04:02,574 WARN  [org.teiid.PROCESSOR] (NIO1) ftVFZ57KT4E6 TEIID40011 Processing exception 'TEIID31099 VDB PREVIEW-16a30769-8cf7-4f37-a91a-0fe904af778d.1[OWWAUDIT{OWWAUDIT=OWWAUDIT, oracle, OWWAUDIT_DS}] is not active, but FAILED.  If loading you can resubmit your query after loading has completed or after the errors have been corrected.' for session ftVFZ57KT4E6.  Exception type org.teiid.core.TeiidProcessingException thrown from org.teiid.dqp.internal.process.DQPCore.checkActive(DQPCore.java:841). Enable more detailed logging to see the entire stacktrace.

      13:04:02,837 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1)  TEIID40120 VDB PREVIEW-16a30769-8cf7-4f37-a91a-0fe904af778d.1 will be removed from the repository

      13:04:02,838 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1)  TEIID40119 VDB PREVIEW-16a30769-8cf7-4f37-a91a-0fe904af778d.1 removed from the repository

      13:04:02,839 INFO  [org.teiid.RUNTIME] (MSC service thread 1-1)  TEIID50026 VDB "PREVIEW-16a30769-8cf7-4f37-a91a-0fe904af778d.1[OWWAUDIT{OWWAUDIT=OWWAUDIT, oracle, OWWAUDIT_DS}]" undeployed.

      13:04:02,840 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-6)  TEIID40120 VDB PREVIEW-16a30769-8cf7-4f37-a91a-0fe904af778d.1 will be removed from the repository

      13:04:02,846 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-6)  WFLYSRV0028: Stopped deployment PREVIEW-16a30769-8cf7-4f37-a91a-0fe904af778d-vdb.xml (runtime-name: PREVIEW-16a30769-8cf7-4f37-a91a-0fe904af778d-vdb.xml) in 9ms

      13:04:02,864 INFO  [org.jboss.as.repository] (management-handler-thread - 40)  WFLYDR0002: Content removed from location C:\Users\aedapara\Teiid91\teiid-9.1.1\standalone\data\content\b2\1e34f53dca75e3f6b497f5f2087488c7d2f7b2\content

      13:04:02,864 INFO  [org.jboss.as.server] (management-handler-thread - 40)  WFLYSRV0009: Undeployed "PREVIEW-16a30769-8cf7-4f37-a91a-0fe904af778d-vdb.xml" (runtime-name: "PREVIEW-16a30769-8cf7-4f37-a91a-0fe904af778d-vdb.xml")