[JBoss JIRA] (TEIIDDES-2245) Error Assigning WS CP to source model
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2245?page=com.atlassian.jira.plu... ]
Ted Jones commented on TEIIDDES-2245:
-------------------------------------
Stack trace from Designer:
!STACK 0
java.lang.IllegalArgumentException: No value for the connection property 'AuthPassword'
at org.teiid.core.designer.util.CoreArgCheck.isNotZeroLength(CoreArgCheck.java:117)
at org.teiid.core.designer.util.CoreArgCheck.isNotEmpty(CoreArgCheck.java:249)
at org.teiid.designer.runtime.TeiidServer.getOrCreateDataSource(TeiidServer.java:594)
at org.teiid.designer.runtime.TeiidDataSourceFactory.createDataSource(TeiidDataSourceFactory.java:173)
at org.teiid.designer.runtime.preview.PreviewManager.ensureConnectionInfoIsValid(PreviewManager.java:526)
at org.teiid.designer.runtime.preview.jobs.UpdatePreviewVdbJob.runImpl(UpdatePreviewVdbJob.java:124)
at org.teiid.designer.runtime.preview.jobs.WorkspacePreviewVdbJob.runInWorkspace(WorkspacePreviewVdbJob.java:129)
at org.eclipse.core.internal.resources.InternalWorkspaceJob.run(InternalWorkspaceJob.java:38)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
> Error Assigning WS CP to source model
> -------------------------------------
>
> Key: TEIIDDES-2245
> URL: https://issues.jboss.org/browse/TEIIDDES-2245
> Project: Teiid Designer
> Issue Type: Feature Request
> Security Level: Public(Everyone can see)
> Components: Data Preview, VDB & Execution, Web Services Support
> Affects Versions: 8.6
> Reporter: Ted Jones
> Priority: Blocker
> Fix For: 8.6, 8.5.1
>
>
> When assigning a WS CP to a source model, I get the following error:
> An error synchronizing and saving the Preview VDB for model "/restBooks/StockSource.xmi" occurred.
> No value for the connection property 'AuthPassword'
> The source WS has no security.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2245) Error Assigning WS CP to source model
by Ted Jones (JIRA)
Ted Jones created TEIIDDES-2245:
-----------------------------------
Summary: Error Assigning WS CP to source model
Key: TEIIDDES-2245
URL: https://issues.jboss.org/browse/TEIIDDES-2245
Project: Teiid Designer
Issue Type: Feature Request
Security Level: Public (Everyone can see)
Components: Data Preview, VDB & Execution, Web Services Support
Affects Versions: 8.6
Reporter: Ted Jones
Priority: Blocker
Fix For: 8.6, 8.5.1
When assigning a WS CP to a source model, I get the following error:
An error synchronizing and saving the Preview VDB for model "/restBooks/StockSource.xmi" occurred.
No value for the connection property 'AuthPassword'
The source WS has no security.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2244) Exception in TeiidServerVersion parsing "8.4.1-redhat-7"
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2244?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2244.
------------------------------------
Resolution: Done
Done
> Exception in TeiidServerVersion parsing "8.4.1-redhat-7"
> --------------------------------------------------------
>
> Key: TEIIDDES-2244
> URL: https://issues.jboss.org/browse/TEIIDDES-2244
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Patch Release, Teiid Integration
> Affects Versions: 8.3.3
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 8.3.4
>
>
> Tried to preview against a DV6 V4 server version and received exceptions in TeiidServerVersion trying to parse "8.4.1-redhat-7" version string.
> This was fixed in 8.5 and needs to get back-ported to 8.3.4
> java.lang.NumberFormatException: For input string: "1-redhat-7"
> at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> at java.lang.Integer.parseInt(Integer.java:481)
> at java.lang.Integer.parseInt(Integer.java:514)
> at org.teiid.designer.runtime.version.spi.TeiidServerVersion.isLessThan(TeiidServerVersion.java:285)
> at org.teiid.datatools.connectivity.ConnectivityUtil.getTeiidDriverDefinitionId(ConnectivityUtil.java:100)
> at org.teiid.datatools.connectivity.ConnectivityUtil.createDriverProps(ConnectivityUtil.java:133)
> at org.teiid.datatools.connectivity.ConnectivityUtil.createTransientTeiidProfile(ConnectivityUtil.java:161)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.internalRun(PreviewDataWorker.java:388)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.run(PreviewDataWorker.java:261)
> at org.teiid.designer.runtime.ui.preview.PreviewTableDataContextAction.run(PreviewTableDataContextAction.java:99)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:499)
> GIT commit: https://github.com/Teiid-Designer/teiid-designer/commit/df52ff62ae4ff022c...
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2244) Exception in TeiidServerVersion parsing "8.4.1-redhat-7"
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2244?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2244:
-----------------------------------
Git Pull Request: https://github.com/Teiid-Designer/teiid-designer/commit/434401a55f04b7bcf...
> Exception in TeiidServerVersion parsing "8.4.1-redhat-7"
> --------------------------------------------------------
>
> Key: TEIIDDES-2244
> URL: https://issues.jboss.org/browse/TEIIDDES-2244
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Patch Release, Teiid Integration
> Affects Versions: 8.3.3
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 8.3.4
>
>
> Tried to preview against a DV6 V4 server version and received exceptions in TeiidServerVersion trying to parse "8.4.1-redhat-7" version string.
> This was fixed in 8.5 and needs to get back-ported to 8.3.4
> java.lang.NumberFormatException: For input string: "1-redhat-7"
> at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> at java.lang.Integer.parseInt(Integer.java:481)
> at java.lang.Integer.parseInt(Integer.java:514)
> at org.teiid.designer.runtime.version.spi.TeiidServerVersion.isLessThan(TeiidServerVersion.java:285)
> at org.teiid.datatools.connectivity.ConnectivityUtil.getTeiidDriverDefinitionId(ConnectivityUtil.java:100)
> at org.teiid.datatools.connectivity.ConnectivityUtil.createDriverProps(ConnectivityUtil.java:133)
> at org.teiid.datatools.connectivity.ConnectivityUtil.createTransientTeiidProfile(ConnectivityUtil.java:161)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.internalRun(PreviewDataWorker.java:388)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.run(PreviewDataWorker.java:261)
> at org.teiid.designer.runtime.ui.preview.PreviewTableDataContextAction.run(PreviewTableDataContextAction.java:99)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:499)
> GIT commit: https://github.com/Teiid-Designer/teiid-designer/commit/df52ff62ae4ff022c...
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2161) Merge various fixes from master into 8.3.4
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2161?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2161:
-----------------------------------
Description:
*Candidates*
* TEIIDDES-2018 DDL importer creates wrong data type for "integer"
* TEIIDDES-2089 Teiid connection import throws "java.lang.IllegalArgumentException: The supplied model folder refers to an existing non-model project" on Windows
* TEIIDDES-2100 Add ability to migrate older models containing table names with "." characters
* TEIIDDES-2152 Adding source table with quoted name results in wrong generated SQL statement
* TEIIDDES-2142 & TEIIDDES-2131 New VDB Data Role' Dialog needs layout improvement
* TEIIDDES-2147 Packaged runtime client lib versions in Designer are behind the corresponding server libs (Investigate if it's possible to back-port)
* TEIIDDES-2189 Add ModelType validation in the New MED wizard to prevent creating MED without one selected
* TEIIDDES-2224 web service returns 500 when concurrent access
*Completed Upstream*
* TEIIDDES-2138 Restrict "New VDB" wizard's "Add model" to the current project (work around exists, suggest push to 8.3.4)
* TEIIDDES-2154 Preview VDB is not updated after adding or modifying a translator override (no bz, suggest push to 8.3.4)
* TEIIDDES-2156 Building Vdbs in eclipse should not throw runtime exceptions
* TEIIDDES-2153 Create relational model from SOAP WS with Service Mode MESSAGE can't be finished
* TEIIDDES-2162 WSDL->Souce/View Importer issues
* TEIIDDES-2164 Editing teiid importer connection url can't be finished
*Committed*
* TEIIDDES-2214 Cannot generate CXF WAR from VDB created in 8.3.3
* TEIIDDES-2017 NPE while using Teiid Connection Importer
* TEIIDDES-2111 NPE trying to Preview Data (partial merge)
* TEIIDDES-2186 SWT Illegal Argument exception from Teiid Server Editor page
* TEIIDDES-2244 Exception in TeiidServerVersion parsing "8.4.1-redhat-7"
was:
*Candidates*
* TEIIDDES-2018 DDL importer creates wrong data type for "integer"
* TEIIDDES-2089 Teiid connection import throws "java.lang.IllegalArgumentException: The supplied model folder refers to an existing non-model project" on Windows
* TEIIDDES-2100 Add ability to migrate older models containing table names with "." characters
* TEIIDDES-2152 Adding source table with quoted name results in wrong generated SQL statement
* TEIIDDES-2142 & TEIIDDES-2131 New VDB Data Role' Dialog needs layout improvement
* TEIIDDES-2147 Packaged runtime client lib versions in Designer are behind the corresponding server libs (Investigate if it's possible to back-port)
* TEIIDDES-2189 Add ModelType validation in the New MED wizard to prevent creating MED without one selected
* TEIIDDES-2224 web service returns 500 when concurrent access
*Completed Upstream*
* TEIIDDES-2138 Restrict "New VDB" wizard's "Add model" to the current project (work around exists, suggest push to 8.3.4)
* TEIIDDES-2154 Preview VDB is not updated after adding or modifying a translator override (no bz, suggest push to 8.3.4)
* TEIIDDES-2156 Building Vdbs in eclipse should not throw runtime exceptions
* TEIIDDES-2153 Create relational model from SOAP WS with Service Mode MESSAGE can't be finished
* TEIIDDES-2162 WSDL->Souce/View Importer issues
* TEIIDDES-2164 Editing teiid importer connection url can't be finished
* TEIIDDES-2244 Exception in TeiidServerVersion parsing "8.4.1-redhat-7"
*Committed*
* TEIIDDES-2214 Cannot generate CXF WAR from VDB created in 8.3.3
* TEIIDDES-2017 NPE while using Teiid Connection Importer
* TEIIDDES-2186 SWT Illegal Argument exception from Teiid Server Editor page
> Merge various fixes from master into 8.3.4
> ------------------------------------------
>
> Key: TEIIDDES-2161
> URL: https://issues.jboss.org/browse/TEIIDDES-2161
> Project: Teiid Designer
> Issue Type: Task
> Security Level: Public(Everyone can see)
> Components: Patch Release
> Reporter: Barry LaFond
> Priority: Blocker
> Fix For: 8.3.4
>
>
> *Candidates*
> * TEIIDDES-2018 DDL importer creates wrong data type for "integer"
> * TEIIDDES-2089 Teiid connection import throws "java.lang.IllegalArgumentException: The supplied model folder refers to an existing non-model project" on Windows
> * TEIIDDES-2100 Add ability to migrate older models containing table names with "." characters
> * TEIIDDES-2152 Adding source table with quoted name results in wrong generated SQL statement
> * TEIIDDES-2142 & TEIIDDES-2131 New VDB Data Role' Dialog needs layout improvement
> * TEIIDDES-2147 Packaged runtime client lib versions in Designer are behind the corresponding server libs (Investigate if it's possible to back-port)
> * TEIIDDES-2189 Add ModelType validation in the New MED wizard to prevent creating MED without one selected
> * TEIIDDES-2224 web service returns 500 when concurrent access
> *Completed Upstream*
> * TEIIDDES-2138 Restrict "New VDB" wizard's "Add model" to the current project (work around exists, suggest push to 8.3.4)
> * TEIIDDES-2154 Preview VDB is not updated after adding or modifying a translator override (no bz, suggest push to 8.3.4)
> * TEIIDDES-2156 Building Vdbs in eclipse should not throw runtime exceptions
> * TEIIDDES-2153 Create relational model from SOAP WS with Service Mode MESSAGE can't be finished
> * TEIIDDES-2162 WSDL->Souce/View Importer issues
> * TEIIDDES-2164 Editing teiid importer connection url can't be finished
> *Committed*
> * TEIIDDES-2214 Cannot generate CXF WAR from VDB created in 8.3.3
> * TEIIDDES-2017 NPE while using Teiid Connection Importer
> * TEIIDDES-2111 NPE trying to Preview Data (partial merge)
> * TEIIDDES-2186 SWT Illegal Argument exception from Teiid Server Editor page
> * TEIIDDES-2244 Exception in TeiidServerVersion parsing "8.4.1-redhat-7"
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2207) Web Service Operation SQL valid in 8.3.2 but invalid in 8.5
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2207?page=com.atlassian.jira.plu... ]
Ted Jones commented on TEIIDDES-2207:
-------------------------------------
I suggest we remove the logic to generate the variable in the case where there is no PK. The variable is never used in that scenario anyway.
> Web Service Operation SQL valid in 8.3.2 but invalid in 8.5
> -----------------------------------------------------------
>
> Key: TEIIDDES-2207
> URL: https://issues.jboss.org/browse/TEIIDDES-2207
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Validation, Web Services Support
> Affects Versions: 8.5
> Reporter: Barry LaFond
> Assignee: Paul Richardson
> Priority: Critical
> Fix For: 8.6, 8.5.1
>
> Attachments: testWebService.zip
>
>
> Compared creating WS from source and view models in 8.3.2 vs 8.5.
> See attached project set
> 1) Created WS from ProductsOracle source and WS operations validated fine in 8.3.2 and 8.5 Designer
> 2) Created WS from PRoductsViews view model and WS operations contained an error.
> Differences in the SQL for 8.5 vs 8.3.2 relate to the removing the CREATE VIRTUAL PROCEDURE in the SQL.
> 8.3.2 SQL
> {code}
> CREATE VIRTUAL PROCEDURE
> BEGIN
> DECLARE string VARIABLES.IN_exampleVar;
> VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');
> SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView;
> END
> {code}
> Same operation validated in 8.5 but results in validation error:
> {code}
> BEGIN
> DECLARE string VARIABLES.IN_exampleVar;
> VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');
> SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView;
> END
> {code}
> ERROR
> {code}
> ERROR: TEIID30070 The function 'xPathValue(null, '//*[local-name()="exampleName"]')' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions.
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2244) Exception in TeiidServerVersion parsing "8.4.1-redhat-7"
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2244?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2244:
-----------------------------------
Component/s: Teiid Integration
> Exception in TeiidServerVersion parsing "8.4.1-redhat-7"
> --------------------------------------------------------
>
> Key: TEIIDDES-2244
> URL: https://issues.jboss.org/browse/TEIIDDES-2244
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Patch Release, Teiid Integration
> Affects Versions: 8.3.3
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 8.3.4
>
>
> Tried to preview against a DV6 V4 server version and received exceptions in TeiidServerVersion trying to parse "8.4.1-redhat-7" version string.
> This was fixed in 8.5 and needs to get back-ported to 8.3.4
> java.lang.NumberFormatException: For input string: "1-redhat-7"
> at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> at java.lang.Integer.parseInt(Integer.java:481)
> at java.lang.Integer.parseInt(Integer.java:514)
> at org.teiid.designer.runtime.version.spi.TeiidServerVersion.isLessThan(TeiidServerVersion.java:285)
> at org.teiid.datatools.connectivity.ConnectivityUtil.getTeiidDriverDefinitionId(ConnectivityUtil.java:100)
> at org.teiid.datatools.connectivity.ConnectivityUtil.createDriverProps(ConnectivityUtil.java:133)
> at org.teiid.datatools.connectivity.ConnectivityUtil.createTransientTeiidProfile(ConnectivityUtil.java:161)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.internalRun(PreviewDataWorker.java:388)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.run(PreviewDataWorker.java:261)
> at org.teiid.designer.runtime.ui.preview.PreviewTableDataContextAction.run(PreviewTableDataContextAction.java:99)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:499)
> GIT commit: https://github.com/Teiid-Designer/teiid-designer/commit/df52ff62ae4ff022c...
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2152) Adding source table with quoted name results in wrong generated SQL statement
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2152?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2152:
-----------------------------------
Component/s: Transformations
> Adding source table with quoted name results in wrong generated SQL statement
> -----------------------------------------------------------------------------
>
> Key: TEIIDDES-2152
> URL: https://issues.jboss.org/browse/TEIIDDES-2152
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Patch Release, Transformations
> Affects Versions: 8.5
> Reporter: Barry LaFond
> Assignee: Paul Richardson
> Fix For: 8.3.4, 8.6, 8.5.1
>
>
> 1) Created source model with simple table named "My.Quoted.Table" (including quotes
> 2) Created simple virtual table and pasted: SELECT * FROM "My.Quoted.Table"
> 3) Parser returned a command resulting in the SQL: SELECT * FROM My.Quoted."Table"
> Parser should be able to handle quoted names properly. In this case the SQL should have been valid as is.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months