February 2014 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-1010) Indexes are not qualified when imported with Teiid Designer

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1010?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-1010: --------------------------------------------------- Anne-Louise Tangring <atangrin(a)redhat.com> changed the Status of [bug 780724|https://bugzilla.redhat.com/show_bug.cgi?id=780724] from VERIFIED to CLOSED > Indexes are not qualified when imported with Teiid Designer > ----------------------------------------------------------- > > Key: TEIIDDES-1010 > URL: https://issues.jboss.org/browse/TEIIDDES-1010 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 7.4 > Reporter: Marc Shirley > Assignee: Barry LaFond > Fix For: 8.1 > > Attachments: org.teiid.designer.jdbc.relational.patch > > > Having multiple indexes with the same name (for example, 'PrimaryKey') imported results in a conflict or merging of the indexes. This generates messages complaining of an index referring to multiple tables in the Teiid Designer perspective. The indexes should be qualified in order to remain unique or generated as a child of the associated table in order to avoid these messages. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1862) Metamatrix simple-types xsd import prevents generation of cxf war file

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1862?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-1862: --------------------------------------------------- Anne-Louise Tangring <atangrin(a)redhat.com> changed the Status of [bug 1006329|https://bugzilla.redhat.com/show_bug.cgi?id=1006329] from VERIFIED to CLOSED > Metamatrix simple-types xsd import prevents generation of cxf war file > ---------------------------------------------------------------------- > > Key: TEIIDDES-1862 > URL: https://issues.jboss.org/browse/TEIIDDES-1862 > Project: Teiid Designer > Issue Type: Bug > Components: Web Services Support > Affects Versions: 8.2 > Environment: Windows 7, Eclipse Kepler > Reporter: Pablo Navascues > Assignee: Paul Richardson > Priority: Critical > Fix For: 8.3 > > > 1. Generate a model to expose through webservices that uses one of the datatypes from the http://www.metamatrix.com/metamodels/SimpleDatatypes-instance schema. [comment-1] > 2. Select the model > Right Click > Modeling > Create Web Service > 3. XSDs generated have the metamatrix schema import which uses "http://www.metamatrix.com/metamodels/SimpleDatatypes-instance" for the namespace AND the schema location. > 4. Double clicking in the model explorer in one of this xsd trys to open it and hangs for a while. > [comment-2] > 5. Select VDB > Modelling > Generate JbossWS-CXF War. This hangs for a long while and afterwards fails to generate the war file. > Is there a workaround for this? > comments: > [comment-1]: import a table from and Oracle DB that has a BigInteger. That will force the built-in schema to be added. > [comment-2]: create a VDB with generated models -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1010) Indexes are not qualified when imported with Teiid Designer

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1010?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-1010: --------------------------------------------------- Lucie Fabrikova <lfabriko(a)redhat.com> changed the Status of [bug 780724|https://bugzilla.redhat.com/show_bug.cgi?id=780724] from ON_QA to VERIFIED > Indexes are not qualified when imported with Teiid Designer > ----------------------------------------------------------- > > Key: TEIIDDES-1010 > URL: https://issues.jboss.org/browse/TEIIDDES-1010 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 7.4 > Reporter: Marc Shirley > Assignee: Barry LaFond > Fix For: 8.1 > > Attachments: org.teiid.designer.jdbc.relational.patch > > > Having multiple indexes with the same name (for example, 'PrimaryKey') imported results in a conflict or merging of the indexes. This generates messages complaining of an index referring to multiple tables in the Teiid Designer perspective. The indexes should be qualified in order to remain unique or generated as a child of the associated table in order to avoid these messages. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2040) Create WS action results in SQL transformation validation errors

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2040?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2040: ---------------------------------------- I captured the BEFORE and AFTER transformation info for one operation below. Note the "nested" mapping with referenced input. We'll need to track down what logic is resolving/reconciling/setting these values by opening the t-editor. SQL after Create Web Service: {code:xml} <transformationMappings xsi:type="transformation:SqlTransformationMappingRoot" xmi:uuid="mmuuid:bcb7929b-7d70-4567-94a6-379bb9fff442" outputs="mmuuid/7d7f17bd-a415-4023-882b-fd0c54464a38" target="mmuuid/7d7f17bd-a415-4023-882b-fd0c54464a38"> <helper xsi:type="transformation:SqlTransformation" xmi:uuid="mmuuid:f9a235d7-f072-4078-b01c-98bb2b5a39ac"> <nested xsi:type="transformation:SqlTransformation" xmi:uuid="mmuuid:e5c11537-55e8-4889-8771-a2986b57d58a" selectSql="CREATE VIRTUAL PROCEDURE BEGIN DECLARE string VARIABLES.IN_exampleVar ;VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');SELECT * FROM AAA_View.SHIP_VIA_OutputView; END"/> </helper> {code} SQL After d-clicking, opening t-editor and validation fixed {code:xml} <transformationMappings xsi:type="transformation:SqlTransformationMappingRoot" xmi:uuid="mmuuid:bcb7929b-7d70-4567-94a6-379bb9fff442" outputs="mmuuid/7d7f17bd-a415-4023-882b-fd0c54464a38" target="mmuuid/7d7f17bd-a415-4023-882b-fd0c54464a38"> <helper xsi:type="transformation:SqlTransformation" xmi:uuid="mmuuid:f9a235d7-f072-4078-b01c-98bb2b5a39ac"> <nested xsi:type="transformation:SqlTransformation" xmi:uuid="mmuuid:e5c11537-55e8-4889-8771-a2986b57d58a" selectSql="CREATE VIRTUAL PROCEDURE BEGIN DECLARE string VARIABLES.IN_exampleVar ;VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');SELECT * FROM AAA_View.SHIP_VIA_OutputView; END"/> <aliases xmi:uuid="mmuuid:a8fa3afb-1d55-4a4f-98f5-e5ab987f2ad4" alias="SHIP_VIA_OutputView"> <aliasedObject href="AAA_View.xmi#mmuuid/a46365c7-621b-4905-bc5f-fe40e3b42026"/> </aliases> </helper> <nested xsi:type="transformation:TransformationMapping" xmi:uuid="mmuuid:1ceedbca-a363-491b-9a48-0eff07d78a04" outputs="mmuuid/a8c4a2a8-fe48-4754-b155-8ba049114ce5"/> <inputs href="AAA_View.xmi#mmuuid/a46365c7-621b-4905-bc5f-fe40e3b42026"/> </transformationMappings> {code} > Create WS action results in SQL transformation validation errors > ---------------------------------------------------------------- > > Key: TEIIDDES-2040 > URL: https://issues.jboss.org/browse/TEIIDDES-2040 > Project: Teiid Designer > Issue Type: Bug > Components: Validation, Web Services Support > Affects Versions: 8.3 > Reporter: Barry LaFond > Assignee: Mark Drilling > Fix For: 8.4, 8.3.2 > > > 1) Create/Import a simple Source Model (Parts Supplier Oracle) > 2) Select model, right-click select Modeling > Create Web Service > 3) Resulting WS model will have operations with SQL validation errors > 4) Double-clicking each operation to open it's t-Editor will tweak the SQL and fix the error -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2040) Create WS action results in SQL transformation validation errors

by Barry LaFond (JIRA)

Barry LaFond created TEIIDDES-2040: -------------------------------------- Summary: Create WS action results in SQL transformation validation errors Key: TEIIDDES-2040 URL: https://issues.jboss.org/browse/TEIIDDES-2040 Project: Teiid Designer Issue Type: Bug Components: Validation, Web Services Support Affects Versions: 8.3 Reporter: Barry LaFond Assignee: Mark Drilling Fix For: 8.4, 8.3.2 1) Create/Import a simple Source Model (Parts Supplier Oracle) 2) Select model, right-click select Modeling > Create Web Service 3) Resulting WS model will have operations with SQL validation errors 4) Double-clicking each operation to open it's t-Editor will tweak the SQL and fix the error -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1118) Add/Remove operations on a VDB should block other operations on the VDB

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1118?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-1118: ---------------------------------------- The newly attached logs seem to indicate multiple issues and not related to his original bug. If you can reproduce each one, please log separate jiras. log1 - please reproduce and log separate jira. log2 - trace is not related to Designer source log3 - I could not reproduce using the "Define VDB" guides action log4 - I could not reproduce. I assumed you had vdb1.vdb already defined and re-launched the Define VDB action. I was able to create a new VDB, adding the WS model and all dependent models were added. Note that there is an issue with Create WS action, 4 of the 5 operations ended up with SQL validation errors. Double-clicking each operation to open the editor fixed the problems. So this would be a work-around. > Add/Remove operations on a VDB should block other operations on the VDB > ----------------------------------------------------------------------- > > Key: TEIIDDES-1118 > URL: https://issues.jboss.org/browse/TEIIDDES-1118 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 7.4.2 > Reporter: Marc Shirley > Assignee: Mark Drilling > Fix For: 7.7.2, 8.0 > > Attachments: log1, log2, log3, log4, VariousBugs.zip > > > As adding/removing objects from a VDB results in filesystem operations of adding/removing indexes, this should result in a blocking of additional operations against the VDB. If latency with the filesystem is large enough (for example, on a network filesystem) and no blocking is performed, multiple operations can be performed on the VDB resulting in the below exception: > !MESSAGE Unhandled event loop exception > !STACK 0 > java.lang.ArrayIndexOutOfBoundsException: 0 > at org.teiid.designer.vdb.VdbModelEntry.synchronizeModelEntry(VdbModelEntry.java:435) > at org.teiid.designer.vdb.Vdb.addModelEntry(Vdb.java:244) > at com.metamatrix.modeler.internal.vdb.ui.editor.VdbEditor$25.selected(VdbEditor.java:1709) > at com.metamatrix.ui.table.TableAndToolBar$2.run(TableAndToolBar.java:79) > 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:1053) > at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066) > at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657) > at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2640) > at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604) > at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438) > at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671) > at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332) > at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664) > at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) > at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:115) > 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:369) > 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:39) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:620) > at org.eclipse.equinox.launcher.Main.basicRun(Main.java:575) > at org.eclipse.equinox.launcher.Main.run(Main.java:1408) > at org.eclipse.equinox.launcher.Main.main(Main.java:1384) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1961) Create User Defined Wizard Displays The UDF Jar Path In Reverse Order From Entered Text

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1961?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-1961: ----------------------------------- Fix Version/s: 8.4 8.3.2 > Create User Defined Wizard Displays The UDF Jar Path In Reverse Order From Entered Text > --------------------------------------------------------------------------------------- > > Key: TEIIDDES-1961 > URL: https://issues.jboss.org/browse/TEIIDDES-1961 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 8.3 > Reporter: Van Halbert > Assignee: Ted Jones > Fix For: 8.3, 8.4, 8.3.2 > > > Description of problem: > If you enter "abc" in the "UDF Jar Path" field of the "Create User Defined Function" Wizard, the text is displayed "cba". > Version-Release number of selected component (if applicable): > DV 6.0.0 ER4 > JBDS 7.1.0 CR1 > JBIS 4.1.3 Beta5 > Teiid Designer 8.3.0 CR1 > How reproducible: > Always. > Steps to Reproduce: > Using Designer: > 1. Create a new relational model > 2. New Child > Procedure > User Defined Function > OK > 3. Enter text in the "UDF Jar Path" field > Actual results: > The UDF JAR path text is reversed. > Expected results: > The UDF JAR path is displayed as entered. > Additional info: > None. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1961) Create User Defined Wizard Displays The UDF Jar Path In Reverse Order From Entered Text

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1961?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-1961: ----------------------------------- Assignee: Ted Jones (was: Barry LaFond) > Create User Defined Wizard Displays The UDF Jar Path In Reverse Order From Entered Text > --------------------------------------------------------------------------------------- > > Key: TEIIDDES-1961 > URL: https://issues.jboss.org/browse/TEIIDDES-1961 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 8.3 > Reporter: Van Halbert > Assignee: Ted Jones > Fix For: 8.3 > > > Description of problem: > If you enter "abc" in the "UDF Jar Path" field of the "Create User Defined Function" Wizard, the text is displayed "cba". > Version-Release number of selected component (if applicable): > DV 6.0.0 ER4 > JBDS 7.1.0 CR1 > JBIS 4.1.3 Beta5 > Teiid Designer 8.3.0 CR1 > How reproducible: > Always. > Steps to Reproduce: > Using Designer: > 1. Create a new relational model > 2. New Child > Procedure > User Defined Function > OK > 3. Enter text in the "UDF Jar Path" field > Actual results: > The UDF JAR path text is reversed. > Expected results: > The UDF JAR path is displayed as entered. > Additional info: > None. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1961) Create User Defined Wizard Displays The UDF Jar Path In Reverse Order From Entered Text

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1961?page=com.atlassian.jira.plu... ] Barry LaFond reopened TEIIDDES-1961: ------------------------------------ > Create User Defined Wizard Displays The UDF Jar Path In Reverse Order From Entered Text > --------------------------------------------------------------------------------------- > > Key: TEIIDDES-1961 > URL: https://issues.jboss.org/browse/TEIIDDES-1961 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 8.3 > Reporter: Van Halbert > Assignee: Ted Jones > Fix For: 8.3 > > > Description of problem: > If you enter "abc" in the "UDF Jar Path" field of the "Create User Defined Function" Wizard, the text is displayed "cba". > Version-Release number of selected component (if applicable): > DV 6.0.0 ER4 > JBDS 7.1.0 CR1 > JBIS 4.1.3 Beta5 > Teiid Designer 8.3.0 CR1 > How reproducible: > Always. > Steps to Reproduce: > Using Designer: > 1. Create a new relational model > 2. New Child > Procedure > User Defined Function > OK > 3. Enter text in the "UDF Jar Path" field > Actual results: > The UDF JAR path text is reversed. > Expected results: > The UDF JAR path is displayed as entered. > Additional info: > None. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2013) Preview with SalesForce data source does not work

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2013?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2013: ----------------------------------- Fix Version/s: 8.4 > Preview with SalesForce data source does not work > ------------------------------------------------- > > Key: TEIIDDES-2013 > URL: https://issues.jboss.org/browse/TEIIDDES-2013 > Project: Teiid Designer > Issue Type: Bug > Components: Data Preview > Affects Versions: 8.3 > Reporter: Ramesh Reddy > Assignee: Mark Drilling > Fix For: 8.4, 8.3.2 > > > 1) start my external jboss running teiid 8.6 and my teiid instance within the designer > 2) create a teiid model project > 3) import a salesforce model > 4) supply un, pw, and url > 5) test connection... > 6) select a table from the model, e.g., Account > 6) select preview data > See exception > EIID70006 {"JBAS014671: Failed services" => {"jboss.ra.deployment.PREVIEW_7ca3b12a-7296-455f-a6a3-2ccc75fd3819_SFTest_SFTestModel_1" => "org.jboss.msc.service.StartException in service jboss.ra.deployment.PREVIEW_7ca3b12a-7296-455f-a6a3-2ccc75fd3819_SFTest_SFTestModel_1: org.jboss.msc.service.StartException in anonymous service: JBAS010446: Failed to start RA deployment [PREVIEW_7ca3b12a-7296-455f-a6a3-2ccc75fd3819_SFTest_SFTestModel] > Caused by: org.jboss.msc.service.StartException in anonymous service: JBAS010446: Failed to start RA deployment [PREVIEW_7ca3b12a-7296-455f-a6a3-2ccc75fd3819_SFTest_SFTestModel] > Caused by: org.jboss.jca.deployers.common.DeployException: IJ020060: Unable to inject: org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory property: url value: https://cs30.salesforce.com/services/Soap/u/29.0"}} > > The issue I see is the URL property "name" needs to be uppercase. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 2 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues February 2014