[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
[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
[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
[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
[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
[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
[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