[JBoss JIRA] (TEIID-1853) Salesforce Translator doesnt handle Time types
by Van Halbert (Created) (JIRA)
Salesforce Translator doesnt handle Time types
----------------------------------------------
Key: TEIID-1853
URL: https://issues.jboss.org/browse/TEIID-1853
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.6
Reporter: Mark Drilling
Assignee: Steven Hawkins
Query the BusinessHours table imported from Salesforce, which contains columns with 'time' datatype.
For example, the query:
SELECT Name,CreatedDate,MondayStartTime FROM SFTest.salesforce.BusinessHours
Results in:
Error Code:ERR.003.029.0025 Message:Failed to transform String to Time. Expected format = hh:mm:ss for 08:00:00.000Z
It looks like the code in QueryExecutionImpl.getCellDatum needs to handle translation of the salesforce time format
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 4 months
[JBoss JIRA] (TEIID-1847) Salesforce connector does not report UnexpectedErrorFault exceptions correctly when calling getUpdated
by Steven Hawkins (Updated) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1847?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-1847:
----------------------------------
Issue Type: Quality Risk (was: Bug)
Fix Version/s: 8.0
Priority: Minor (was: Major)
Affects Version/s: 6.0.0
Complexity: Low
We'll look at unwrapping the ApiFaults rather than just wrapping with resource exceptions.
> Salesforce connector does not report UnexpectedErrorFault exceptions correctly when calling getUpdated
> ------------------------------------------------------------------------------------------------------
>
> Key: TEIID-1847
> URL: https://issues.jboss.org/browse/TEIID-1847
> Project: Teiid
> Issue Type: Quality Risk
> Components: Salesforce Connector
> Affects Versions: 6.0.0
> Reporter: Marc Shirley
> Priority: Minor
> Labels: salesforce
> Fix For: 8.0
>
>
> When encountering an UnexpectedErrorFault with com.sforce.soap.partner.SoapBindingStub.GetUpdated(), com.metamatrix.connector.salesforce.connection.SalesforceConnection.getUpdated() throws a null error message instead of the message returned from Salesforce. It appears that the getUpdated() method is using java.rmi.RemoteException.getMessage() when it should be using SFDC com.sforce.soap.partner.fault.ApiFault.getExceptionMessage() for "UnexpectedErrorFault" exceptions. Associated stack trace below.
> [Salesforce Connector_1246|9725_Worker_106|0] ERROR <CONNECTOR|0> Connector worker process failed for atomic-request=5707647.13.7.333713
> ConnectorException: Status ERROR: com.metamatrix.core code=0 null
> at com.metamatrix.connector.salesforce.connection.SalesforceConnection.getUpdated(SalesforceConnection.java:737)
> at com.metamatrix.connector.salesforce.execution.GetUpdatedExecutionImpl.execute(GetUpdatedExecutionImpl.java:65)
> at com.metamatrix.connector.salesforce.execution.ProcedureExecutionParentImpl.execute(ProcedureExecutionParentImpl.java:86)
> at com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorker.processNewRequest(ConnectorWorker.java:275)
> at com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorker.process(ConnectorWorker.java:141)
> at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:64)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 4 months
[JBoss JIRA] (TEIID-1847) Salesforce connector does not report UnexpectedErrorFault exceptions correctly when calling getUpdated
by Van Halbert (Commented) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1847?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-1847:
------------------------------------
No, but looking at similar logic in Teiid, GetUpdatedExecutionImpl, its handling the exception in the same manner that's at issue in 5.5.4.
> Salesforce connector does not report UnexpectedErrorFault exceptions correctly when calling getUpdated
> ------------------------------------------------------------------------------------------------------
>
> Key: TEIID-1847
> URL: https://issues.jboss.org/browse/TEIID-1847
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Reporter: Marc Shirley
> Labels: salesforce
>
> When encountering an UnexpectedErrorFault with com.sforce.soap.partner.SoapBindingStub.GetUpdated(), com.metamatrix.connector.salesforce.connection.SalesforceConnection.getUpdated() throws a null error message instead of the message returned from Salesforce. It appears that the getUpdated() method is using java.rmi.RemoteException.getMessage() when it should be using SFDC com.sforce.soap.partner.fault.ApiFault.getExceptionMessage() for "UnexpectedErrorFault" exceptions. Associated stack trace below.
> [Salesforce Connector_1246|9725_Worker_106|0] ERROR <CONNECTOR|0> Connector worker process failed for atomic-request=5707647.13.7.333713
> ConnectorException: Status ERROR: com.metamatrix.core code=0 null
> at com.metamatrix.connector.salesforce.connection.SalesforceConnection.getUpdated(SalesforceConnection.java:737)
> at com.metamatrix.connector.salesforce.execution.GetUpdatedExecutionImpl.execute(GetUpdatedExecutionImpl.java:65)
> at com.metamatrix.connector.salesforce.execution.ProcedureExecutionParentImpl.execute(ProcedureExecutionParentImpl.java:86)
> at com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorker.processNewRequest(ConnectorWorker.java:275)
> at com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorker.process(ConnectorWorker.java:141)
> at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:64)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 4 months
[JBoss JIRA] (TEIID-1847) Salesforce connector does not report UnexpectedErrorFault exceptions correctly when calling getUpdated
by Steven Hawkins (Commented) (JIRA)
[ https://issues.jboss.org/browse/TEIID-1847?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-1847:
---------------------------------------
Was this reproduced in Teiid/EDS?
> Salesforce connector does not report UnexpectedErrorFault exceptions correctly when calling getUpdated
> ------------------------------------------------------------------------------------------------------
>
> Key: TEIID-1847
> URL: https://issues.jboss.org/browse/TEIID-1847
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Reporter: Marc Shirley
> Labels: salesforce
>
> When encountering an UnexpectedErrorFault with com.sforce.soap.partner.SoapBindingStub.GetUpdated(), com.metamatrix.connector.salesforce.connection.SalesforceConnection.getUpdated() throws a null error message instead of the message returned from Salesforce. It appears that the getUpdated() method is using java.rmi.RemoteException.getMessage() when it should be using SFDC com.sforce.soap.partner.fault.ApiFault.getExceptionMessage() for "UnexpectedErrorFault" exceptions. Associated stack trace below.
> [Salesforce Connector_1246|9725_Worker_106|0] ERROR <CONNECTOR|0> Connector worker process failed for atomic-request=5707647.13.7.333713
> ConnectorException: Status ERROR: com.metamatrix.core code=0 null
> at com.metamatrix.connector.salesforce.connection.SalesforceConnection.getUpdated(SalesforceConnection.java:737)
> at com.metamatrix.connector.salesforce.execution.GetUpdatedExecutionImpl.execute(GetUpdatedExecutionImpl.java:65)
> at com.metamatrix.connector.salesforce.execution.ProcedureExecutionParentImpl.execute(ProcedureExecutionParentImpl.java:86)
> at com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorker.processNewRequest(ConnectorWorker.java:275)
> at com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorker.process(ConnectorWorker.java:141)
> at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:64)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
14 years, 4 months