[JBoss JIRA] (TEIID-1811) Deleting a VDB from inventory does not remove it
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-1811?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-1811:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> made a comment on [bug 781020|https://bugzilla.redhat.com/show_bug.cgi?id=781020]
> Deleting a VDB from inventory does not remove it
> ------------------------------------------------
>
> Key: TEIID-1811
> URL: https://issues.jboss.org/browse/TEIID-1811
> Project: Teiid
> Issue Type: Bug
> Components: Tools
> Affects Versions: 7.6
> Environment: JON 2.4.1/3.0.0, PostgreSQL 8.4.8, OpenJDK 1.6.0, SOA-P/EDS
> 5.1.0/5.2.0 GA
> Reporter: Pavel Kralik
> Assignee: Ted Jones
>
> Using JON 2.4, deleting a VDB through JON GUI inventory removes the vdb from
> the EDS instance, but does not remove it from inventory. Instead, it shows the
> vdb as unavailable.
> How reproducible:
> Steps to Reproduce:
> 1. Deploy a vdb to EDS
> 2. Have agent report vdb to JON, verify in GUI
> 3. In JON inventory, delete the vdb
> Actual results:
> VDB is removed from physical server but remains in JON inventory, just as
> disabled. It remains there even after running 'discovery -f' from the agent
> console.
> Expected results:
> VDB is removed from physical server and removed from JON inventory.
> Additional info:
> https://bugzilla.redhat.com/show_bug.cgi?id=739789
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 11 months
[JBoss JIRA] (TEIID-1776) Ingres as source - Source Error Codes 2118, 2501, and 263071 being returned
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-1776?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-1776:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 780984|https://bugzilla.redhat.com/show_bug.cgi?id=780984] from ASSIGNED to ON_QA
> Ingres as source - Source Error Codes 2118, 2501, and 263071 being returned
> ---------------------------------------------------------------------------
>
> Key: TEIID-1776
> URL: https://issues.jboss.org/browse/TEIID-1776
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 7.4.1
> Reporter: Warren Gibson
> Assignee: Steven Hawkins
> Fix For: 7.4.1, 7.6
>
>
> EDS Query Testing is getting unexpected results on 4 queries. The queries are
> listed below:
> SELECT TIMEVALUE, BYTENUM, (SELECT B.FLOATNUM FROM BQT1.SMALLA AS B WHERE (B.INTKEY = (SELECT A.INTKEY FROM BQT1.SMALLA AS A WHERE (A.STRINGNUM > 10) AND (A.INTKEY = B.INTKEY))) AND (B.INTKEY = A.INTKEY)) FROM bqt1.smalla AS a
> Error Code:2118 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2118 Message:Source: Error Code:2118 Message:'Invalid qualifier 'g_1'. 'g_1' must be declared in the FROM clause or equivalent. If used in a target list, 'g_1' must be declared at the current scope.' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.timevalue, cast(g_0.bytenum AS tinyint), (SELECT g_1.floatnum FROM smalla AS g_1 WHERE g_1.intkey = g_0.intkey AND g_1.intkey = (SELECT g_2.intkey FROM smalla AS g_2 WHERE g_2.stringnum > '10' AND g_2.intkey = g_1.intkey)) FROM smalla AS g_0]
> ********************************************************
> SELECT BQT1.SmallA.TimeValue, BQT2.SmallB.TimestampValue FROM BQT1.SmallA, BQT2.SmallB WHERE BQT1.SmallA.TimeValue = convert(BQT2.SmallB.TimestampValue, time) AND BQT1.SmallA.IntKey >= 0 AND BQT2.SmallB.IntKey >= 0 ORDER BY BQT1.SmallA.TimeValue
> Error Code:2501 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2501 Message:Source: Error Code:2501 Message:'line 1, Syntax error on 'with time'. The correct syntax is: SELECT [ALL|DISTINCT] target_list FROM table(s) [WHERE search_cond] [GROUP BY col(s)] [HAVING search_cond] [UNION subselect] [ORDER BY col(s)]' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.timevalue AS c_0, g_1.timestampvalue AS c_1 FROM smalla AS g_0, smallb AS g_1 WHERE g_0.timevalue = cast(g_1.timestampvalue AS time with time zone) AND g_0.intkey >= 0 AND g_1.intkey >= 0 ORDER BY c_0]
> ********************************************************
> SELECT BQT1.SmallA.TimeValue, BQT1.SmallB.TimestampValue FROM BQT1.SmallA, BQT1.SmallB WHERE BQT1.SmallA.TimeValue = convert(BQT1.SmallB.TimestampValue, time) AND BQT1.SmallA.IntKey >= 0 AND BQT1.SmallB.IntKey >= 0 ORDER BY BQT1.SmallA.TimeValue
> Error Code:2501 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2501 Message:Source: Error Code:2501 Message:'line 1, Syntax error on 'with time'. The correct syntax is: SELECT [ALL|DISTINCT] target_list FROM table(s) [WHERE search_cond] [GROUP BY col(s)] [HAVING search_cond] [UNION subselect] [ORDER BY col(s)]' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.timevalue AS c_0, g_1.timestampvalue AS c_1 FROM smalla AS g_0, smallb AS g_1 WHERE g_0.timevalue = cast(g_1.timestampvalue AS time with time zone) AND g_0.intkey >= 0 AND g_1.intkey >= 0 ORDER BY c_0]
> *******************************************************
> SELECT intkey, stringkey, floatnum, bytenum, (SELECT bytenum FROM bqt1.smalla AS b WHERE (bytenum = a.longnum) AND (intkey = '10')) AS longnum FROM bqt1.smalla AS a
> Error Code:263071 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:263071 Message:Source: Error Code:263071 Message:'consistency check - all elements of boolean factor do not have same join id' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey, g_0.stringkey, g_0.floatnum, cast(g_0.bytenum AS tinyint), (SELECT cast(g_1.bytenum AS tinyint) FROM smalla AS g_1 WHERE cast(cast(g_1.bytenum AS tinyint) AS bigint) = g_0.longnum AND g_1.intkey = 10) FROM smalla AS g_0]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 11 months
[JBoss JIRA] (TEIID-1907) SQLStringVisitor should create call visitNode on Select
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1907?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-1907.
-----------------------------------
Fix Version/s: 8.0
Resolution: Done
removed the visitDirect call and moved adding the select keyword to the query visit.
> SQLStringVisitor should create call visitNode on Select
> -------------------------------------------------------
>
> Key: TEIID-1907
> URL: https://issues.jboss.org/browse/TEIID-1907
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.5
> Environment: Fedora 16, JBDS 5.0.0 M5, Teiid Designer 7.6
> Reporter: Paul Nittel
> Assignee: Steven Hawkins
> Fix For: 7.6.1, 8.0
>
>
> Here's what I get:
> eclipse.buildId=unknown
> java.version=1.6.0_22
> java.vendor=Sun Microsystems Inc.
> BootLoader constants: OS=linux, ARCH=x86_64, WS=gtk, NL=en_US
> Framework arguments: -product com.jboss.jbds.product.product
> Command-line arguments: -os linux -ws gtk -arch x86_64 -product com.jboss.jbds.product.product
> Error
> Wed Jan 18 16:35:12 CST 2012
> Unhandled event loop exception
> java.lang.NullPointerException
> at com.metamatrix.query.internal.ui.sqleditor.component.QueryDisplayComponent.expandSelect(QueryDisplayComponent.java:586)
> at com.metamatrix.modeler.transformation.ui.editors.sqleditor.SqlEditorPanel.expandCurrentSelect(SqlEditorPanel.java:1872)
> at com.metamatrix.modeler.transformation.ui.editors.sqleditor.SqlEditorPanelWrapper.expandCurrentSelect(SqlEditorPanelWrapper.java:161)
> at com.metamatrix.modeler.transformation.ui.editors.sqleditor.actions.ExpandSelect.doRun(ExpandSelect.java:48)
> at com.metamatrix.ui.actions.AbstractAction$1.run(AbstractAction.java:537)
> at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
> at com.metamatrix.ui.actions.AbstractAction.run(AbstractAction.java:540)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
> at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
> at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
> at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:452)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3588)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3209)
> at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2696)
> at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2660)
> at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2494)
> at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:674)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:667)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:123)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:616)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1410)
> at org.eclipse.equinox.launcher.Main.main(Main.java:1386)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 11 months
[JBoss JIRA] (TEIID-1907) SQLStringVisitor should create call visitNode on Select
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1907?page=com.atlassian.jira.plugin... ]
Steven Hawkins moved TEIIDDES-1220 to TEIID-1907:
-------------------------------------------------
Project: Teiid (was: Teiid Designer)
Key: TEIID-1907 (was: TEIIDDES-1220)
Affects Version/s: 7.5
(was: 7.6)
Component/s: Query Engine
(was: Transformations)
Fix Version/s: 7.6.1
(was: 7.7)
> SQLStringVisitor should create call visitNode on Select
> -------------------------------------------------------
>
> Key: TEIID-1907
> URL: https://issues.jboss.org/browse/TEIID-1907
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.5
> Environment: Fedora 16, JBDS 5.0.0 M5, Teiid Designer 7.6
> Reporter: Paul Nittel
> Fix For: 7.6.1
>
>
> Here's what I get:
> eclipse.buildId=unknown
> java.version=1.6.0_22
> java.vendor=Sun Microsystems Inc.
> BootLoader constants: OS=linux, ARCH=x86_64, WS=gtk, NL=en_US
> Framework arguments: -product com.jboss.jbds.product.product
> Command-line arguments: -os linux -ws gtk -arch x86_64 -product com.jboss.jbds.product.product
> Error
> Wed Jan 18 16:35:12 CST 2012
> Unhandled event loop exception
> java.lang.NullPointerException
> at com.metamatrix.query.internal.ui.sqleditor.component.QueryDisplayComponent.expandSelect(QueryDisplayComponent.java:586)
> at com.metamatrix.modeler.transformation.ui.editors.sqleditor.SqlEditorPanel.expandCurrentSelect(SqlEditorPanel.java:1872)
> at com.metamatrix.modeler.transformation.ui.editors.sqleditor.SqlEditorPanelWrapper.expandCurrentSelect(SqlEditorPanelWrapper.java:161)
> at com.metamatrix.modeler.transformation.ui.editors.sqleditor.actions.ExpandSelect.doRun(ExpandSelect.java:48)
> at com.metamatrix.ui.actions.AbstractAction$1.run(AbstractAction.java:537)
> at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
> at com.metamatrix.ui.actions.AbstractAction.run(AbstractAction.java:540)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
> at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
> at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
> at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:452)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3588)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3209)
> at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2696)
> at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2660)
> at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2494)
> at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:674)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:667)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:123)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:616)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1410)
> at org.eclipse.equinox.launcher.Main.main(Main.java:1386)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 11 months
[JBoss JIRA] (TEIID-1907) SQLStringVisitor should create call visitNode on Select
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1907?page=com.atlassian.jira.plugin... ]
Steven Hawkins reassigned TEIID-1907:
-------------------------------------
Assignee: Steven Hawkins
> SQLStringVisitor should create call visitNode on Select
> -------------------------------------------------------
>
> Key: TEIID-1907
> URL: https://issues.jboss.org/browse/TEIID-1907
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.5
> Environment: Fedora 16, JBDS 5.0.0 M5, Teiid Designer 7.6
> Reporter: Paul Nittel
> Assignee: Steven Hawkins
> Fix For: 7.6.1
>
>
> Here's what I get:
> eclipse.buildId=unknown
> java.version=1.6.0_22
> java.vendor=Sun Microsystems Inc.
> BootLoader constants: OS=linux, ARCH=x86_64, WS=gtk, NL=en_US
> Framework arguments: -product com.jboss.jbds.product.product
> Command-line arguments: -os linux -ws gtk -arch x86_64 -product com.jboss.jbds.product.product
> Error
> Wed Jan 18 16:35:12 CST 2012
> Unhandled event loop exception
> java.lang.NullPointerException
> at com.metamatrix.query.internal.ui.sqleditor.component.QueryDisplayComponent.expandSelect(QueryDisplayComponent.java:586)
> at com.metamatrix.modeler.transformation.ui.editors.sqleditor.SqlEditorPanel.expandCurrentSelect(SqlEditorPanel.java:1872)
> at com.metamatrix.modeler.transformation.ui.editors.sqleditor.SqlEditorPanelWrapper.expandCurrentSelect(SqlEditorPanelWrapper.java:161)
> at com.metamatrix.modeler.transformation.ui.editors.sqleditor.actions.ExpandSelect.doRun(ExpandSelect.java:48)
> at com.metamatrix.ui.actions.AbstractAction$1.run(AbstractAction.java:537)
> at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
> at com.metamatrix.ui.actions.AbstractAction.run(AbstractAction.java:540)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
> at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
> at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
> at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:452)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3588)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3209)
> at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2696)
> at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2660)
> at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2494)
> at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:674)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:667)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:123)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:616)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1410)
> at org.eclipse.equinox.launcher.Main.main(Main.java:1386)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 11 months