org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "), CONSTRAINT []PRIMARY[] PRIMARY KEY" at line 7, column 20. Was expecting: id: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "), CONSTRAINT []PRIMARY[] PRIMARY KEY" at line 7, column 20. Was expecting: id

  1. 0

    The preview data in Jboss Data virtualization is throwing error TEIID31100 why ?

    Stack Overflow | 2 months ago | Debashish Saha
    org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "), CONSTRAINT []PRIMARY[] PRIMARY KEY" at line 7, column 20. Was expecting: id: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "), CONSTRAINT []PRIMARY[] PRIMARY KEY" at line 7, column 20. Was expecting: id

    Root Cause Analysis

    1. 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()
    2. org.teiid.query
      QueryParser.parseDDL
      1. org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214)[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      2. org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      2 frames
    3. org.teiid.metadata
      MetadataFactory.parse
      1. org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:768)[teiid-api-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      1 frame
    4. org.teiid.query
      DDLMetadataRepository.loadMetadata
      1. org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40)[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      1 frame
    5. org.teiid.runtime
      AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata
      1. org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84)[teiid-runtime-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      1 frame
    6. org.teiid.query
      ChainingMetadataRepository.loadMetadata
      1. org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)[teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      1 frame
    7. org.teiid.jboss
      VDBService$7.run
      1. org.teiid.jboss.VDBService$6.run(VDBService.java:395)[teiid-jboss-integration-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      2. org.teiid.jboss.VDBService$7.run(VDBService.java:446)[teiid-jboss-integration-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      2 frames
    8. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)[rt.jar:1.8.0_101]
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)[rt.jar:1.8.0_101]
      3. java.lang.Thread.run(Unknown Source)[rt.jar:1.8.0_101]
      3 frames
    9. JBoss Threads
      JBossThread.run
      1. org.jboss.threads.JBossThread.run(JBossThread.java:122)
      1 frame