June 2012 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-1413) An Error occurred fetching the Query Plan.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1413?page=com.atlassian.jira.plu... ] Steven Hawkins updated TEIIDDES-1413: ------------------------------------- Assignee: (was: Steven Hawkins) Component/s: Teiid Integration With the latest 7.7.1 teiid client drivers the plan should nearly always be available. It may not be if there is a planning error or the statement issued was handled by the client, such as a set statement or a transaction statement. With older drivers the plan was not available more often - even with successful processing if the query returned multiple batches. It would be good to have the designer handler be defensive to account for situations where the plan may not be available. > An Error occurred fetching the Query Plan. > ------------------------------------------ > > Key: TEIIDDES-1413 > URL: https://issues.jboss.org/browse/TEIIDDES-1413 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Affects Versions: 7.7 > Environment: Teiid Designer 7.7 > Teiid Server 7.5 > Jboss-5.1.0.GA > JDK 1.6.0_22 > Reporter: thanh nguyen > > Step by step: > Step 1: Right click Procedure > Choose Modeling > Choose Preview Data > Step 2: Display error below: > org.teiid.jdbc.TeiidSQLException: ResultSet cursor is after the last row. > at org.teiid.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:220) > at org.teiid.jdbc.ResultSetImpl.getString(ResultSetImpl.java:837) > at org.teiid.jdbc.ResultSetImpl.getString(ResultSetImpl.java:842) > at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable.getExecutionPlan(TeiidAdHocScriptRunnable.java:326) > at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable.handleShowExecutionPlan(TeiidAdHocScriptRunnable.java:243) > at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable.run(TeiidAdHocScriptRunnable.java:223) > at org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable.run(ResultSupportRunnable.java:346) > at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) > at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.internalRun(PreviewDataWorker.java:427) > at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.run(PreviewDataWorker.java:250) > at org.teiid.designer.runtime.ui.preview.PreviewTableDataContextAction.run(PreviewTableDataContextAction.java:98) > 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$5.handleEvent(ActionContributionItem.java:411) > at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053) > at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165) > at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754) > 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(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > at java.lang.reflect.Method.invoke(Unknown Source) > 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

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1413) An Error occurred fetching the Query Plan.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1413?page=com.atlassian.jira.plu... ] Steven Hawkins moved TEIID-2070 to TEIIDDES-1413: ------------------------------------------------- Project: Teiid Designer (was: Teiid) Key: TEIIDDES-1413 (was: TEIID-2070) Affects Version/s: 7.7 (was: 7.7) > An Error occurred fetching the Query Plan. > ------------------------------------------ > > Key: TEIIDDES-1413 > URL: https://issues.jboss.org/browse/TEIIDDES-1413 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 7.7 > Environment: Teiid Designer 7.7 > Teiid Server 7.5 > Jboss-5.1.0.GA > JDK 1.6.0_22 > Reporter: thanh nguyen > Assignee: Steven Hawkins > > Step by step: > Step 1: Right click Procedure > Choose Modeling > Choose Preview Data > Step 2: Display error below: > org.teiid.jdbc.TeiidSQLException: ResultSet cursor is after the last row. > at org.teiid.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:220) > at org.teiid.jdbc.ResultSetImpl.getString(ResultSetImpl.java:837) > at org.teiid.jdbc.ResultSetImpl.getString(ResultSetImpl.java:842) > at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable.getExecutionPlan(TeiidAdHocScriptRunnable.java:326) > at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable.handleShowExecutionPlan(TeiidAdHocScriptRunnable.java:243) > at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable.run(TeiidAdHocScriptRunnable.java:223) > at org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable.run(ResultSupportRunnable.java:346) > at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) > at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.internalRun(PreviewDataWorker.java:427) > at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.run(PreviewDataWorker.java:250) > at org.teiid.designer.runtime.ui.preview.PreviewTableDataContextAction.run(PreviewTableDataContextAction.java:98) > 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$5.handleEvent(ActionContributionItem.java:411) > at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053) > at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165) > at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754) > 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(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > at java.lang.reflect.Method.invoke(Unknown Source) > 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

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1387) Encountered NPE during XML Remote import

