[JBoss JIRA] (TEIIDDES-2264) Problem Saving view model: outer scope rule issue
by Johnathon Lee (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2264?page=com.atlassian.jira.plu... ]
Johnathon Lee updated TEIIDDES-2264:
------------------------------------
> Problem Saving view model: outer scope rule issue
> -------------------------------------------------
>
> Key: TEIIDDES-2264
> URL: https://issues.jboss.org/browse/TEIIDDES-2264
> Project: Teiid Designer
> Issue Type: Bug
> Components: Teiid Integration
> Affects Versions: 8.5
> Reporter: Tom Johnston
>
> While trying to figure out what corrupted my workspace I have done the following:
> Cloned my project.
> figured out the likely model containing the problem
> one by one copied off the transformations
> deleted the table that I felt was the issue.
> Saved
> I got this message upon saving:
> Problem occured:
> Attempted to beginRule: F/August/views, does not match outer scope rule: L/August/views/metadataStuff.xmi
> Attempted to beginRule: F/August/views, does not match outer scope rule: L/August/views/metadataStuff.xmi
> This is the stacktrace:
> java.lang.IllegalArgumentException: Attempted to beginRule: F/August/views, does not match outer scope rule: L/August/views/metadataStuff.xmi
> at org.eclipse.core.runtime.Assert.isLegal(Assert.java:63)
> at org.eclipse.core.internal.jobs.ThreadJob.illegalPush(ThreadJob.java:134)
> at org.eclipse.core.internal.jobs.ThreadJob.push(ThreadJob.java:333)
> at org.eclipse.core.internal.jobs.ImplicitJobs.begin(ImplicitJobs.java:85)
> at org.eclipse.core.internal.jobs.JobManager.beginRule(JobManager.java:286)
> at org.eclipse.core.internal.resources.WorkManager.checkIn(WorkManager.java:118)
> at org.eclipse.core.internal.resources.Workspace.prepareOperation(Workspace.java:2283)
> at org.eclipse.core.internal.resources.Resource.refreshLocal(Resource.java:1691)
> at org.eclipse.core.internal.resources.File.refreshLocal(File.java:333)
> at org.teiid.designer.core.workspace.ModelBufferImpl.save(ModelBufferImpl.java:509)
> at org.teiid.designer.core.workspace.OpenableImpl.save(OpenableImpl.java:319)
> at org.teiid.designer.core.workspace.ModelResourceImpl.save(ModelResourceImpl.java:1013)
> at org.teiid.designer.ui.viewsupport.ModelUtilities.saveModelResource(ModelUtilities.java:1750)
> at org.teiid.designer.ui.editors.ModelEditor$1.runInWorkspace(ModelEditor.java:416)
> at org.eclipse.core.internal.resources.InternalWorkspaceJob.run(InternalWorkspaceJob.java:38)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2688) Dynamic VDB Generation - Problem with DDL generated for procedure
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2688?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2688:
----------------------------------------
The Dyn. VDB generator had assumed that CREATE VIRTUAL PROCEDURE XXXXX was *NOT* in the SQL. This was a change in Teiid awhile back. So some *older* VDBs may still have the *old* SQL statement which would result in the generated DDL in your description.
My fix was to look at the SQL first, then strip off the CREATE VIRTUAL PROCEDURE from the T-form's SQL string first before appending the SQL to the string builder.
> 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
(v6.4.11#64026)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2688) Dynamic VDB Generation - Problem with DDL generated for procedure
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2688?page=com.atlassian.jira.plu... ]
Matus Makovy commented on TEIIDDES-2688:
----------------------------------------
The SQL in the view model doesn't include CREATE VIRTUAL PROCEDURE.
> 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
(v6.4.11#64026)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2693) Allow warnings to be presented to the user when importing from JDBC
by Andrej Šmigala (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2693?page=com.atlassian.jira.plu... ]
Andrej Šmigala updated TEIIDDES-2693:
-------------------------------------
Description:
This came up when resolving TEIIDDES-2458. The fix attempts to get the correct name in source for the sybase tables, but there's a possibility this will fail. We still want to finish the import, but we'd also like to warn the user the NIS might be incorrect.
See the comment in this PR: https://github.com/Teiid-Designer/teiid-designer/pull/516
<blafond> asmigala: oops. missed it. Since this warning would probably occur on multiple tables/columns it wouldn't be good to pop up a dialog during the processing.
<blafond> asmigala: If we added an IStatus[] to RelationalModelProcessorImpl, we could check it's Severity and throw up a Warning/Error summary dialog after processing?
was:
This came up when resolving TEIIDDES-2458. The fix attempts to get the correct name in source for the sybase tables, but there's a possibility this will fail. We still want to finish the import, but we'd also like to warn the user the NIS might be incorrect.
See the comment this PR: https://github.com/Teiid-Designer/teiid-designer/pull/516
<blafond> asmigala: oops. missed it. Since this warning would probably occur on multiple tables/columns it wouldn't be good to pop up a dialog during the processing.
<blafond> asmigala: If we added an IStatus[] to RelationalModelProcessorImpl, we could check it's Severity and throw up a Warning/Error summary dialog after processing?
> Allow warnings to be presented to the user when importing from JDBC
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2693
> URL: https://issues.jboss.org/browse/TEIIDDES-2693
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Andrej Šmigala
>
> This came up when resolving TEIIDDES-2458. The fix attempts to get the correct name in source for the sybase tables, but there's a possibility this will fail. We still want to finish the import, but we'd also like to warn the user the NIS might be incorrect.
> See the comment in this PR: https://github.com/Teiid-Designer/teiid-designer/pull/516
> <blafond> asmigala: oops. missed it. Since this warning would probably occur on multiple tables/columns it wouldn't be good to pop up a dialog during the processing.
> <blafond> asmigala: If we added an IStatus[] to RelationalModelProcessorImpl, we could check it's Severity and throw up a Warning/Error summary dialog after processing?
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2693) Allow warnings to be presented to the user when importing from JDBC
by Andrej Šmigala (JIRA)
Andrej Šmigala created TEIIDDES-2693:
----------------------------------------
Summary: Allow warnings to be presented to the user when importing from JDBC
Key: TEIIDDES-2693
URL: https://issues.jboss.org/browse/TEIIDDES-2693
Project: Teiid Designer
Issue Type: Enhancement
Components: Import/Export
Reporter: Andrej Šmigala
This came up when resolving TEIIDDES-2458. The fix attempts to get the correct name in source for the sybase tables, but there's a possibility this will fail. We still want to finish the import, but we'd also like to warn the user the NIS might be incorrect.
See the comment this PR: https://github.com/Teiid-Designer/teiid-designer/pull/516
<blafond> asmigala: oops. missed it. Since this warning would probably occur on multiple tables/columns it wouldn't be good to pop up a dialog during the processing.
<blafond> asmigala: If we added an IStatus[] to RelationalModelProcessorImpl, we could check it's Severity and throw up a Warning/Error summary dialog after processing?
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 6 months