[JBoss JIRA] (TEIIDDES-1515) Cannot set ROW_NUMBER() on Transformation Editor
by Rich Lucente (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1515?page=com.atlassian.jira.plu... ]
Rich Lucente commented on TEIIDDES-1515:
----------------------------------------
I'm running into this problem using Teiid Designer 8.5.0.Final-v20140616-1350-B2658 in JBoss Developer Studio 7.1.1. I'm importing the attached file as a flat file source and attempting to use the following transformation:
{code}
SELECT
ROW_NUMBER() OVER (ORDER BY A.state) AS id, A.name, A.state, A.gender, A.birthyear, A.occurrences
FROM
(EXEC file_source.getTextFiles('VA.TXT')) AS f, TEXTTABLE(f.file COLUMNS state string, gender char, birthyear integer, name string, occurrences integer) AS A
{code}
When I save, "ROW_NUMBER()" is removed from the editor and a SQL parsing error occurs.
> Cannot set ROW_NUMBER() on Transformation Editor
> ------------------------------------------------
>
> Key: TEIIDDES-1515
> URL: https://issues.jboss.org/browse/TEIIDDES-1515
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Editors
> Affects Versions: 7.7.1, 7.8, 7.7.4
> Environment: JBDS 5.0.1
> Reporter: Eiichi Nagai
> Assignee: Johnathon Lee
> Fix For: 8.2, 7.7.5
>
>
> ROW_NUMBER is supported by Teiid[1]. However, it cannot set the ROW_NUMBER function using the Transformation Editor.
> [1] http://docs.jboss.org/teiid/7.7.0.Final/reference/en-US/html/sql_support....
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months
[JBoss JIRA] (TEIIDDES-2267) JNDI Name selection on VDB Explorer does not function on Windows
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2267?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-2267:
----------------------------------------
Yes, it is VDB Editor in Source Bindings Panel
1) Yes server is started state. Whether it was opened before or after I do not remember, and it should not matter for user experience.
2) There was only single server configuration, so I do not know. As user I started the server, and expected that to work. If there are multiple servers in started state that *may* apply, even that I would assume user should be given choice at the start time of server 2 ..n to make that selection.
> JNDI Name selection on VDB Explorer does not function on Windows
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2267
> URL: https://issues.jboss.org/browse/TEIIDDES-2267
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Dialogs
> Affects Versions: 8.3
> Reporter: Ramesh Reddy
>
> When working on windows, the JNDI name selection on VDB explorer's Source Bindings dialog does not show dropdown when server is started. Also it is very hard to click on it to edit, as it does not even show the text box, it behaves more like label. But sometime repeated clicking or tabbing suddenly lets you edit.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months
[JBoss JIRA] (TEIIDDES-2267) JNDI Name selection on VDB Explorer does not function on Windows
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2267?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2267:
----------------------------------------
Do you mean VDB Editor rather than VDB explorer? so it'd be the Source Bindings Definition Panel rather than dialog?
1) Was the server started before the VDB Editor was opened?
2) Was the "Default Server" changed to the running server?
> JNDI Name selection on VDB Explorer does not function on Windows
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2267
> URL: https://issues.jboss.org/browse/TEIIDDES-2267
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Dialogs
> Affects Versions: 8.3
> Reporter: Ramesh Reddy
>
> When working on windows, the JNDI name selection on VDB explorer's Source Bindings dialog does not show dropdown when server is started. Also it is very hard to click on it to edit, as it does not even show the text box, it behaves more like label. But sometime repeated clicking or tabbing suddenly lets you edit.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months
[JBoss JIRA] (TEIIDDES-2268) NPE An internal error occurred during: "Loading Core provider".
by Greg MacKinnon (JIRA)
Greg MacKinnon created TEIIDDES-2268:
----------------------------------------
Summary: NPE An internal error occurred during: "Loading Core provider".
Key: TEIIDDES-2268
URL: https://issues.jboss.org/browse/TEIIDDES-2268
Project: Teiid Designer
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Datatools Integration
Affects Versions: 8.5, 8.6
Environment: windows 7, eclipse kepler 4.3.2, teiid designer 8.5/8.6
Reporter: Greg MacKinnon
Here is a representative stack trace. This had been observed in teiid designer 8.5. I fetched the 8.6 teiid designer code, built and installed in on eclipse to workaround an AuthenticationType issue and have observed this NPE there as well.
!ENTRY org.eclipse.core.jobs 4 2 2014-07-24 15:34:22.685
!MESSAGE An internal error occurred during: "Loading Core provider".
!STACK 0
java.lang.NullPointerException
at org.eclipse.datatools.connectivity.sqm.internal.core.definition.isAuthorizationIdentifierSupported(DatabaseDefinitionImpl.java:2014)
at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.vnode.ServerExplorerVNodeContentProviderNav.displayDatabaseChildren(ServerExplorerVNodeContentProviderNav.java:391)
at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.AbstractOnDemandContentProviderNav.getChildren(AbstractOnDemandContentProviderNav.java:116)
at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.AbstractOnDemandContentProviderNav.getChildren(AbstractOnDemandContentProviderNav.java:239)
at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.AbstractLayoutProviderNav.getChildren(AbstractLayoutProviderNav.java:85)
at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.impl.ServerExplorerContentProviderNav.load(ServerExplorerContentProviderNav.java:153)
at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.loading.LoadingJob.run(LoadingJob.java:43)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
This occurs right after a call is made to load the definition.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months
[JBoss JIRA] (TEIIDDES-2267) JNDI Name selection on VDB Explorer does not function on Windows
by Ramesh Reddy (JIRA)
Ramesh Reddy created TEIIDDES-2267:
--------------------------------------
Summary: JNDI Name selection on VDB Explorer does not function on Windows
Key: TEIIDDES-2267
URL: https://issues.jboss.org/browse/TEIIDDES-2267
Project: Teiid Designer
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Dialogs
Affects Versions: 8.3
Reporter: Ramesh Reddy
When working on windows, the JNDI name selection on VDB explorer's Source Bindings dialog does not show dropdown when server is started. Also it is very hard to click on it to edit, as it does not even show the text box, it behaves more like label. But sometime repeated clicking or tabbing suddenly lets you edit.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months
[JBoss JIRA] (TEIIDDES-2229) Merge various fixes from master into 8.5.1
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2229?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2229:
-----------------------------------
Description:
*Candidates*
* TEIIDDES-1829 - Add Dynamic Parameter Capability to REST Connection Profile
* TEIIDDES-2188 Move the REST Importer out of the XML Importer and into a Separate Importer Option]
* TEIIDDES-2190 - Update the Generated Transformation for REST to Support Dynamic Parameters
* TEIIDDES-2218 JBossWS-CXF/RestEasy WAR menu options are impl specific
* TEIIDDES-2224 web service returns 500 when concurrent access
* TEIIDDES-2245 - Error Assigning WS CP to source model
*Completed Upstream*
TEIIDDES-#### <title>
*Merged*
* TEIIDDES-2110 Update 8.5 Documentation
* TEIIDDES-2120 unable to reference same name .xsd when saving .vdb
* TEIIDDES-2150 JBDS keeps selecting all operations in "Create relational model from WS" dialogue
* TEIIDDES-2151 Create relational model from WS (SOAP) using default procedures generates both models in one subdirectory
* TEIIDDES-2179 Teiid connection importer choice of dynamic-vdb name needs to be unique
* TEIIDDES-2198 Virtual procedure transformation not revalidated after changing parameter datatype
* TEIIDDES-2203 Deletion of invalid (columnless) models causes NPE
* TEIIDDES-2205 Remove table name error validation for names that include '.' delimiter
* TEIIDDES-2208 Column layout issue in RelationalEditorPanel
* TEIIDDES-2212 Virtual procedures with function == TRUE still validates SQL transformations
* TEIIDDES-2216 TEIID30181 HEADER entry missing for column name id in Unknown
* TEIIDDES-2227 After deleting connection profile, action Guides -> Generate relational models from WSDL throws an exception
* TEIIDDES-2228 Action "Generate relational models from WSDL(Guides)" ignores preselected Connection profile
* TEIIDDES-2235 Preview uses Pool Name instead of JNDI name
* TEIIDDES-2236 An error occurred while attempting to analyse the teiid instance's translator: salesforce
* TEIIDDES-2240 Handling of fixed-length datatypes is not handled consistently
* TEIIDDES-2242 If default Teiid runtime is set to version < 8.0 check VDB and warn user if VDB was created for >= 8.0
* TEIIDDES-2254 rename View Model causes issues
* TEIIDDES-2257 Create VDB DataSource Dialog Enhancements
* TEIIDDES-2260 Teiid Designer doesn't clean up vdb.xml properly (Data Roles - conditions)
* TEIIDDES-2266 Unexpected internal error near index 1 on Windows
was:
*Candidates*
TEIIDDES-2224 web service returns 500 when concurrent access
TEIIDDES-2218 JBossWS-CXF/RestEasy WAR menu options are impl specific
TEIIDDES-2188 Move the REST Importer out of the XML Importer and into a Separate Importer Option]
TEIIDDES-1829 - Add Dynamic Parameter Capability to REST Connection Profile
TEIIDDES-2190 - Update the Generated Transformation for REST to Support Dynamic Parameters
TEIIDDES-2245 - Error Assigning WS CP to source model
*Completed Upstream*
TEIIDDES-#### <title>
*Merged*
* TEIIDDES-2266 Unexpected internal error near index 1 on Windows
> Merge various fixes from master into 8.5.1
> ------------------------------------------
>
> Key: TEIIDDES-2229
> URL: https://issues.jboss.org/browse/TEIIDDES-2229
> Project: Teiid Designer
> Issue Type: Task
> Security Level: Public(Everyone can see)
> Affects Versions: 8.5.1
> Reporter: Ted Jones
> Assignee: Johnathon Lee
> Priority: Blocker
> Fix For: 8.5.1
>
>
> *Candidates*
> * TEIIDDES-1829 - Add Dynamic Parameter Capability to REST Connection Profile
> * TEIIDDES-2188 Move the REST Importer out of the XML Importer and into a Separate Importer Option]
> * TEIIDDES-2190 - Update the Generated Transformation for REST to Support Dynamic Parameters
> * TEIIDDES-2218 JBossWS-CXF/RestEasy WAR menu options are impl specific
> * TEIIDDES-2224 web service returns 500 when concurrent access
> * TEIIDDES-2245 - Error Assigning WS CP to source model
> *Completed Upstream*
> TEIIDDES-#### <title>
> *Merged*
> * TEIIDDES-2110 Update 8.5 Documentation
> * TEIIDDES-2120 unable to reference same name .xsd when saving .vdb
> * TEIIDDES-2150 JBDS keeps selecting all operations in "Create relational model from WS" dialogue
> * TEIIDDES-2151 Create relational model from WS (SOAP) using default procedures generates both models in one subdirectory
> * TEIIDDES-2179 Teiid connection importer choice of dynamic-vdb name needs to be unique
> * TEIIDDES-2198 Virtual procedure transformation not revalidated after changing parameter datatype
> * TEIIDDES-2203 Deletion of invalid (columnless) models causes NPE
> * TEIIDDES-2205 Remove table name error validation for names that include '.' delimiter
> * TEIIDDES-2208 Column layout issue in RelationalEditorPanel
> * TEIIDDES-2212 Virtual procedures with function == TRUE still validates SQL transformations
> * TEIIDDES-2216 TEIID30181 HEADER entry missing for column name id in Unknown
> * TEIIDDES-2227 After deleting connection profile, action Guides -> Generate relational models from WSDL throws an exception
> * TEIIDDES-2228 Action "Generate relational models from WSDL(Guides)" ignores preselected Connection profile
> * TEIIDDES-2235 Preview uses Pool Name instead of JNDI name
> * TEIIDDES-2236 An error occurred while attempting to analyse the teiid instance's translator: salesforce
> * TEIIDDES-2240 Handling of fixed-length datatypes is not handled consistently
> * TEIIDDES-2242 If default Teiid runtime is set to version < 8.0 check VDB and warn user if VDB was created for >= 8.0
> * TEIIDDES-2254 rename View Model causes issues
> * TEIIDDES-2257 Create VDB DataSource Dialog Enhancements
> * TEIIDDES-2260 Teiid Designer doesn't clean up vdb.xml properly (Data Roles - conditions)
> * TEIIDDES-2266 Unexpected internal error near index 1 on Windows
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months
[JBoss JIRA] (TEIIDDES-2229) Merge various fixes from master into 8.5.1
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2229?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2229:
-----------------------------------
Description:
*Candidates*
TEIIDDES-2224 web service returns 500 when concurrent access
TEIIDDES-2218 JBossWS-CXF/RestEasy WAR menu options are impl specific
TEIIDDES-2188 Move the REST Importer out of the XML Importer and into a Separate Importer Option]
TEIIDDES-1829 - Add Dynamic Parameter Capability to REST Connection Profile
TEIIDDES-2190 - Update the Generated Transformation for REST to Support Dynamic Parameters
TEIIDDES-2245 - Error Assigning WS CP to source model
*Completed Upstream*
TEIIDDES-#### <title>
*Merged*
* TEIIDDES-2266 Unexpected internal error near index 1 on Windows
was:
*Candidates*
TEIIDDES-2224 web service returns 500 when concurrent access
TEIIDDES-2218 JBossWS-CXF/RestEasy WAR menu options are impl specific
TEIIDDES-2188 Move the REST Importer out of the XML Importer and into a Separate Importer Option]
TEIIDDES-1829 - Add Dynamic Parameter Capability to REST Connection Profile
TEIIDDES-2190 - Update the Generated Transformation for REST to Support Dynamic Parameters
TEIIDDES-2245 - Error Assigning WS CP to source model
*Completed Upstream*
TEIIDDES-#### <title>
> Merge various fixes from master into 8.5.1
> ------------------------------------------
>
> Key: TEIIDDES-2229
> URL: https://issues.jboss.org/browse/TEIIDDES-2229
> Project: Teiid Designer
> Issue Type: Task
> Security Level: Public(Everyone can see)
> Affects Versions: 8.5.1
> Reporter: Ted Jones
> Assignee: Johnathon Lee
> Priority: Blocker
> Fix For: 8.5.1
>
>
> *Candidates*
> TEIIDDES-2224 web service returns 500 when concurrent access
> TEIIDDES-2218 JBossWS-CXF/RestEasy WAR menu options are impl specific
> TEIIDDES-2188 Move the REST Importer out of the XML Importer and into a Separate Importer Option]
> TEIIDDES-1829 - Add Dynamic Parameter Capability to REST Connection Profile
> TEIIDDES-2190 - Update the Generated Transformation for REST to Support Dynamic Parameters
> TEIIDDES-2245 - Error Assigning WS CP to source model
> *Completed Upstream*
> TEIIDDES-#### <title>
> *Merged*
> * TEIIDDES-2266 Unexpected internal error near index 1 on Windows
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months
[JBoss JIRA] (TEIIDDES-2266) Unexpected internal error near index 1 on Windows
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2266?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2266:
----------------------------------------
Tested and merged into 8.3.x, 8.5.x and master
> Unexpected internal error near index 1 on Windows
> -------------------------------------------------
>
> Key: TEIIDDES-2266
> URL: https://issues.jboss.org/browse/TEIIDDES-2266
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Modeling, Patch Release
> Affects Versions: 8.5, 8.3.3
> Reporter: Hisanobu Okuda
> Assignee: Barry LaFond
> Fix For: 8.3.4, 8.6, 8.5.1
>
>
> When trying to rename project name (Right-click -> Refactor -> Rename) I see the following error. This seems to prevent me from renaming any file:
> Unexpected internal error near index 1
> It is reproduced on only Windows. and not occurs on Linux
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 9 months