[JBoss JIRA] Resolved: (TEIID-1420) Adminshell getTransactions() fails - exception = org.teiid.adminapi.AdminComponentException:
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1420?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-1420.
-----------------------------------
Fix Version/s: 7.1.1
7.3
Resolution: Done
Fixed by changing associateSession to a string. This will require both a server and client side patch to work with 7.2. The expectation is that 7.3 will be used instead.
> Adminshell getTransactions() fails - exception = org.teiid.adminapi.AdminComponentException:
> --------------------------------------------------------------------------------------------
>
> Key: TEIID-1420
> URL: https://issues.jboss.org/browse/TEIID-1420
> Project: Teiid
> Issue Type: Bug
> Components: AdminApi
> Affects Versions: 7.1.1
> Reporter: Len DiMaggio
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 7.1.1, 7.3
>
>
> With no transaction active - the method returns:
> groovy:000> getTransactions()
> ===> []
> With a transaction open:
> groovy:000> getTransactions()
> ERROR org.teiid.adminapi.AdminComponentException:
> Failed to invoke method 'getTransactions' on component 'RuntimeEngineDeployer' with parameters [].
> at org.teiid.client.util.ExceptionUtil.convertException (ExceptionUtil.java:72)
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke (SocketServerInstanceImpl.java:365)
> at org.teiid.net.socket.SocketServerConnection$1.invoke (SocketServerConnection.java:216)
> at $Proxy7.getTransactions (Unknown Source)
> at org.teiid.adminapi.AdminFactory$AdminProxy.invoke (AdminFactory.java:75)
> at $Proxy7.getTransactions (Unknown Source)
> at org.teiid.adminshell.AdminShell.getTransactions (AdminShell.java:212)
> at org.teiid.adminshell.AdminShell$getTransactions.callStatic (Unknown Source)
> at groovysh_evaluate.run (groovysh_evaluate:3)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 4 months
[JBoss JIRA] Commented: (TEIID-1420) Adminshell getTransactions() fails - exception = org.teiid.adminapi.AdminComponentException:
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-1420?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-1420:
-------------------------------------
we can fix in 7.1.1 and 7.3. Since 7.3 is coming up soon IMO 7.2 should not be an issue other than the compatibility.
> Adminshell getTransactions() fails - exception = org.teiid.adminapi.AdminComponentException:
> --------------------------------------------------------------------------------------------
>
> Key: TEIID-1420
> URL: https://issues.jboss.org/browse/TEIID-1420
> Project: Teiid
> Issue Type: Bug
> Components: AdminApi
> Affects Versions: 7.1.1
> Reporter: Len DiMaggio
> Assignee: Steven Hawkins
> Priority: Critical
>
> With no transaction active - the method returns:
> groovy:000> getTransactions()
> ===> []
> With a transaction open:
> groovy:000> getTransactions()
> ERROR org.teiid.adminapi.AdminComponentException:
> Failed to invoke method 'getTransactions' on component 'RuntimeEngineDeployer' with parameters [].
> at org.teiid.client.util.ExceptionUtil.convertException (ExceptionUtil.java:72)
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke (SocketServerInstanceImpl.java:365)
> at org.teiid.net.socket.SocketServerConnection$1.invoke (SocketServerConnection.java:216)
> at $Proxy7.getTransactions (Unknown Source)
> at org.teiid.adminapi.AdminFactory$AdminProxy.invoke (AdminFactory.java:75)
> at $Proxy7.getTransactions (Unknown Source)
> at org.teiid.adminshell.AdminShell.getTransactions (AdminShell.java:212)
> at org.teiid.adminshell.AdminShell$getTransactions.callStatic (Unknown Source)
> at groovysh_evaluate.run (groovysh_evaluate:3)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 4 months
[JBoss JIRA] Commented: (TEIID-1420) Adminshell getTransactions() fails - exception = org.teiid.adminapi.AdminComponentException:
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1420?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-1420:
---------------------------------------
This appears to be a hold over from the conversion back to string based session identifiers. The transaction metadata object is expecting the session to be a long. I'm in favor of letting the fix break the contract of Transaction and changing the type of assicatedSession to string. However if we want to let 7.2 "work", which would require a 7.2 server patch but would leave 7.2 without meaningful session information for a transaction, then we'd need to introduce a new field instead.
> Adminshell getTransactions() fails - exception = org.teiid.adminapi.AdminComponentException:
> --------------------------------------------------------------------------------------------
>
> Key: TEIID-1420
> URL: https://issues.jboss.org/browse/TEIID-1420
> Project: Teiid
> Issue Type: Bug
> Components: AdminApi
> Affects Versions: 7.1.1
> Reporter: Len DiMaggio
> Assignee: Steven Hawkins
> Priority: Critical
>
> With no transaction active - the method returns:
> groovy:000> getTransactions()
> ===> []
> With a transaction open:
> groovy:000> getTransactions()
> ERROR org.teiid.adminapi.AdminComponentException:
> Failed to invoke method 'getTransactions' on component 'RuntimeEngineDeployer' with parameters [].
> at org.teiid.client.util.ExceptionUtil.convertException (ExceptionUtil.java:72)
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke (SocketServerInstanceImpl.java:365)
> at org.teiid.net.socket.SocketServerConnection$1.invoke (SocketServerConnection.java:216)
> at $Proxy7.getTransactions (Unknown Source)
> at org.teiid.adminapi.AdminFactory$AdminProxy.invoke (AdminFactory.java:75)
> at $Proxy7.getTransactions (Unknown Source)
> at org.teiid.adminshell.AdminShell.getTransactions (AdminShell.java:212)
> at org.teiid.adminshell.AdminShell$getTransactions.callStatic (Unknown Source)
> at groovysh_evaluate.run (groovysh_evaluate:3)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 4 months
[JBoss JIRA] Assigned: (TEIID-1420) Adminshell getTransactions() fails - exception = org.teiid.adminapi.AdminComponentException:
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1420?page=com.atlassian.jira.plugin... ]
Steven Hawkins reassigned TEIID-1420:
-------------------------------------
Assignee: Steven Hawkins
> Adminshell getTransactions() fails - exception = org.teiid.adminapi.AdminComponentException:
> --------------------------------------------------------------------------------------------
>
> Key: TEIID-1420
> URL: https://issues.jboss.org/browse/TEIID-1420
> Project: Teiid
> Issue Type: Bug
> Components: AdminApi
> Affects Versions: 7.1.1
> Reporter: Len DiMaggio
> Assignee: Steven Hawkins
> Priority: Critical
>
> With no transaction active - the method returns:
> groovy:000> getTransactions()
> ===> []
> With a transaction open:
> groovy:000> getTransactions()
> ERROR org.teiid.adminapi.AdminComponentException:
> Failed to invoke method 'getTransactions' on component 'RuntimeEngineDeployer' with parameters [].
> at org.teiid.client.util.ExceptionUtil.convertException (ExceptionUtil.java:72)
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke (SocketServerInstanceImpl.java:365)
> at org.teiid.net.socket.SocketServerConnection$1.invoke (SocketServerConnection.java:216)
> at $Proxy7.getTransactions (Unknown Source)
> at org.teiid.adminapi.AdminFactory$AdminProxy.invoke (AdminFactory.java:75)
> at $Proxy7.getTransactions (Unknown Source)
> at org.teiid.adminshell.AdminShell.getTransactions (AdminShell.java:212)
> at org.teiid.adminshell.AdminShell$getTransactions.callStatic (Unknown Source)
> at groovysh_evaluate.run (groovysh_evaluate:3)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 4 months
[JBoss JIRA] Moved: (TEIID-1420) Adminshell getTransactions() fails - exception = org.teiid.adminapi.AdminComponentException:
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-1420?page=com.atlassian.jira.plugin... ]
Van Halbert moved SOA-2741 to TEIID-1420:
-----------------------------------------
Project: Teiid (was: JBoss Enterprise SOA Platform)
Key: TEIID-1420 (was: SOA-2741)
Affects Version/s: 7.1.1
(was: 5.1.0.ER6)
Component/s: AdminApi
(was: EDS)
Security: (was: Public)
> Adminshell getTransactions() fails - exception = org.teiid.adminapi.AdminComponentException:
> --------------------------------------------------------------------------------------------
>
> Key: TEIID-1420
> URL: https://issues.jboss.org/browse/TEIID-1420
> Project: Teiid
> Issue Type: Bug
> Components: AdminApi
> Affects Versions: 7.1.1
> Reporter: Len DiMaggio
> Priority: Critical
>
> With no transaction active - the method returns:
> groovy:000> getTransactions()
> ===> []
> With a transaction open:
> groovy:000> getTransactions()
> ERROR org.teiid.adminapi.AdminComponentException:
> Failed to invoke method 'getTransactions' on component 'RuntimeEngineDeployer' with parameters [].
> at org.teiid.client.util.ExceptionUtil.convertException (ExceptionUtil.java:72)
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke (SocketServerInstanceImpl.java:365)
> at org.teiid.net.socket.SocketServerConnection$1.invoke (SocketServerConnection.java:216)
> at $Proxy7.getTransactions (Unknown Source)
> at org.teiid.adminapi.AdminFactory$AdminProxy.invoke (AdminFactory.java:75)
> at $Proxy7.getTransactions (Unknown Source)
> at org.teiid.adminshell.AdminShell.getTransactions (AdminShell.java:212)
> at org.teiid.adminshell.AdminShell$getTransactions.callStatic (Unknown Source)
> at groovysh_evaluate.run (groovysh_evaluate:3)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 4 months
[JBoss JIRA] Created: (TEIID-1419) Metadata loaded incorrectly
by Van Halbert (JIRA)
Metadata loaded incorrectly
---------------------------
Key: TEIID-1419
URL: https://issues.jboss.org/browse/TEIID-1419
Project: Teiid
Issue Type: Bug
Components: Server
Affects Versions: 7.1.1
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Blocker
Fix For: 7.1.1, 7.3
The index metadata load uses a match filter of type|*name.*|* to load tables for a given schema name. The leading * causes all schemas that have the same suffix to add their tables. In the case shown on the forum link, views were injected into a physical model which caused a recursive query and a stack overflow.
The fix is simply to change the match pattern to type|name.*|*
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 4 months
[JBoss JIRA] Created: (TEIID-1415) Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismatched character ' ' expecting ':'
by Van Halbert (JIRA)
Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismatched character ' ' expecting ':'
-------------------------------------------------------------------------------------------------------------
Key: TEIID-1415
URL: https://issues.jboss.org/browse/TEIID-1415
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: John Doyle
Fix For: 7.1.1, 7.3
As part of testing the SalesForce connector, I executed the following query:
Select Subject, ClosedDate from Case_ where ClosedDate > {ts'2003-03-11 11:42:10.5'}
and got back:
Error: Remote org.teiid.core.TeiidProcessingException: MALFORMED_QUERY:
> 2003-03-11T11:42:10.500Z-05:00 LIMIT 100
^
ERROR at Row:1:Column:101
line 1:101 mismatched character ' ' expecting ':'
A more complete stack trace is attached.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 4 months
[JBoss JIRA] Updated: (TEIID-1414) Execution of a Prepared Statement may receive LanguageBridgeFactory AssertionError
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1414?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-1414:
----------------------------------
Fix Version/s: 7.1.1
7.3
Component/s: Query Engine
(was: JDBC Driver)
(was: Server)
> Execution of a Prepared Statement may receive LanguageBridgeFactory AssertionError
> ----------------------------------------------------------------------------------
>
> Key: TEIID-1414
> URL: https://issues.jboss.org/browse/TEIID-1414
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.1.1
> Reporter: Paul Nittel
> Fix For: 7.1.1, 7.3
>
>
> I'm testing Prepared Statements and have a query that executes through SQuirreL as a non-prepared statement and fails with an assertion error when I run it through a Java application. Here's the SQL:
> SELECT PART_NAME FROM PARTS WHERE PARTS.PART_ID IN
> (SELECT SUPPLIER_PARTS.PART_ID FROM SUPPLIER_PARTS WHERE (SUPPLIER_PARTS.SUPPLIER_ID = 'S100')
> AND (LEFT(SUPPLIER_PARTS.SUPPLIER_ID, 1) != LEFT(PARTS.PART_COLOR, 1)))
> stmt = conn.prepareStatement("SELECT PART_NAME FROM PARTS WHERE PARTS.PART_ID IN "
> + "(SELECT SUPPLIER_PARTS.PART_ID FROM SUPPLIER_PARTS WHERE (SUPPLIER_PARTS.SUPPLIER_ID = ?) "
> + "AND (LEFT(SUPPLIER_PARTS.SUPPLIER_ID, 1) != LEFT(PARTS.PART_COLOR, 1))) ");
> 2011-01-03 14:30:22,515 ERROR [org.teiid.CONNECTOR] (Worker33_QueryProcessorQueue1000) Connector worker process failed for atomic-request=mQaVUbKNtiIi.20.2.219
> java.lang.AssertionError
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:459)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:311)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:266)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:319)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:268)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:207)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:149)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:399)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:282)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:207)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:130)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:213)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281)
> at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120)
> at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> 2011-01-03 14:30:22,524 WARN [org.teiid.PROCESSOR] (Worker34_QueryProcessorQueue1001) Processing exception 'null' for request mQaVUbKNtiIi.20. Exception type org.teiid.core.TeiidProcessingException thrown from org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:459). Enable more detailed logging to see the entire stacktrace.
> [Steve indicated this is the result of skipping the final rewrite of pushed subqueries.]
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 4 months
[JBoss JIRA] Resolved: (TEIID-1414) Execution of a Prepared Statement may receive LanguageBridgeFactory AssertionError
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1414?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-1414.
-----------------------------------
Resolution: Done
Updated the rewrite logic to force a final rewrite of subqueries.
> Execution of a Prepared Statement may receive LanguageBridgeFactory AssertionError
> ----------------------------------------------------------------------------------
>
> Key: TEIID-1414
> URL: https://issues.jboss.org/browse/TEIID-1414
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Driver, Server
> Affects Versions: 7.1.1
> Reporter: Paul Nittel
>
> I'm testing Prepared Statements and have a query that executes through SQuirreL as a non-prepared statement and fails with an assertion error when I run it through a Java application. Here's the SQL:
> SELECT PART_NAME FROM PARTS WHERE PARTS.PART_ID IN
> (SELECT SUPPLIER_PARTS.PART_ID FROM SUPPLIER_PARTS WHERE (SUPPLIER_PARTS.SUPPLIER_ID = 'S100')
> AND (LEFT(SUPPLIER_PARTS.SUPPLIER_ID, 1) != LEFT(PARTS.PART_COLOR, 1)))
> stmt = conn.prepareStatement("SELECT PART_NAME FROM PARTS WHERE PARTS.PART_ID IN "
> + "(SELECT SUPPLIER_PARTS.PART_ID FROM SUPPLIER_PARTS WHERE (SUPPLIER_PARTS.SUPPLIER_ID = ?) "
> + "AND (LEFT(SUPPLIER_PARTS.SUPPLIER_ID, 1) != LEFT(PARTS.PART_COLOR, 1))) ");
> 2011-01-03 14:30:22,515 ERROR [org.teiid.CONNECTOR] (Worker33_QueryProcessorQueue1000) Connector worker process failed for atomic-request=mQaVUbKNtiIi.20.2.219
> java.lang.AssertionError
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:459)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:311)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:266)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:319)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:268)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:207)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:149)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:399)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:282)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:207)
> at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:130)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:213)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281)
> at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120)
> at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> 2011-01-03 14:30:22,524 WARN [org.teiid.PROCESSOR] (Worker34_QueryProcessorQueue1001) Processing exception 'null' for request mQaVUbKNtiIi.20. Exception type org.teiid.core.TeiidProcessingException thrown from org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:459). Enable more detailed logging to see the entire stacktrace.
> [Steve indicated this is the result of skipping the final rewrite of pushed subqueries.]
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 4 months