-
1. Re: Preview Data step in Jboss Data virtualization throwing error TEIID31100.Why?
rareddy Oct 10, 2016 8:57 AM (in response to debashishsaha004)1 of 1 people found this helpfulDebashish,
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.. -
2. Re: Preview Data step in Jboss Data virtualization throwing error TEIID31100.Why?
debashishsaha004 Oct 10, 2016 11:17 AM (in response to rareddy)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 :
-
3. Re: Preview Data step in Jboss Data virtualization throwing error TEIID31100.Why?
rareddy Oct 10, 2016 11:34 AM (in response to debashishsaha004)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
-
4. Re: Preview Data step in Jboss Data virtualization throwing error TEIID31100.Why?
debashishsaha004 Oct 10, 2016 12:27 PM (in response to rareddy)Thank you very much .It worked.