by Mark Drilling (JIRA)

Mark Drilling created TEIIDDES-1387: --------------------------------------- Summary: Encountered NPE during XML Remote import Key: TEIIDDES-1387 URL: https://issues.jboss.org/browse/TEIIDDES-1387 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 7.7.1 Reporter: Mark Drilling Encountered NPE during import of the PlantCatalog remote XML file example - http://www.w3schools.com/xml/plant_catalog.xml I think the issue was - I added the Plant child Elements, but left the 'root path' at the document root. However, when I re-tried the scenario - I didnt get the NPE again. Anyway, I am attaching the stacktrace - we may be able to figure out the issue from that. This may be something we want to address for usability - maybe we can do some validation to ensure that the root path is appropriate for the selected elements? -- 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

11 years, 11 months

3
3
0 / 0

[JBoss JIRA] (TEIIDDES-436) Designer to help generate Update, Insert, Delete transformations based on the Select transformations as a way to "jump-start" the user

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-436?page=com.atlassian.jira.plug... ] Barry LaFond resolved TEIIDDES-436. ----------------------------------- Resolution: Out of Date Latest Designer has SQL TEmplates action/dialog which provides these templates > Designer to help generate Update, Insert, Delete transformations based on the Select transformations as a way to "jump-start" the user > -------------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-436 > URL: https://issues.jboss.org/browse/TEIIDDES-436 > Project: Teiid Designer > Issue Type: Feature Request > Reporter: Marc Shirley > Priority: Minor > Fix For: Future > > > Currently you have to build a temp table then insert values from that to the underlying sources and still have no way to get the transaction status back to the requesting agent. We should auto generate a simple transformation and include the code to return the value of the "rows committed" back to the client -- 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

11 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1409) UELE when adding XML schema files to VDB after refactor > move of schema files

by Paul Nittel (JIRA)

Paul Nittel created TEIIDDES-1409: ------------------------------------- Summary: UELE when adding XML schema files to VDB after refactor > move of schema files Key: TEIIDDES-1409 URL: https://issues.jboss.org/browse/TEIIDDES-1409 Project: Teiid Designer Issue Type: Bug Affects Versions: 7.7 Environment: Eclipse 3.7.2 with SOA-tooling/Teiid Designer Reporter: Paul Nittel I was building a project containing a simple Web service based on a view model and table. After I created the Web service models, I refactored them to the appropriate folders. Adding them to the VDB then generated Unhandled Event Loop Exceptions. Log will be attached. -- 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

11 years, 11 months

1
3
0 / 0

[JBoss JIRA] (TEIIDDES-1407) Default NS not Added for Response Containing only Attributes

by Ted Jones (JIRA)

Ted Jones created TEIIDDES-1407: ----------------------------------- Summary: Default NS not Added for Response Containing only Attributes Key: TEIIDDES-1407 URL: https://issues.jboss.org/browse/TEIIDDES-1407 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 7.7.1 Reporter: Ted Jones Assignee: Ted Jones Fix For: 7.7.1 When importing MC WSDL and generating a response for getApps, there is no NS added to the transformation. -- 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

11 years, 11 months

1
1
0 / 0

[JBoss JIRA] (TEIIDDES-1389) Create action Sets for REST/SOAP WAR Generation

by Ted Jones (JIRA)

Ted Jones created TEIIDDES-1389: ----------------------------------- Summary: Create action Sets for REST/SOAP WAR Generation Key: TEIIDDES-1389 URL: https://issues.jboss.org/browse/TEIIDDES-1389 Project: Teiid Designer Issue Type: Feature Request Components: Web Services Support Affects Versions: 7.7.1 Reporter: Ted Jones Fix For: 7.7.1 We need action sets for WAR generation -- 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

