[JBoss JIRA] Moved: (TEIID-1443) SalesForce connector execution of procedure fails with NPE
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-1443?page=com.atlassian.jira.plugin... ]
Van Halbert moved SOA-2812 to TEIID-1443:
-----------------------------------------
Project: Teiid (was: JBoss Enterprise SOA Platform)
Key: TEIID-1443 (was: SOA-2812)
Affects Version/s: 7.1.1
(was: 5.1.0.ER7)
Component/s: Salesforce Connector
(was: EDS)
Security: (was: Public)
> SalesForce connector execution of procedure fails with NPE
> ----------------------------------------------------------
>
> Key: TEIID-1443
> URL: https://issues.jboss.org/browse/TEIID-1443
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 7.1.1
> Environment: RHEL 5
> Reporter: Paul Nittel
>
> I executed this query from SQuirreL:
> exec sf.salesforce.getupdated('Lead', {ts'2011-01-18 11:42:10.5'}, {ts'2011-01-19 10:42:10.5'})
> And the server burped out this:
> 2011-01-19 10:16:10,805 ERROR [org.teiid.PROCESSOR] (Worker30_QueryProcessorQueue639) Unexpected exception for request cFDOigVAx+GT.9
> java.lang.NullPointerException
> at org.teiid.translator.salesforce.execution.ProcedureExecutionParentImpl.next(ProcedureExecutionParentImpl.java:37)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:281)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:266)
> 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-19 10:16:10,805 ERROR [org.teiid.CONNECTOR] (Worker29_QueryProcessorQueue640)
> java.lang.NullPointerException
> at org.teiid.translator.salesforce.execution.ProcedureExecutionParentImpl.close(ProcedureExecutionParentImpl.java:47)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.close(ConnectorWorkItem.java:146)
> at org.teiid.dqp.internal.process.DataTierTupleSource$5.call(DataTierTupleSource.java:322)
> at org.teiid.dqp.internal.process.DataTierTupleSource$5.call(DataTierTupleSource.java:319)
> 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)
> SQuirreL just reported:
> Error: org.teiid.core.TeiidException
> SQLState: 38000
> ErrorCode: 0
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Updated: (TEIID-1442) clearCache("QUERY_SERVICE_RESULT_SET_CACHE") - in ER7 - totalEntries is not reset to zero
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-1442?page=com.atlassian.jira.plugin... ]
Ramesh Reddy updated TEIID-1442:
--------------------------------
Assignee: Ramesh Reddy
Fix Version/s: 7.1.1
7.3
Affects Version/s: 7.2
Complexity: Low
Component/s: Server
(was: AdminApi)
This only occurs in the "all" profile or any profile with JBoss Cache as distributed cache.
> clearCache("QUERY_SERVICE_RESULT_SET_CACHE") - in ER7 - totalEntries is not reset to zero
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-1442
> URL: https://issues.jboss.org/browse/TEIID-1442
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 7.1.1, 7.2
> Reporter: Len DiMaggio
> Assignee: Ramesh Reddy
> Fix For: 7.1.1, 7.3
>
>
> Regression relative to ER6 - the totalEntries property is not being reset
> groovy:000> connectAsAdmin("mms://localhost:31443", "admin", "admin", "testing")
> ===> null
> groovy:000> getCacheStats("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> hitRatio=0.0; totalEntries=1; requestCount=0
> groovy:000> clearCache("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> null
> groovy:000> getCacheStats("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> hitRatio=0.0; totalEntries=1; requestCount=0
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Resolved: (TEIID-1442) clearCache("QUERY_SERVICE_RESULT_SET_CACHE") - in ER7 - totalEntries is not reset to zero
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-1442?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-1442.
---------------------------------
Resolution: Done
JBC upon clear of cache still keeps the empty nodes with a dummy object around (may be for little while), during this time the size calculations can be wrong. So base the size calculations on the nodes with actual data.
> clearCache("QUERY_SERVICE_RESULT_SET_CACHE") - in ER7 - totalEntries is not reset to zero
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-1442
> URL: https://issues.jboss.org/browse/TEIID-1442
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 7.1.1, 7.2
> Reporter: Len DiMaggio
> Assignee: Ramesh Reddy
> Fix For: 7.1.1, 7.3
>
>
> Regression relative to ER6 - the totalEntries property is not being reset
> groovy:000> connectAsAdmin("mms://localhost:31443", "admin", "admin", "testing")
> ===> null
> groovy:000> getCacheStats("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> hitRatio=0.0; totalEntries=1; requestCount=0
> groovy:000> clearCache("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> null
> groovy:000> getCacheStats("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> hitRatio=0.0; totalEntries=1; requestCount=0
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Moved: (TEIID-1442) clearCache("QUERY_SERVICE_RESULT_SET_CACHE") - in ER7 - totalEntries is not reset to zero
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-1442?page=com.atlassian.jira.plugin... ]
Van Halbert moved SOA-2806 to TEIID-1442:
-----------------------------------------
Project: Teiid (was: JBoss Enterprise SOA Platform)
Key: TEIID-1442 (was: SOA-2806)
Affects Version/s: 7.1.1
(was: 5.1.0.ER7)
Affects Testing: (was: [Regression])
Component/s: AdminApi
(was: EDS)
Security: (was: Public)
> clearCache("QUERY_SERVICE_RESULT_SET_CACHE") - in ER7 - totalEntries is not reset to zero
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-1442
> URL: https://issues.jboss.org/browse/TEIID-1442
> Project: Teiid
> Issue Type: Bug
> Components: AdminApi
> Affects Versions: 7.1.1
> Reporter: Len DiMaggio
>
> Regression relative to ER6 - the totalEntries property is not being reset
> groovy:000> connectAsAdmin("mms://localhost:31443", "admin", "admin", "testing")
> ===> null
> groovy:000> getCacheStats("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> hitRatio=0.0; totalEntries=1; requestCount=0
> groovy:000> clearCache("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> null
> groovy:000> getCacheStats("QUERY_SERVICE_RESULT_SET_CACHE")
> ===> hitRatio=0.0; totalEntries=1; requestCount=0
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Updated: (TEIID-1441) java.lang.NullPointerException - on queries involving lookup (temp table cache does not have buffermanager set on it)
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1441?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-1441:
----------------------------------
Fix Version/s: 7.1.1
7.3
> java.lang.NullPointerException - on queries involving lookup (temp table cache does not have buffermanager set on it)
> ---------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-1441
> URL: https://issues.jboss.org/browse/TEIID-1441
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.1.1
> Reporter: Warren Gibson
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 7.1.1, 7.3
>
>
> The following java.lang.NullPointerException is received in ER7 when running queries involving lookup...example query: SELECT IntKey, lookup('BQT1.MediumA', 'StringKey', 'IntKey', IntKey) AS Y FROM BQT1.MediumA ORDER BY IntKey
> This seems to only happen when running the production profile. I am getting 57 query failures on most if not all sources and the queries involve lookup.
> 2011-01-18 10:00:26,935 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker2_QueryProcessorQueue8) Loading materialized view table #CODE_BQT1.MEDIUMA.INTKEY.STRINGKEY
> 2011-01-18 10:00:27,154 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue8) Unexpected exception for request 0wHCuxdsAg78.0
> java.lang.NullPointerException
> at org.teiid.dqp.internal.process.CachedResults.prepare(CachedResults.java:115)
> at org.teiid.dqp.internal.process.SessionAwareCache.put(SessionAwareCache.java:166)
> at org.teiid.query.tempdata.TempTableDataManager.loadGlobalTable(TempTableDataManager.java:508)
> at org.teiid.query.tempdata.TempTableDataManager.registerQuery(TempTableDataManager.java:410)
> at org.teiid.query.tempdata.TempTableDataManager.lookupCodeValue(TempTableDataManager.java:595)
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:962)
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:633)
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:603)
> at org.teiid.query.processor.relational.ProjectNode.updateTuple(ProjectNode.java:218)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:181)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274)
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:70)
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69)
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:82)
> at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48)
> at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:214)
> at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:168)
> at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:96)
> at org.teiid.query.processor.relational.SortNode.nextBatchDirect(SortNode.java:85)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:107)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:150)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:184)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> 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.runWorker(ThreadPoolExecutor.java:1110)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> at java.lang.Thread.run(Thread.java:636)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Resolved: (TEIID-1441) java.lang.NullPointerException - on queries involving lookup (temp table cache does not have buffermanager set on it)
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1441?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-1441.
-----------------------------------
Assignee: Steven Hawkins (was: Van Halbert)
Resolution: Done
set the buffermanager on the matview distributed cache and ensured that it is sized appropriately
> java.lang.NullPointerException - on queries involving lookup (temp table cache does not have buffermanager set on it)
> ---------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-1441
> URL: https://issues.jboss.org/browse/TEIID-1441
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.1.1
> Reporter: Warren Gibson
> Assignee: Steven Hawkins
> Priority: Blocker
>
> The following java.lang.NullPointerException is received in ER7 when running queries involving lookup...example query: SELECT IntKey, lookup('BQT1.MediumA', 'StringKey', 'IntKey', IntKey) AS Y FROM BQT1.MediumA ORDER BY IntKey
> This seems to only happen when running the production profile. I am getting 57 query failures on most if not all sources and the queries involve lookup.
> 2011-01-18 10:00:26,935 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker2_QueryProcessorQueue8) Loading materialized view table #CODE_BQT1.MEDIUMA.INTKEY.STRINGKEY
> 2011-01-18 10:00:27,154 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue8) Unexpected exception for request 0wHCuxdsAg78.0
> java.lang.NullPointerException
> at org.teiid.dqp.internal.process.CachedResults.prepare(CachedResults.java:115)
> at org.teiid.dqp.internal.process.SessionAwareCache.put(SessionAwareCache.java:166)
> at org.teiid.query.tempdata.TempTableDataManager.loadGlobalTable(TempTableDataManager.java:508)
> at org.teiid.query.tempdata.TempTableDataManager.registerQuery(TempTableDataManager.java:410)
> at org.teiid.query.tempdata.TempTableDataManager.lookupCodeValue(TempTableDataManager.java:595)
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:962)
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:633)
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:603)
> at org.teiid.query.processor.relational.ProjectNode.updateTuple(ProjectNode.java:218)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:181)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274)
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:70)
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69)
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:82)
> at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48)
> at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:214)
> at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:168)
> at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:96)
> at org.teiid.query.processor.relational.SortNode.nextBatchDirect(SortNode.java:85)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:107)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:150)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:184)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> 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.runWorker(ThreadPoolExecutor.java:1110)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> at java.lang.Thread.run(Thread.java:636)
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[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.
-----------------------------------
Resolution: Done
Fixing the previous issue, brought forth this one. The metatype key was different than what the wrap/unwrap methods were using for id.
> 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
15 years, 2 months