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

[debashishsaha004]

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

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

[rareddy]

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..

[debashishsaha004]

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 :

[rareddy]

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

[debashishsaha004]

Thank you very much .It worked.