11 years, 11 months

2
14
0 / 0

[JBoss JIRA] (TEIIDDES-1330) mxd parse errors encountered on Windows installation

by Mark Drilling (JIRA)

Mark Drilling created TEIIDDES-1330: --------------------------------------- Summary: mxd parse errors encountered on Windows installation Key: TEIIDDES-1330 URL: https://issues.jboss.org/browse/TEIIDDES-1330 Project: Teiid Designer Issue Type: Bug Components: Extension Framework Affects Versions: 7.7, 7.6 Environment: windows xp, 32 bit - 1.6 jdk Reporter: Mark Drilling Assignee: Mark Drilling Fix For: 7.7.1 Attachments: TEIIDDES-1330.TXT Installed Designer 7.6 and 7.7 on Windows XP box. Encountered parse errors when the mxd loads were attempted on startup. Salesforce, REST, and sourceFunction mxds are failing - stacktrace attached. -- 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

11 years, 11 months

1
2
0 / 0

[JBoss JIRA] (TEIIDDES-1400) WSDL to Source Importer - Namespace Prefix not Added to XPath in Generated Transformation

by Ted Jones (JIRA)

Ted Jones created TEIIDDES-1400: ----------------------------------- Summary: WSDL to Source Importer - Namespace Prefix not Added to XPath in Generated Transformation Key: TEIIDDES-1400 URL: https://issues.jboss.org/browse/TEIIDDES-1400 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 7.7.1 Reporter: Ted Jones Assignee: Ted Jones Fix For: 7.7.1 When importing the WSDL: http://www.itis.gov/ITISWebService.xml , the generated request transformation is missing the ns prefixes in the xpath. Also, the namespaces that are added are inconsistent. On one import it they may all be added and on the next, one may be missing. Generated: CREATE VIRTUAL PROCEDURE BEGIN SELECT t.* FROM XMLTABLE(XMLNAMESPACES(DEFAULT 'http://itis_service.itis.usgs.org', 'http://metadata.itis_service.itis.usgs.org/xsd' AS ax26, 'http://data.itis_service.itis.usgs.org/xsd' AS ax24), '/getCommonNamesFromTSNResponse/return/commonNames' PASSING ITISServiceView.getCommonNamesFromTSN_response.xml_in COLUMNS commonName string PATH '/commonName', "language" string PATH '/language', tsn string PATH '/tsn') AS t; END Should be: CREATE VIRTUAL PROCEDURE BEGIN SELECT t.* FROM XMLTABLE(XMLNAMESPACES(DEFAULT 'http://itis_service.itis.usgs.org', 'http://data.itis_service.itis.usgs.org/xsd' AS ax26), '/getCommonNamesFromTSNResponse/return/ax26:commonNames' PASSING xml_in COLUMNS commonName string PATH '/ax26:commonName', "language" string PATH '/ax26:language', tsn string PATH '/ax26:tsn') AS t; END -- 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

11 years, 11 months

1
1
0 / 0

[JBoss JIRA] (TEIIDDES-1405) Create Action Sets for SOAP WAR Generation

by Barry LaFond (JIRA)

Barry LaFond created TEIIDDES-1405: -------------------------------------- Summary: Create Action Sets for SOAP WAR Generation Key: TEIIDDES-1405 URL: https://issues.jboss.org/browse/TEIIDDES-1405 Project: Teiid Designer Issue Type: Feature Request Components: Modeling Affects Versions: 8.0 Reporter: Barry LaFond Fix For: 8.0 JBossWS-CXF (SOAP) War actions set: Create project Create Web Service Models Create VDB Add Models Deploy VDB Generate DS for VDB Generate JBossWS-CXF WAR Deploy JBossWS-CXF WAR -- 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

11 years, 11 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues June 2012