Import of an LDAP source into JBDS Teiid Designer does not prevent invalid characters
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.