Bug 780424 (SOA-2856)

Summary: ModeShape - TranslatorException: Message:Unexpected exception while translating results: Cannot convert String value to long
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Warren Gibson <wgibson>
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED WORKSFORME QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: unspecified   
Target Milestone: ---   
Target Release: 5.2.0 GA   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2856
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Windows and RHEL
Last Closed: 2011-11-30 17:23:28 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Warren Gibson 2011-01-28 22:31:15 UTC 
project_key: SOA

Noticed the following exception in the server log while running ModeShape:

2011-01-28 15:01:10,416 WARN  [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue771) Connector worker process failed for atomic-request=/AGZCpMPhIfs.154.1.154
[TranslatorException] 0: Error Code:0 Message:Unexpected exception while translating results: Cannot convert String value to long
1 [SQLException]Cannot convert String value to long
2 [ValueFormatException]Cannot convert String value to long
	at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:108)
	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)
Caused by: java.sql.SQLException: Cannot convert String value to long
	at org.modeshape.jdbc.JcrResultSet.getValueObject(JcrResultSet.java:1286)
	at org.modeshape.jdbc.JcrResultSet.getValueReturn(JcrResultSet.java:1244)
	at org.modeshape.jdbc.JcrResultSet.getLong(JcrResultSet.java:869)
	at org.modeshape.jdbc.JcrResultSet.getLong(JcrResultSet.java:859)
	at org.jboss.resource.adapter.jdbc.WrappedResultSet.getLong(WrappedResultSet.java:711)
	at org.teiid.translator.jdbc.JDBCExecutionFactory.retrieveValue(JDBCExecutionFactory.java:862)
	at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:101)
	... 13 more
Caused by: javax.jcr.ValueFormatException: Cannot convert String value to long
	at org.modeshape.jcr.JcrValue.createValueFormatException(JcrValue.java:100)
	at org.modeshape.jcr.JcrValue.getLong(JcrValue.java:200)
	at org.modeshape.jdbc.JcrResultSet.getValueObject(JcrResultSet.java:1280)
Comment 1 Van Halbert 2011-05-10 14:18:06 UTC 
It was checked by Warren that the issue is no longer seen.
Comment 2 David Le Sage 2011-09-02 05:46:34 UTC 
Release Notes Docs Status: Added: Not Required
Writer: Added: dlesage
Comment 3 Warren Gibson 2011-11-30 17:23:28 UTC 
11/30/2011 - Issue can not be reproduced.