[JBoss JIRA] (TEIIDDES-3103) Execute VDB in the Guides doesn't work
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3103?page=com.atlassian.jira.plu... ]
Matej Kralik commented on TEIIDDES-3103:
----------------------------------------
[~blafond] yes, execute VDB from Model Explorer or deploy from VDB Editor works but from 'guides view' doesn't.
In the log is only:
{code:java}
!ENTRY org.eclipse.ui 2 2 2017-09-22 10:32:58.216
!MESSAGE org.eclipse.ui.views.ContentOutline: Deprecated relationship "fast" should be converted to "stack".
{code}
and server log doesn't contain any new line after click on execute.
I uploaded the video with the issue.
> Execute VDB in the Guides doesn't work
> --------------------------------------
>
> Key: TEIIDDES-3103
> URL: https://issues.jboss.org/browse/TEIIDDES-3103
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 11.1
> Environment: Fedora 26
> Reporter: Matej Kralik
> Priority: Minor
> Attachments: screenshot.png
>
>
> Last step (execute VDB) in the first guide (Model JDBC Source) doesn't work. After click on the "Execute VDB" shows wizard for choosing VDB (screenshot1). After click OK, VDB is not deployed.
> I noticed that it doesn't work in the other guides as well.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIIDDES-3103) Execute VDB in the Guides doesn't work
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3103?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-3103:
----------------------------------------
[~mkralik] I'm able to run Execute VDB. Can you try running Execute VDB from Model Explorer? Can you attach your .metadata/log file and your server log as well? Thx
> Execute VDB in the Guides doesn't work
> --------------------------------------
>
> Key: TEIIDDES-3103
> URL: https://issues.jboss.org/browse/TEIIDDES-3103
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 11.1
> Environment: Fedora 26
> Reporter: Matej Kralik
> Priority: Minor
> Attachments: screenshot.png
>
>
> Last step (execute VDB) in the first guide (Model JDBC Source) doesn't work. After click on the "Execute VDB" shows wizard for choosing VDB (screenshot1). After click OK, VDB is not deployed.
> I noticed that it doesn't work in the other guides as well.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIIDDES-2962) Add search capabilities to the VDB Definition screens
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2962?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2962:
-----------------------------------
Attachment: (was: JDV_RFE_SEARCH.pdf)
> Add search capabilities to the VDB Definition screens
> -----------------------------------------------------
>
> Key: TEIIDDES-2962
> URL: https://issues.jboss.org/browse/TEIIDDES-2962
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: VDB & Execution
> Reporter: Debbie Steigner
> Assignee: Barry LaFond
> Priority: Minor
> Fix For: 11.2
>
>
> To improve JDV Designer productivity, we would like to request an implementation of the following points regarding the VDB configuration panel (see page 2 attachment JDV_RFE_navigation.pdf):
> - Full Text Search, enabling to search entities "starts with", "contains", or "end with".
> - Filter by Type: ALL, View, VBL, DataSource (select the types of entities i want to search into).
> - Clear Search Fields: Clear all of the above.
> - Order By Name: ASC, DESC. Order by name all the entities, and make click-able the Name Header bar to change ascending and descending ordering.
> The same improvements could be introduced in the Data Roles permissions panes (see page 4 attachment JDV_RFE_navigation.pdf).
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIIDDES-3109) The Exported DDL show the DDL if for Oracle 8.1.6
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3109?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-3109:
-----------------------------------
Fix Version/s: 11.2
> The Exported DDL show the DDL if for Oracle 8.1.6
> -------------------------------------------------
>
> Key: TEIIDDES-3109
> URL: https://issues.jboss.org/browse/TEIIDDES-3109
> Project: Teiid Designer
> Issue Type: Quality Risk
> Environment: JBDS 10.4 under JDV 6.3
> Reporter: Kylin Soong
> Fix For: 11.2
>
>
> Once export the DDL, the file shows the DDL is for Oracle 8
> {code}
> - Build Script
> -- RDBMS : Oracle 8.1.6
> -- Generated With :
> -- Generated On : 2017-09-18 10:55:51
> -- Generation Options
> -- Generate Drop Statements : false
> -- Convert Table Descriptions to COMMENT ON Statements : true
> -- Convert Column Descriptions to COMMENT ON Statements : true
> --
> -- Uncomment the following line for use of the logging facility (see last line also)
> --spool .log
> -- ----------------------------------------------------------------------------------------------------------------
> -- Generate From
> -- Model : /PetroChinaTest/FederatedDataLayer/A1_EPDM_FBL.xmi
> -- Model Type : Virtual
> -- Metamodel : relational (http://www.metamatrix.com/metamodels/Relational)
> -- Model UUID : mmuuid:d614916d-8573-47b1-933f-78d183716404
> -- ----------------------------------------------------------------------------------------------------------------
> -- (generated from CD_ACTIVITY)
> CREATE TABLE CD_ACTIVITY
> (
> ACTIVITY_ID VARCHAR2(32) NOT NULL,
> PARENT_ID VARCHAR2(32),
> {code}
> Customer are confused whether this DDL is fine for exec against Oracle 11
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIIDDES-3109) The Exported DDL show the DDL if for Oracle 8.1.6
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3109?page=com.atlassian.jira.plu... ]
Kylin Soong commented on TEIIDDES-3109:
---------------------------------------
The External Materialization docs hint export DDL and executed to a database used as Mat target table.
> The Exported DDL show the DDL if for Oracle 8.1.6
> -------------------------------------------------
>
> Key: TEIIDDES-3109
> URL: https://issues.jboss.org/browse/TEIIDDES-3109
> Project: Teiid Designer
> Issue Type: Quality Risk
> Environment: JBDS 10.4 under JDV 6.3
> Reporter: Kylin Soong
>
> Once export the DDL, the file shows the DDL is for Oracle 8
> {code}
> - Build Script
> -- RDBMS : Oracle 8.1.6
> -- Generated With :
> -- Generated On : 2017-09-18 10:55:51
> -- Generation Options
> -- Generate Drop Statements : false
> -- Convert Table Descriptions to COMMENT ON Statements : true
> -- Convert Column Descriptions to COMMENT ON Statements : true
> --
> -- Uncomment the following line for use of the logging facility (see last line also)
> --spool .log
> -- ----------------------------------------------------------------------------------------------------------------
> -- Generate From
> -- Model : /PetroChinaTest/FederatedDataLayer/A1_EPDM_FBL.xmi
> -- Model Type : Virtual
> -- Metamodel : relational (http://www.metamatrix.com/metamodels/Relational)
> -- Model UUID : mmuuid:d614916d-8573-47b1-933f-78d183716404
> -- ----------------------------------------------------------------------------------------------------------------
> -- (generated from CD_ACTIVITY)
> CREATE TABLE CD_ACTIVITY
> (
> ACTIVITY_ID VARCHAR2(32) NOT NULL,
> PARENT_ID VARCHAR2(32),
> {code}
> Customer are confused whether this DDL is fine for exec against Oracle 11
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIIDDES-3110) Can not define Mat management options in JBDS
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3110?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-3110:
----------------------------------------
Reference for Materialization: https://teiid.gitbooks.io/documents/content/v/9.3.x/caching/External_Mate...
In Designer:
* teiid_rel:MATVIEW_TTL >> relational:Time to Live
* teiid_rel:ALLOW_MATVIEW_MANAGEMENT >> relational: Allow Teiid based management
* teiid_rel:MATVIEW_PREFER_MEMEORY >> ( *not a valid extension property* )
* teiid_rel:MATVIEW_UPDATABLE >> *is not an materialization extension property* but covered by the view's standard *Supports Update* property
* teiid_rel:MATVIEW_SCOPE" 'VDB' >> relational: Materialized Share Scope
> Can not define Mat management options in JBDS
> ---------------------------------------------
>
> Key: TEIIDDES-3110
> URL: https://issues.jboss.org/browse/TEIIDDES-3110
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Views
> Reporter: Kylin Soong
>
> If add some more options to further fine-grained contain Mat View management as below:
> {code}
> "teiid_rel:MATVIEW_TTL" 3600000,
> "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true',
> "teiid_rel:MATVIEW_PREFER_MEMEORY" 'true',
> "teiid_rel:MATVIEW_UPDATABLE" 'true',
> "teiid_rel:MATVIEW_SCOPE" 'VDB'
> {code}
> There is not possible to do this in JBDS
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIIDDES-3110) Can not define Mat management options in JBDS
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3110?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-3110.
------------------------------------
Resolution: Rejected
These properties are supported in Designer except for the one invalid property.
> Can not define Mat management options in JBDS
> ---------------------------------------------
>
> Key: TEIIDDES-3110
> URL: https://issues.jboss.org/browse/TEIIDDES-3110
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Views
> Reporter: Kylin Soong
>
> If add some more options to further fine-grained contain Mat View management as below:
> {code}
> "teiid_rel:MATVIEW_TTL" 3600000,
> "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true',
> "teiid_rel:MATVIEW_PREFER_MEMEORY" 'true',
> "teiid_rel:MATVIEW_UPDATABLE" 'true',
> "teiid_rel:MATVIEW_SCOPE" 'VDB'
> {code}
> There is not possible to do this in JBDS
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIIDDES-3110) Can not define Mat management options in JBDS
by Kylin Soong (JIRA)
Kylin Soong created TEIIDDES-3110:
-------------------------------------
Summary: Can not define Mat management options in JBDS
Key: TEIIDDES-3110
URL: https://issues.jboss.org/browse/TEIIDDES-3110
Project: Teiid Designer
Issue Type: Feature Request
Components: Views
Reporter: Kylin Soong
If add some more options to further fine-grained contain Mat View management as below:
{code}
"teiid_rel:MATVIEW_TTL" 3600000,
"teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true',
"teiid_rel:MATVIEW_PREFER_MEMEORY" 'true',
"teiid_rel:MATVIEW_UPDATABLE" 'true',
"teiid_rel:MATVIEW_SCOPE" 'VDB'
{code}
There is not possible to do this in JBDS
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIIDDES-3109) The Exported DDL show the DDL if for Oracle 8.1.6
by Kylin Soong (JIRA)
Kylin Soong created TEIIDDES-3109:
-------------------------------------
Summary: The Exported DDL show the DDL if for Oracle 8.1.6
Key: TEIIDDES-3109
URL: https://issues.jboss.org/browse/TEIIDDES-3109
Project: Teiid Designer
Issue Type: Quality Risk
Environment: JBDS 10.4 under JDV 6.3
Reporter: Kylin Soong
Once export the DDL, the file shows the DDL is for Oracle 8
{code}
- Build Script
-- RDBMS : Oracle 8.1.6
-- Generated With :
-- Generated On : 2017-09-18 10:55:51
-- Generation Options
-- Generate Drop Statements : false
-- Convert Table Descriptions to COMMENT ON Statements : true
-- Convert Column Descriptions to COMMENT ON Statements : true
--
-- Uncomment the following line for use of the logging facility (see last line also)
--spool .log
-- ----------------------------------------------------------------------------------------------------------------
-- Generate From
-- Model : /PetroChinaTest/FederatedDataLayer/A1_EPDM_FBL.xmi
-- Model Type : Virtual
-- Metamodel : relational (http://www.metamatrix.com/metamodels/Relational)
-- Model UUID : mmuuid:d614916d-8573-47b1-933f-78d183716404
-- ----------------------------------------------------------------------------------------------------------------
-- (generated from CD_ACTIVITY)
CREATE TABLE CD_ACTIVITY
(
ACTIVITY_ID VARCHAR2(32) NOT NULL,
PARENT_ID VARCHAR2(32),
{code}
Customer are confused whether this DDL is fine for exec against Oracle 11
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months