[JBoss JIRA] (TEIID-3815) Oracle translator - OFFSET function does not work
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3815?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3815:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1279460|https://bugzilla.redhat.com/show_bug.cgi?id=1279460] from ASSIGNED to ON_QA
> Oracle translator - OFFSET function does not work
> -------------------------------------------------
>
> Key: TEIID-3815
> URL: https://issues.jboss.org/browse/TEIID-3815
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.2.6_2
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 9.0, 8.12.5, 8.13.6
>
>
> Oracle translator translates OFFSET function as:
> {code:sql}
> SELECT c_0 FROM (SELECT VIEW_FOR_LIMIT.*, ROWNUM ROWNUM_ FROM (***Query***) VIEW_FOR_LIMIT WHERE ROWNUM <= -2147483604) WHERE ROWNUM_ > 45
> {code}
> This always returns an empty result because of *ROWNUM <= -2147483604*.
> Example:
> Query:
> {code:sql}
> SELECT INTKEY FROM bqt1.smalla ORDER BY INTKEY OFFSET 45 ROWS
> {code}
> Source-specific command:
> {code:sql}
> SELECT c_0 FROM (SELECT VIEW_FOR_LIMIT.*, ROWNUM ROWNUM_ FROM (SELECT trunc(g_0."INTKEY") AS c_0 FROM "DV"."SMALLA" g_0 ORDER BY c_0) VIEW_FOR_LIMIT WHERE ROWNUM <= -2147483604) WHERE ROWNUM_ > 45
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 8 months
[JBoss JIRA] (TEIID-4235) dynamic sql recursion check not valid after caught exception
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-4235?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-4235:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1341654|https://bugzilla.redhat.com/show_bug.cgi?id=1341654] from NEW to ON_QA
> dynamic sql recursion check not valid after caught exception
> ------------------------------------------------------------
>
> Key: TEIID-4235
> URL: https://issues.jboss.org/browse/TEIID-4235
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.7
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.5
>
>
> With a procedure like:
> begin
> execute immediate
> exception e
> ...
> execute immediate ...
> An exception on the second execute immediate will be seen like:
> org.teiid.api.exception.query.QueryProcessingException: TEIID30168 Couldn't execute the dynamic SQL command "EXECUTE IMMEDIATE ..." due to: TEIID30347 There is a recursive invocation of group 'proc'. Please correct the SQL.
> Even when the dynamic sql does not re-invoke the proc. The issue is that when catching the initial exception thrown doesn't clear the entry from the recursion stack.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 8 months
[JBoss JIRA] (TEIID-4277) Infinispan Cache DSL translator: materialization incomplete results during view's loading
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4277?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-4277.
---------------------------------
> Infinispan Cache DSL translator: materialization incomplete results during view's loading
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-4277
> URL: https://issues.jboss.org/browse/TEIID-4277
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 9.x, 8.12.5
> Reporter: Jan Stastny
> Assignee: Van Halbert
> Priority: Blocker
> Fix For: 9.1, 8.12.5
>
> Attachments: test.log
>
>
> When user tries to query materialized view in a moment when its loading is in progress, incomplete results are returned. The status of the view in corresponding status table is LOADING.
> Vdb used:
> {code:xml}
> <?xml version="1.0" encoding="UTF-8"?>
> <vdb name="jdg-remote" version="1">
> <description>For testing of materialized views</description>
> <property name ="lib" value ="org.jboss.qe.jdg.pojos"></property>
> <model name="jdgSource">
> <source name="jdgSource" translator-name="jdg-override"
> connection-jndi-name="java:/jdg-mat-ds" />
> <metadata type="DDL"><![CDATA[
> CREATE FOREIGN TABLE CustomerReport(
> customerId integer not null OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'int'),
> totalAmount integer,
> CONSTRAINT PK_ID PRIMARY KEY(customerId)
> ) OPTIONS (NAMEINSOURCE '${db.table.prefix}jdg-mat', UPDATABLE TRUE);]]>
> </metadata>
> </model>
> <model name="h2Source">
> <source name="h2Source" translator-name="h2" connection-jndi-name="java:/h2-ds" />
> </model>
> <model name="View" type="VIRTUAL">
> <metadata type="DDL"><![CDATA[
> CREATE VIEW external_long_ttl (
> customerId integer NOT NULL,
> totalAmount integer
> ) OPTIONS (MATERIALIZED 'TRUE',
> MATERIALIZED_TABLE 'jdgSource.CustomerReport',
> "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true',
> "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO jdgSource.CustomerReport(customerId,totalAmount) SELECT c.id AS customerId, CONVERT(SUM(o.amount),integer) AS totalAmount FROM DV_MATVIEWS_CUSTOMERS c INNER JOIN DV_MATVIEWS_ORDERS o ON c.id = o.customer_id GROUP BY c.id;',
> "teiid_rel:MATVIEW_STATUS_TABLE" 'h2Source.DB.PUBLIC.DV_MATVIEWS_STATUSTABLE',
> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute jdgSource.native(''truncate cache'');',
> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute jdgSource.native(''swap cache names'');',
> "teiid_rel:MATVIEW_ONERROR_ACTION" 'WAIT',
> "teiid_rel:MATVIEW_TTL" 10000
> )
> AS SELECT c.id AS customerId, CONVERT(SUM(o.amount),integer) AS totalAmount FROM DV_MATVIEWS_CUSTOMERS c INNER JOIN DV_MATVIEWS_ORDERS o ON c.id = o.customer_id GROUP BY c.id;
> ]]>
> </metadata>
> </model>
> <translator name="jdg-override" type="infinispan-cache-dsl">
> <property name="SupportsDirectQueryProcedure" value="true" />
> </translator>
> </vdb>
> {code}
> Resource-adapter used:
> {code:xml}
> <resource-adapter id="jdg-mat">
> <module slot="main" id="org.jboss.teiid.resource-adapter.infinispan.dsl"/>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.infinispan.dsl.InfinispanManagedConnectionFactory" jndi-name="java:/jdg-mat-ds" enabled="true" pool-name="jdg-mat">
> <config-property name="ProtobufDefinitionFile">
> /org/jboss/qe/jdg/remote/protobuf/CustomerReport.proto
> </config-property>
> <config-property name="AliasCacheName">
> ${db.table.prefix}jdg-alias
> </config-property>
> <config-property name="MessageMarshallers">
> org.jboss.qe.jdg.pojo.CustomerReport:org.jboss.qe.jdg.remote.marshaller.CustomerReportMarshaller
> </config-property>
> <config-property name="RemoteServerList">
> [remote-server-address]:11322
> </config-property>
> <config-property name="StagingCacheName">
> ${db.table.prefix}jdg-mat-stage
> </config-property>
> <config-property name="CacheTypeMap">
> ${db.table.prefix}jdg-mat:org.jboss.qe.jdg.pojo.CustomerReport;customerId
> </config-property>
> <config-property name="MessageDescriptor">
> org.jboss.qe.jdg.remote.protobuf.CustomerReport
> </config-property>
> <config-property name="Module">
> org.jboss.qe.jdg.pojos
> </config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> {code}
> Datasource used (tables that the view queries):
> {code:xml}
> <xa-datasource jndi-name="java:/h2-ds" pool-name="h2-xa-ds" enabled="true">
> <xa-datasource-property name="URL">
> jdbc:h2:tcp://localhost:9292/db;TRACE_LEVEL_FILE=4
> </xa-datasource-property>
> <driver>h2</driver>
> <security>
> <user-name>sa</user-name>
> </security>
> </xa-datasource>
> {code}
> Query invoked to check current contents of materialized view:
> {code:sql}
> SELECT COUNT(*) FROM external_long_ttl;
> {code}
> And expected result is the same as count of DV_MATVIEWS_CUSTOMERS table from source h2Source. In my case 10.
> But when I print out the result I get all numbers from 0 to 10 . See attached log output (search for 'check-count:')
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 8 months
[JBoss JIRA] (TEIID-4367) Fail to deploy VDB with TextTable SELECTOR
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4367?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4367:
----------------------------------
Fix Version/s: 9.1
Affects Version/s: 8.7
(was: 8.12)
> Fail to deploy VDB with TextTable SELECTOR
> ------------------------------------------
>
> Key: TEIID-4367
> URL: https://issues.jboss.org/browse/TEIID-4367
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7
> Reporter: Lucie Fabrikova
> Assignee: Steven Hawkins
> Fix For: 9.1
>
> Attachments: texttabvdb-vdb.xml
>
>
> Server fails to deploy dynamic vdb with models which contain following TextTable parameter: SELECTOR.
> Server log:
> 14:50:56,219 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50030 VDB texttab.1 model "model5" metadata loaded. End Time: 8/1/16 2:50 PM
> 14:50:56,220 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50030 VDB texttab.1 model "model3" metadata loaded. End Time: 8/1/16 2:50 PM
> 14:50:56,227 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>
> 14:50:56,228 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40073 The metadata for the VDB texttab.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.
> 14:50:56,228 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 2) TEIID40003 VDB texttab.1 is set to FAILED
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 8 months
[JBoss JIRA] (TEIID-4371) Fail to deploy VDB with TextTable SELECTOR
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4371?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4371.
-----------------------------------
Resolution: Duplicate Issue
Duplicate of TEIID-4367 - the difference in later versions is that the error logging is improved.
> Fail to deploy VDB with TextTable SELECTOR
> ------------------------------------------
>
> Key: TEIID-4371
> URL: https://issues.jboss.org/browse/TEIID-4371
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7
> Reporter: Lucie Fabrikova
> Assignee: Steven Hawkins
> Attachments: texttabvdb-vdb.xml
>
>
> 16:12:07,481 INFO [org.jboss.as.server.deployment] (MSC service thread 1-4) JBAS015876: Starting deployment of "texttabvdb-vdb.xml" (runtime-name: "texttabvdb-vdb.xml")
> 16:12:07,509 ERROR [stderr] (MSC service thread 1-3) ScriptEngineManager providers.next(): javax.script.ScriptEngineFactory: Provider com.sun.script.javascript.RhinoScriptEngineFactory not found
> 16:12:07,513 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50029 VDB texttab.1 model "model5" metadata is currently being loaded. Start Time: 8/8/16 4:12 PM
> 16:12:07,514 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50030 VDB texttab.1 model "model5" metadata loaded. End Time: 8/8/16 4:12 PM
> 16:12:07,517 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 4) TEIID31080 model5.v3 validation error: TEIID30065 Error parsing query plan transformation for model5.v3
> 16:12:07,517 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID40073 The metadata for the VDB texttab.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.
> 16:12:07,518 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID40003 VDB texttab.1 is set to FAILED
> 16:12:07,612 INFO [org.jboss.as.server] (management-handler-thread - 10) JBAS015865: Replaced deployment "texttabvdb-vdb.xml" with deployment "texttabvdb-vdb.xml"
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 8 months
[JBoss JIRA] (TEIID-4368) Fail to deploy VDB with TextTable SELECTOR, ROW DELIMITER, HEADER
by Lucie Fabrikova (JIRA)
[ https://issues.jboss.org/browse/TEIID-4368?page=com.atlassian.jira.plugin... ]
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)
9 years, 8 months
[JBoss JIRA] (TEIID-4368) Fail to deploy VDB with TextTable SELECTOR, ROW DELIMITER, HEADER
by Lucie Fabrikova (JIRA)
[ https://issues.jboss.org/browse/TEIID-4368?page=com.atlassian.jira.plugin... ]
Lucie Fabrikova commented on TEIID-4368:
----------------------------------------
Of course. I created 2 jiras - [TEIID-4367] (teiid 8.12) and TEIID-4371 (teiid 8.7)
> 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)
9 years, 8 months
[JBoss JIRA] (TEIID-4371) Fail to deploy VDB with TextTable SELECTOR
by Lucie Fabrikova (JIRA)
Lucie Fabrikova created TEIID-4371:
--------------------------------------
Summary: Fail to deploy VDB with TextTable SELECTOR
Key: TEIID-4371
URL: https://issues.jboss.org/browse/TEIID-4371
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7
Reporter: Lucie Fabrikova
Assignee: Steven Hawkins
Attachments: texttabvdb-vdb.xml
16:12:07,481 INFO [org.jboss.as.server.deployment] (MSC service thread 1-4) JBAS015876: Starting deployment of "texttabvdb-vdb.xml" (runtime-name: "texttabvdb-vdb.xml")
16:12:07,509 ERROR [stderr] (MSC service thread 1-3) ScriptEngineManager providers.next(): javax.script.ScriptEngineFactory: Provider com.sun.script.javascript.RhinoScriptEngineFactory not found
16:12:07,513 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50029 VDB texttab.1 model "model5" metadata is currently being loaded. Start Time: 8/8/16 4:12 PM
16:12:07,514 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50030 VDB texttab.1 model "model5" metadata loaded. End Time: 8/8/16 4:12 PM
16:12:07,517 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 4) TEIID31080 model5.v3 validation error: TEIID30065 Error parsing query plan transformation for model5.v3
16:12:07,517 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID40073 The metadata for the VDB texttab.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.
16:12:07,518 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID40003 VDB texttab.1 is set to FAILED
16:12:07,612 INFO [org.jboss.as.server] (management-handler-thread - 10) JBAS015865: Replaced deployment "texttabvdb-vdb.xml" with deployment "texttabvdb-vdb.xml"
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 8 months
[JBoss JIRA] (TEIID-4368) Fail to deploy VDB with TextTable SELECTOR, ROW DELIMITER, HEADER
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4368?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4368:
---------------------------------------
That indicates an issue with the SQL string logic - it's outputting the parsed value as an identifier and it should be a string. Could that be logged as a new issue as this one could be confusing to look at later?
> 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)
9 years, 8 months
[JBoss JIRA] (TEIID-4368) Fail to deploy VDB with TextTable SELECTOR, ROW DELIMITER, HEADER
by Lucie Fabrikova (JIRA)
[ https://issues.jboss.org/browse/TEIID-4368?page=com.atlassian.jira.plugin... ]
Lucie Fabrikova commented on TEIID-4368:
----------------------------------------
But in the model there is 'a'...
> 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)
9 years, 8 months