[JBoss JIRA] (TEIIDDES-2381) Error with virtual procedure inserting into global temporary table
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2381?page=com.atlassian.jira.plu... ]
Matej Kralik closed TEIIDDES-2381.
----------------------------------
> Error with virtual procedure inserting into global temporary table
> ------------------------------------------------------------------
>
> Key: TEIIDDES-2381
> URL: https://issues.jboss.org/browse/TEIIDDES-2381
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations
> Affects Versions: 8.6
> Reporter: Jan Stastny
>
> I have a view model (called IPView) with global temporary table (called global_temp_table), then I have virtual procedure in the same model where I try to insert data into the global temporary table. When the Transformation Editor's content is saved, it displays an error under the editor's text area. The error has following message:
> ERROR: TEIID30065 Error parsing query plan transformation for IPView.global_temp_table
> This error does not give the user any hint what went wrong (what he did wrong).
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 4 months
[JBoss JIRA] (TEIIDDES-3054) "Intialisation [sic] produced an exception" typo
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3054?page=com.atlassian.jira.plu... ]
Matej Kralik closed TEIIDDES-3054.
----------------------------------
> "Intialisation [sic] produced an exception" typo
> ------------------------------------------------
>
> Key: TEIIDDES-3054
> URL: https://issues.jboss.org/browse/TEIIDDES-3054
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.1, 10.1
> Environment: Windows 7, 64-bit
> JBoss Developer Studio 10.2.0.GA
> JBoss Data Virt Development (Teiid Designer) Integration Stack 10.1.0.GA
>
> Reporter: Steve Tran
> Assignee: Barry LaFond
> Priority: Minor
>
> There's a typo with the error message. "Intialisation" should be "Initialization" Here's where it's at.
> [stran@stran teiid-designer]$ grep intialisation . -R
> ./plugins/org.teiid.designer.dqp/src/org/teiid/designer/runtime/i18n.propertiesTeiidParentServerListener.initTeiidServerException.reason = The intialisation produced an exception, which can occur due to incorrect security credentials. Please review the exception messages by clicking the Details button.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 4 months
[JBoss JIRA] (TEIIDDES-2688) Dynamic VDB Generation - Problem with DDL generated for procedure
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2688?page=com.atlassian.jira.plu... ]
Matej Kralik closed TEIIDDES-2688.
----------------------------------
> Dynamic VDB Generation - Problem with DDL generated for procedure
> -----------------------------------------------------------------
>
> Key: TEIIDDES-2688
> URL: https://issues.jboss.org/browse/TEIIDDES-2688
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.4
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Fix For: 9.2
>
>
> I have a VDB that was created for consumption of REST Web Service.
> There is a procedure named getProgrammes(). DDL generated for dynamic VDB is:
> {quote}
> CREATE VIRTUAL PROCEDURE getProgrammes ()
> AS
> CREATE VIRTUAL PROCEDURE
> BEGIN
> DECLARE STRING VARIABLES.qp = '';
> SELECT
> A.pid AS pid, A."start" AS "start", A."end" AS "end", A.title AS title
> FROM
> (EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE')) AS f, XMLTABLE('/schedule' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS pid string PATH 'day/broadcasts/broadcast/pid/text()', "start" string PATH 'day/broadcasts/broadcast/start/text()', "end" string PATH 'day/broadcasts/broadcast/end/text()', title string PATH 'day/broadcasts/broadcast/programme/title/text()') AS A;
> END;
> {quote}
> Obviously, there is one extra "CREATE VIRTUAL PROCEDURE".
> Even after fixing this issue there is another error:
> {quote}
> VDB: REST State: INACTIVE ERROR: TEIID31080 ViewModel.getProgrammes validation error: TEIID31118 Element "f.result" is not defined by any relevant group. ERROR: TEIID31080 ViewModel.getProgrammes1 validation error: TEIID31118 Element "f.result" is not defined by any relevant group. Models: SourceModel ViewModel
> {quote}
> "f" should be a refrence to "EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE'))" as descibed in the SQL
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 4 months
[JBoss JIRA] (TEIIDDES-2713) UDF jar not referenced in exported dynamic VDB
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2713?page=com.atlassian.jira.plu... ]
Matej Kralik closed TEIIDDES-2713.
----------------------------------
> UDF jar not referenced in exported dynamic VDB
> ----------------------------------------------
>
> Key: TEIIDDES-2713
> URL: https://issues.jboss.org/browse/TEIIDDES-2713
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export, Patch Release, VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Fix For: 11.1.2
>
>
> When exporting a VDB with a User Defined Function, the information about the UDF jar is not present in the resulting dynamic VDB file.
> With regular VDB archives, the UDF jar is added to the lib/ directory within the archive and is referenced like so in META-INF/vdb.xml:
> {code:xml}
> <entry path="/lib/MyTestUdf-1.0-SNAPSHOT.jar">
> <property name="checksum" value="2689317444"/>
> </entry>
> {code}
> This approach is not possible in case of dynamic VDB defined only as an xml file. It is, however, possible to create a module on the server with UDF jar and then reference it in the *-vdb.xml like so:
> {code:xml}
> <property name ="lib" value ="mytestudf-module"></property>
> {code}
> It is currently possible to define such property manually in the VDB editor before exporting, but Designer should be able to define one automatically, or at least warn the user when there is a UDF jar present and the lib property is not defined.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 4 months