[teiid-issues] [JBoss JIRA] (TEIID-4368) Fail to deploy VDB with TextTable SELECTOR, ROW DELIMITER, HEADER

[Lucie Fabrikova (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13276211#comment-13276211 ] 

Lucie Fabrikova edited comment on TEIID-4368 at 8/8/16 10:16 AM:
-----------------------------------------------------------------

I see, thanks for clarification... and what is wrong with the SELECTOR? Deploy gives this:
15:24:53,276 WARN  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 model5.v3 validation error: TEIID31100 Parsing error: Encountered "('a' SELECTOR [*]a[*] COLUMNS y" at line 1, column 40.                                                                                                                                                
Was expecting: <STRINGVAL> 

EDIT - I entered part of teiid 8.12 server log, the 8.7 server produced different error. See TEIID-4371


was (Author: lfabriko):
I see, thanks for clarification... and what is wrong with the SELECTOR? Deploy gives this:
15:24:53,276 WARN  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 model5.v3 validation error: TEIID31100 Parsing error: Encountered "('a' SELECTOR [*]a[*] COLUMNS y" at line 1, column 40.                                                                                                                                                
Was expecting: <STRINGVAL> 

> Fail to deploy VDB with TextTable SELECTOR, ROW DELIMITER, HEADER
> -----------------------------------------------------------------
>
>                 Key: TEIID-4368
>                 URL: https://issues.jboss.org/browse/TEIID-4368
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.7
>            Reporter: Lucie Fabrikova
>            Assignee: Steven Hawkins
>         Attachments: texttabvdb-vdb.xml
>
>
> Server fails to deploy dynamic vdb with models which contain following TextTable parameters: SELECTOR, ROW DELIMITER, HEADER.
> Part of server log:
> 10:24:02,171 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "texttabvdb-vdb.xml" (runtime-name: "texttabvdb-vdb.xml")
> 10:24:02,213 INFO  [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50029 VDB texttab.1 model "model2" metadata is currently being loaded. Start Time: 8/1/16 10:24 AM
> 10:24:02,214 INFO  [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50029 VDB texttab.1 model "model3" metadata is currently being loaded. Start Time: 8/1/16 10:24 AM
> 10:24:02,217 WARN  [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50036 VDB texttab.1 model "model2" metadata failed to load. Reason:TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "COLUMNS col1 string [*]ROW[*] DELIMITER 'X'" at line 7, column 59.
> Was expecting: "escape" | "no" | "selector" | "skip" | "width" | "delimiter" | "quote" | "header" | "," | "(" ...
> 10:24:02,218 WARN  [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50036 VDB texttab.1 model "model3" metadata failed to load. Reason:TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered ") COLUMNS a [*]HEADER[*] 'a' string" at line 7, column 52.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> 10:24:02,219 INFO  [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50029 VDB texttab.1 model "model5" metadata is currently being loaded. Start Time: 8/1/16 10:24 AM
> 10:24:02,222 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50030 VDB texttab.1 model "model5" metadata loaded. End Time: 8/1/16 10:24 AM
> 10:24:02,298 INFO  [org.jboss.as.server] (management-handler-thread - 14) JBAS015865: Replaced deployment "texttabvdb-vdb.xml" with deployment "texttabvdb-vdb.xml"



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)