[JBoss JIRA] (TEIIDDES-2110) Update 8.5 Documentation
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2110?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2110.
------------------------------------
Resolution: Done
Done
> Update 8.5 Documentation
> ------------------------
>
> Key: TEIIDDES-2110
> URL: https://issues.jboss.org/browse/TEIIDDES-2110
> Project: Teiid Designer
> Issue Type: Task
> Security Level: Public(Everyone can see)
> Components: Documentation
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 8.5
>
>
> Update docs for these JIRA
> * TEIIDDES-433 - Request ability to select which tables you want "Update Data Source Statistics" to update >>> *new verbage and maybe screen cap*
> * TEIIDDES-1257 - When in transformation editor, enable the ability to right click on an invalid function and create it >>> *show context action and dialog*
> * TEIIDDES-1875 - Add ability to View a Built-In MED >>> *screen caps of menu/action/toolbar*
> * TEIIDDES-1984 - Enhance security for data roles UI >> *New screen cap for data role editor dialog*
> * TEIIDDES-2027 - Additional gui security support >> *New Vdb Editor properties editor screen cap*
> * TEIIDDES-2033 - Need to provide all system functions (i.e, aggregates) that user can use >> *document availability of system functions in Function Builder wizard*
> * TEIIDDES-2069 - Improve Default Server naming and make it consistent >>> *verbage and screen caps containing the Default Server section*
> * TEIIDDES-2093 - Populate the "import" properties defined for translator >>> *new screen cap of Import Properties page*
> * TEIIDDES-2094 - Support for dynamic extension metadata >>> *additional built-in MEDs from applicable Translators*
> * TEIIDDES-2098 - Add basic new project/model/vdb actions to the Model Explorer Toolbar >>> *Model Explorer toolbar screencap & documentation*
> * TEIIDDES-2100 - Add ability to migrate older models containing table names with "." characters >>> *new action/dialogs/quick-fixes*
> * TEIIDDES-2108 - Edit Translator Overrides action (TEIIDDES-1251)
> * TEIIDDES-2109 - New *Connection* sub-menu
> * TEIIDDES-2138 - Restrict "New VDB" wizard's "Add model" to the current project >>> *New work-flow limitations* Include work for TEIIDDES-2120 & TEIIDDES-2168
> * TEIIDDES-2142 - 'New VDB Data Role' Dialog needs layout improvement >>> *new screen caps*
> * TEIIDDES-2149 - Simplify VDB Editor layout
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months
[JBoss JIRA] (TEIIDDES-2110) Update 8.5 Documentation
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2110?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2110:
-----------------------------------
Description:
Update docs for these JIRA
* TEIIDDES-433 - Request ability to select which tables you want "Update Data Source Statistics" to update >>> *new verbage and maybe screen cap*
* TEIIDDES-1257 - When in transformation editor, enable the ability to right click on an invalid function and create it >>> *show context action and dialog*
* TEIIDDES-1875 - Add ability to View a Built-In MED >>> *screen caps of menu/action/toolbar*
* TEIIDDES-1984 - Enhance security for data roles UI >> *New screen cap for data role editor dialog*
* TEIIDDES-2027 - Additional gui security support >> *New Vdb Editor properties editor screen cap*
* TEIIDDES-2033 - Need to provide all system functions (i.e, aggregates) that user can use >> *document availability of system functions in Function Builder wizard*
* TEIIDDES-2069 - Improve Default Server naming and make it consistent >>> *verbage and screen caps containing the Default Server section*
* TEIIDDES-2093 - Populate the "import" properties defined for translator >>> *new screen cap of Import Properties page*
* TEIIDDES-2094 - Support for dynamic extension metadata >>> *additional built-in MEDs from applicable Translators*
* TEIIDDES-2098 - Add basic new project/model/vdb actions to the Model Explorer Toolbar >>> *Model Explorer toolbar screencap & documentation*
* TEIIDDES-2108 - Edit Translator Overrides action (TEIIDDES-1251)
* TEIIDDES-2138 - Restrict "New VDB" wizard's "Add model" to the current project >>> *New work-flow limitations* Include work for TEIIDDES-2120 & TEIIDDES-2168
* TEIIDDES-2142 - 'New VDB Data Role' Dialog needs layout improvement >>> *new screen caps*
* TEIIDDES-2149 - Simplify VDB Editor layout
was:
Update docs for these JIRA
* TEIIDDES-433 - Request ability to select which tables you want "Update Data Source Statistics" to update >>> *new verbage and maybe screen cap*
* TEIIDDES-1257 - When in transformation editor, enable the ability to right click on an invalid function and create it >>> *show context action and dialog*
* TEIIDDES-1875 - Add ability to View a Built-In MED >>> *screen caps of menu/action/toolbar*
* TEIIDDES-1984 - Enhance security for data roles UI >> *New screen cap for data role editor dialog*
* TEIIDDES-2027 - Additional gui security support >> *New Vdb Editor properties editor screen cap*
* TEIIDDES-2033 - Need to provide all system functions (i.e, aggregates) that user can use >> *document availability of system functions in Function Builder wizard*
* TEIIDDES-2069 - Improve Default Server naming and make it consistent >>> *verbage and screen caps containing the Default Server section*
* TEIIDDES-2093 - Populate the "import" properties defined for translator >>> *new screen cap of Import Properties page*
* TEIIDDES-2094 - Support for dynamic extension metadata >>> *additional built-in MEDs from applicable Translators*
* TEIIDDES-2098 - Add basic new project/model/vdb actions to the Model Explorer Toolbar >>> *Model Explorer toolbar screencap & documentation*
* TEIIDDES-2100 - Add ability to migrate older models containing table names with "." characters >>> *new action/dialogs/quick-fixes*
* TEIIDDES-2108 - Edit Translator Overrides action (TEIIDDES-1251)
* TEIIDDES-2109 - New *Connection* sub-menu
* TEIIDDES-2138 - Restrict "New VDB" wizard's "Add model" to the current project >>> *New work-flow limitations* Include work for TEIIDDES-2120 & TEIIDDES-2168
* TEIIDDES-2142 - 'New VDB Data Role' Dialog needs layout improvement >>> *new screen caps*
* TEIIDDES-2149 - Simplify VDB Editor layout
> Update 8.5 Documentation
> ------------------------
>
> Key: TEIIDDES-2110
> URL: https://issues.jboss.org/browse/TEIIDDES-2110
> Project: Teiid Designer
> Issue Type: Task
> Security Level: Public(Everyone can see)
> Components: Documentation
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 8.5
>
>
> Update docs for these JIRA
> * TEIIDDES-433 - Request ability to select which tables you want "Update Data Source Statistics" to update >>> *new verbage and maybe screen cap*
> * TEIIDDES-1257 - When in transformation editor, enable the ability to right click on an invalid function and create it >>> *show context action and dialog*
> * TEIIDDES-1875 - Add ability to View a Built-In MED >>> *screen caps of menu/action/toolbar*
> * TEIIDDES-1984 - Enhance security for data roles UI >> *New screen cap for data role editor dialog*
> * TEIIDDES-2027 - Additional gui security support >> *New Vdb Editor properties editor screen cap*
> * TEIIDDES-2033 - Need to provide all system functions (i.e, aggregates) that user can use >> *document availability of system functions in Function Builder wizard*
> * TEIIDDES-2069 - Improve Default Server naming and make it consistent >>> *verbage and screen caps containing the Default Server section*
> * TEIIDDES-2093 - Populate the "import" properties defined for translator >>> *new screen cap of Import Properties page*
> * TEIIDDES-2094 - Support for dynamic extension metadata >>> *additional built-in MEDs from applicable Translators*
> * TEIIDDES-2098 - Add basic new project/model/vdb actions to the Model Explorer Toolbar >>> *Model Explorer toolbar screencap & documentation*
> * TEIIDDES-2108 - Edit Translator Overrides action (TEIIDDES-1251)
> * TEIIDDES-2138 - Restrict "New VDB" wizard's "Add model" to the current project >>> *New work-flow limitations* Include work for TEIIDDES-2120 & TEIIDDES-2168
> * TEIIDDES-2142 - 'New VDB Data Role' Dialog needs layout improvement >>> *new screen caps*
> * TEIIDDES-2149 - Simplify VDB Editor layout
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months
[JBoss JIRA] (TEIIDDES-2100) Add ability to migrate older models containing table names with "." characters
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2100?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2100.
------------------------------------
Fix Version/s: (was: 8.6)
(was: 8.5.1)
Resolution: Out of Date
See TEIIDDES-2205
> Add ability to migrate older models containing table names with "." characters
> ------------------------------------------------------------------------------
>
> Key: TEIIDDES-2100
> URL: https://issues.jboss.org/browse/TEIIDDES-2100
> Project: Teiid Designer
> Issue Type: Feature Request
> Security Level: Public(Everyone can see)
> Components: Transformations, Validation
> Affects Versions: 8.4, 8.3.2
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 8.3.4
>
> Attachments: BarryProducts.zip, DOTNAMESMODELProjectSet.zip
>
>
> DV 6 tooling (Designer 8.3.x) includes error validation to prevent non-quoted names from being defined and used in SQL.
> Designer needs a mechanism/framework to help users globally fix table names containing the "." delimiter.
> Options:
> # Designer feature/action to "fix" a model
> # simple CLI-based app to apply to a model
> Need to investigate our "rename" logic to see if it can handle the cascade effect of changing table name and fixing dependent SQL
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months
[JBoss JIRA] (TEIIDDES-2100) Add ability to migrate older models containing table names with "." characters
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2100?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2100:
----------------------------------------
The requirement that table names could NOT include the '.' delimiter was removed, so this JIRA has become irrelevant. 8.5 release removes the validation error check.
> Add ability to migrate older models containing table names with "." characters
> ------------------------------------------------------------------------------
>
> Key: TEIIDDES-2100
> URL: https://issues.jboss.org/browse/TEIIDDES-2100
> Project: Teiid Designer
> Issue Type: Feature Request
> Security Level: Public(Everyone can see)
> Components: Transformations, Validation
> Affects Versions: 8.4, 8.3.2
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 8.3.4, 8.6, 8.5.1
>
> Attachments: BarryProducts.zip, DOTNAMESMODELProjectSet.zip
>
>
> DV 6 tooling (Designer 8.3.x) includes error validation to prevent non-quoted names from being defined and used in SQL.
> Designer needs a mechanism/framework to help users globally fix table names containing the "." delimiter.
> Options:
> # Designer feature/action to "fix" a model
> # simple CLI-based app to apply to a model
> Need to investigate our "rename" logic to see if it can handle the cascade effect of changing table name and fixing dependent SQL
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months
[JBoss JIRA] (TEIIDDES-2218) JBossWS-CXF/RestEasy WAR menu options are impl specific
by Ramesh Reddy (JIRA)
Ramesh Reddy created TEIIDDES-2218:
--------------------------------------
Summary: JBossWS-CXF/RestEasy WAR menu options are impl specific
Key: TEIIDDES-2218
URL: https://issues.jboss.org/browse/TEIIDDES-2218
Project: Teiid Designer
Issue Type: Quality Risk
Security Level: Public (Everyone can see)
Components: Editors
Reporter: Ramesh Reddy
I never noticed noticed this before, but the menu options as
- Generate JBossWs-CXF War
- Generate RestEasy War
they seem to mention the underlying technologies that Designer uses to implement the WAR files then generic name such as
- Generate SOAP Web Service WAR
- Generate REST Web Service WAR
The users do not care, may not be aware of above underlying technologies, and can create a confusing naming. Usability!
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months
[JBoss JIRA] (TEIIDDES-2214) Cannot generate CXF WAR from VDB created in 8.3.3
by Paul Richardson (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2214?page=com.atlassian.jira.plu... ]
Paul Richardson commented on TEIIDDES-2214:
-------------------------------------------
Fix pushed to 8.5 master branch.
> Cannot generate CXF WAR from VDB created in 8.3.3
> -------------------------------------------------
>
> Key: TEIIDDES-2214
> URL: https://issues.jboss.org/browse/TEIIDDES-2214
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: VDB & Execution, Web Services Support
> Affects Versions: 8.3.3
> Environment: Teiid Designer 8.3.3
> JBDS 7.1.1.GA
> Reporter: Andrej Šmigala
> Assignee: Paul Richardson
> Fix For: 8.3.4
>
> Attachments: CxfTest-8.3.2.zip, CxfTest-8.3.3.zip, log
>
>
> The following error occurs when generating CXF WAR from VDB: "An error occurred while creating WAR file, check log for detail" (log attached).
> This only happens with VDB created in 8.3.3, not if one uses a VDB created in 8.3.2.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months
[JBoss JIRA] (TEIIDDES-2214) Cannot generate CXF WAR from VDB created in 8.3.3
by Paul Richardson (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2214?page=com.atlassian.jira.plu... ]
Paul Richardson reassigned TEIIDDES-2214:
-----------------------------------------
Assignee: Paul Richardson (was: Ted Jones)
> Cannot generate CXF WAR from VDB created in 8.3.3
> -------------------------------------------------
>
> Key: TEIIDDES-2214
> URL: https://issues.jboss.org/browse/TEIIDDES-2214
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: VDB & Execution, Web Services Support
> Affects Versions: 8.3.3
> Environment: Teiid Designer 8.3.3
> JBDS 7.1.1.GA
> Reporter: Andrej Šmigala
> Assignee: Paul Richardson
> Fix For: 8.3.4
>
> Attachments: CxfTest-8.3.2.zip, CxfTest-8.3.3.zip, log
>
>
> The following error occurs when generating CXF WAR from VDB: "An error occurred while creating WAR file, check log for detail" (log attached).
> This only happens with VDB created in 8.3.3, not if one uses a VDB created in 8.3.2.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months
[JBoss JIRA] (TEIIDDES-2217) TEIID30183 Message:TEIID30183 Text parse error: Non-whitespace character found between the qualifier and the delimiter in text line 16, 161 in Unknown. SQLState: TEIID30183
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2217?page=com.atlassian.jira.plu... ]
Steven Hawkins moved TEIID-3004 to TEIIDDES-2217:
-------------------------------------------------
Project: Teiid Designer (was: Teiid)
Key: TEIIDDES-2217 (was: TEIID-3004)
Issue Type: Quality Risk (was: Bug)
Affects Version/s: (was: 8.8)
> TEIID30183 Message:TEIID30183 Text parse error: Non-whitespace character found between the qualifier and the delimiter in text line 16,161 in Unknown. SQLState: TEIID30183
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2217
> URL: https://issues.jboss.org/browse/TEIIDDES-2217
> Project: Teiid Designer
> Issue Type: Quality Risk
> Security Level: Public(Everyone can see)
> Reporter: luca gioppo
> Assignee: Steven Hawkins
> Priority: Minor
>
> On the same use case of TEIID30181 I now got the error in object:
> TEIID30183 Message:TEIID30183 Text parse error: Non-whitespace character found between the qualifier and the delimiter in text line 16,161 in Unknown.
> SQLState: TEIID30183
> the row should be:
> istsc_pgee021002 Direzione Didattica Statale "Franco Rasetti" Castiglione del Lago ANTONIETTA MANNUCCI 06061 PG Umbria www.dirclago.it Via Carducci, 25 Dirigente Scolastico Istituti di Istruzione Statale di Ogni Ordine e Grado Pubbliche Amministrazioni S 80005650546 pgee021002(a)pec.istruzione.it pec pgee021002(a)istruzione.it altro null null null null null null 0
> the only difference I find between the previous rows that passed without problems is that a field has double quote in its content.
> The delimiter is tabulation so there should not be any problem.
> Could it be this the problem and how to solve it?
> Thanks
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months
[JBoss JIRA] (TEIIDDES-2217) TEIID30183 Message:TEIID30183 Text parse error: Non-whitespace character found between the qualifier and the delimiter in text line 16, 161 in Unknown. SQLState: TEIID30183
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2217?page=com.atlassian.jira.plu... ]
Steven Hawkins updated TEIIDDES-2217:
-------------------------------------
Assignee: (was: Steven Hawkins)
Designer may need to detect or indicate when a quote/qualifier is in use.
> TEIID30183 Message:TEIID30183 Text parse error: Non-whitespace character found between the qualifier and the delimiter in text line 16,161 in Unknown. SQLState: TEIID30183
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2217
> URL: https://issues.jboss.org/browse/TEIIDDES-2217
> Project: Teiid Designer
> Issue Type: Quality Risk
> Security Level: Public(Everyone can see)
> Reporter: luca gioppo
> Priority: Minor
>
> On the same use case of TEIID30181 I now got the error in object:
> TEIID30183 Message:TEIID30183 Text parse error: Non-whitespace character found between the qualifier and the delimiter in text line 16,161 in Unknown.
> SQLState: TEIID30183
> the row should be:
> istsc_pgee021002 Direzione Didattica Statale "Franco Rasetti" Castiglione del Lago ANTONIETTA MANNUCCI 06061 PG Umbria www.dirclago.it Via Carducci, 25 Dirigente Scolastico Istituti di Istruzione Statale di Ogni Ordine e Grado Pubbliche Amministrazioni S 80005650546 pgee021002(a)pec.istruzione.it pec pgee021002(a)istruzione.it altro null null null null null null 0
> the only difference I find between the previous rows that passed without problems is that a field has double quote in its content.
> The delimiter is tabulation so there should not be any problem.
> Could it be this the problem and how to solve it?
> Thanks
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months
[JBoss JIRA] (TEIIDDES-2207) Web Service Operation SQL valid in 8.3.2 but invalid in 8.5
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2207?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2207:
-----------------------------------
Fix Version/s: 8.6
8.5.1
(was: 8.5)
> Web Service Operation SQL valid in 8.3.2 but invalid in 8.5
> -----------------------------------------------------------
>
> Key: TEIIDDES-2207
> URL: https://issues.jboss.org/browse/TEIIDDES-2207
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Validation, Web Services Support
> Affects Versions: 8.5
> Reporter: Barry LaFond
> Assignee: Paul Richardson
> Priority: Critical
> Fix For: 8.6, 8.5.1
>
> Attachments: testWebService.zip
>
>
> Compared creating WS from source and view models in 8.3.2 vs 8.5.
> See attached project set
> 1) Created WS from ProductsOracle source and WS operations validated fine in 8.3.2 and 8.5 Designer
> 2) Created WS from PRoductsViews view model and WS operations contained an error.
> Differences in the SQL for 8.5 vs 8.3.2 relate to the removing the CREATE VIRTUAL PROCEDURE in the SQL.
> 8.3.2 SQL
> {code}
> CREATE VIRTUAL PROCEDURE
> BEGIN
> DECLARE string VARIABLES.IN_exampleVar;
> VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');
> SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView;
> END
> {code}
> Same operation validated in 8.5 but results in validation error:
> {code}
> BEGIN
> DECLARE string VARIABLES.IN_exampleVar;
> VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');
> SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView;
> END
> {code}
> ERROR
> {code}
> ERROR: TEIID30070 The function 'xPathValue(null, '//*[local-name()="exampleName"]')' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions.
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months