Import of an LDAP source into JBDS Teiid Designer does not prevent invalid characters

Solution Verified - Updated -

Issue

  • When a SOAP Web Service is generated from a LDAP Source Model, the "File_Output_View.xmi" has an error.
  • Receive error similar to:
org.teiid.runtime.client.TeiidClientException: Error in parsing of sql - Encountered " "=" "= "" at line 1, column 26.
Was expecting one of:
    <EOF> 
    "as" ...
    "fetch" ...
    "group" ...
    "having" ...
    "intersect" ...
    "limit" ...
    "makedep" ...
    "makenotdep" ...
    "offset" ...
    "order" ...
    "where" ...
    "instead" ...
    "enabled" ...
    "disabled" ...
    "view" ...
    "key" ...
    "serial" ...
    "textagg" ...
    "count" ...
    "row_number" ...
    "rank" ...
    "dense_rank" ...
    "sum" ...
    "avg" ...
    "min" ...
    "max" ...
    "every" ...
    "stddev_pop" ...
    "stddev_samp" ...
    "var_samp" ...
    "var_pop" ...
    "document" ...
    "content" ...
    "trim" ...
    "empty" ...
    "ordinality" ...
    "path" ...
    "first" ...
    "last" ...
    "next" ...
    "substring" ...
    "extract" ...
    "to_chars" ...
    "to_bytes" ...
    "timestampadd" ...
    "timestampdiff" ...
    "querystring" ...
    "namespace" ...
    "result" ...
    "index" ...
    "accesspattern" ...
    "auto_increment" ...
    "wellformed" ...
    "sql_tsi_frac_second" ...
    "sql_tsi_second" ...
    "sql_tsi_minute" ...
    "sql_tsi_hour" ...
    "sql_tsi_day" ...
    "sql_tsi_week" ...
    "sql_tsi_month" ...
    "sql_tsi_quarter" ...
    "sql_tsi_year" ...
    "texttable" ...
    "arraytable" ...
    "selector" ...
    "skip" ...
    "width" ...
    "passing" ...
    "name" ...
    "encoding" ...
    "columns" ...
    "delimiter" ...
    "quote" ...
    "header" ...
    "nulls" ...
    "objecttable" ...
    "version" ...
    "including" ...
    "excluding" ...
    "xmldeclaration" ...
    "variadic" ...
    "exception" ...
    "raise" ...
    "chain" ...
    "jsonarray_agg" ...
    "jsonobject" ...
    <ID> ...
    "," ...
    ";" ...

    at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:235)
    at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:224)
    at org.teiid.query.parser.QueryParser.parseDesignerCommand(QueryParser.java:194)
    at org.teiid.query.parser.QueryParser.parseDesignerCommand(QueryParser.java:1)
    at org.teiid.designer.transformation.aspects.sql.SqlTransformationMappingRootSqlAspect.parseSQL(SqlTransformationMappingRootSqlAspect.java:523)
    at org.teiid.designer.transformation.aspects.sql.SqlTransformationMappingRootSqlAspect.getTransformationInfo(SqlTransformationMappingRootSqlAspect.java:386)
    at org.teiid.designer.core.metadata.runtime.RuntimeAdapter.addTransformationWords(RuntimeAdapter.java:411)
    at org.teiid.designer.core.metadata.runtime.RuntimeAdapter.addIndexWord(RuntimeAdapter.java:171)
    at org.teiid.designer.core.index.ModelIndexer.addIndexWord(ModelIndexer.java:311)
    at org.teiid.designer.core.index.ModelIndexer.index(ModelIndexer.java:164)
    at org.teiid.designer.core.index.Index.add(Index.java:127)
    at org.teiid.designer.core.index.ModelIndexer.indexResource(ModelIndexer.java:240)
    at org.teiid.designer.core.builder.ModelBuildUtil.indexResource(ModelBuildUtil.java:312)
    at org.teiid.designer.core.builder.ModelBuildUtil.indexResources(ModelBuildUtil.java:375)
    at org.teiid.designer.core.builder.ModelBuildUtil.indexResources(ModelBuildUtil.java:366)
    at org.teiid.designer.core.builder.ModelBuildUtil.buildResources(ModelBuildUtil.java:124)
    at org.teiid.designer.core.builder.ModelBuilder$2.run(ModelBuilder.java:234)
    at org.teiid.designer.core.ModelEditorImpl.executeAsTransaction(ModelEditorImpl.java:567)
    at org.teiid.designer.core.ModelEditorImpl.executeAsTransaction(ModelEditorImpl.java:530)
    at org.teiid.designer.core.builder.ModelBuilder.performIncrementaBuild(ModelBuilder.java:247)
    at org.teiid.designer.core.builder.ModelBuilder.buildInternal(ModelBuilder.java:103)
    at org.teiid.designer.core.builder.AbstractTeiidProjectBuilder.build(AbstractTeiidProjectBuilder.java:76)
    at org.eclipse.core.internal.events.BuildManager$2.run(BuildManager.java:734)
    at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
    at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:206)
    at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:246)
    at org.eclipse.core.internal.events.BuildManager$1.run(BuildManager.java:299)
    at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
    at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:302)
    at org.eclipse.core.internal.events.BuildManager.basicBuildLoop(BuildManager.java:358)
    at org.eclipse.core.internal.events.BuildManager.build(BuildManager.java:381)
    at org.eclipse.core.internal.events.AutoBuildJob.doBuild(AutoBuildJob.java:143)
    at org.eclipse.core.internal.events.AutoBuildJob.run(AutoBuildJob.java:241)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Environment

  • Red Hat JBoss Developer Studio (JBDS) 8.1
  • Teiid Designer 9.0.5

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content