Bug 781152 (SOA-3651)

Summary:	Misc. Salesforce Translator Issues (for SOA-P)
Product:	[JBoss] JBoss Enterprise SOA Platform 5	Reporter:	Rick Wagner <rwagner>
Component:	EDS	Assignee:	Van Halbert <vhalbert>
Status:	RELEASE_PENDING ---	QA Contact:	Mike Harvey <mharvey>
Severity:	high	Docs Contact:
Priority:	high
Version:	5.2.0 GA	CC:	jpechane
Target Milestone:	ER4
Target Release:	5.3.0 GA
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-3651
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:	Errors were appearing when using tables from the Salesforce Translator. When querying a BusinessHours table imported from Salesforce, an error was thrown indicating a transformation failure. This has been fixed so the Salesforce time format is handled correctly. The tables will display as expected.	Story Points:	---
Clone Of:		Environment:
Last Closed:		Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Bug Depends On:
Bug Blocks:	781157

Description Rick Wagner 2011-12-01 21:01:06 UTC

Steps to Reproduce: 1 - deploy the attached VDB, SFTestVDB.vdb
2 - execute query "SELECT Name,CreatedDate,MondayStartTime FROM SFTest.salesforce.BusinessHours"
project_key: SOA

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

Other issues:

- nil string values will be returned as empty instead of null.

- non-join criteria of the form column1 = column2 is rendered inappropriately (however it is not supported by SF we should look at restricting criteria support to literals)

- IN predicate time/date/timestamp values are not formatted correctly

- timezones are ignored on returned time/timestamp values.  So unless the server is in the same timezone as the values (typically Z/GMT) the local value will be incorrect.

- a timezone is not included on literal times, which has the same issue as above.

- IS NULL support should be added using col = NULL

Comment 1 Rick Wagner 2011-12-01 21:01:07 UTC

Link: Added: This issue Cloned from TEIID-1852

Comment 2 Rick Wagner 2011-12-01 21:01:59 UTC

Security: Added: Public

Comment 3 jolee 2011-12-09 15:14:53 UTC

Link: Added: This issue is a dependency of SOA-3656

Comment 4 jolee 2011-12-09 16:50:49 UTC

Link: Added: This issue Cloned to SOA-3658

Comment 5 jolee 2011-12-09 16:55:40 UTC

Link: Added: This issue is a dependency of SOA-3658

Comment 6 jolee 2011-12-09 16:55:48 UTC

Link: Removed: This issue Cloned to SOA-3658

Comment 7 jolee 2011-12-09 16:56:15 UTC

Link: Removed: This issue is a dependency of SOA-3656

Comment 9 JBoss JIRA Server 2012-05-18 10:19:29 UTC

Steven Hawkins <shawkins> updated the status of jira TEIID-1852 to Closed

Comment 10 Suz 2012-06-13 04:16:28 UTC

    Technical note added. If any revisions are required, please edit the "Technical Notes" field
    accordingly. All revisions will be proofread by the Engineering Content Services team.
    
    New Contents:
Errors were appearing when using tables from the Salesforce Translator. When querying a BusinessHours table imported from Salesforce, an error was thrown indicating a transformation failure. This has been fixed so the Salesforce time format is handled correctly. The tables will display as expected.

Comment 11 Paul Nittel 2012-07-11 15:00:25 UTC

I verified this using ER5. It works.