[JBoss JIRA] Created: (TEIID-1406) Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismatched character ' ' expecting ':'
11:57 a.m.
Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismatched
character ' ' expecting ':'
-------------------------------------------------------------------------------------------------------------
Key: TEIID-1406
URL: https://issues.jboss.org/browse/TEIID-1406
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Steven Hawkins
Attachments: sfQueryError.txt
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
12:01 p.m.
New subject: [JBoss JIRA] Assigned: (TEIID-1406) Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismatched character ' ' expecting ':'
[
https://issues.jboss.org/browse/TEIID-1406?page=com.atlassian.jira.plugin...
]
John Doyle reassigned TEIID-1406:
---------------------------------
Assignee: John Doyle (was: Steven Hawkins)
Salesforce connector does not parse {ts'2003-03-11
11:42:10.5'} - gets mismatched character ' ' expecting ':'
-------------------------------------------------------------------------------------------------------------
Key: TEIID-1406
URL: https://issues.jboss.org/browse/TEIID-1406
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: John Doyle
Attachments: sfQueryError.txt
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
12:03 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-1406) Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismatched character ' ' expecting ':'
[
https://issues.jboss.org/browse/TEIID-1406?page=com.atlassian.jira.plugin...
]
John Doyle updated TEIID-1406:
------------------------------
Attachment: TEIID-1406.patch.txt
Looks like SF has changed their format for datetimes.
Salesforce connector does not parse {ts'2003-03-11
11:42:10.5'} - gets mismatched character ' ' expecting ':'
-------------------------------------------------------------------------------------------------------------
Key: TEIID-1406
URL: https://issues.jboss.org/browse/TEIID-1406
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: John Doyle
Attachments: sfQueryError.txt, TEIID-1406.patch.txt
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
9:26 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-1406) Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismatched character ' ' expecting ':'
[
https://issues.jboss.org/browse/TEIID-1406?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1406:
---------------------------------------
The formats on
http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_...
don't show support for milliseconds - although they are supported by ISO. I can see
that change in your patch, but our timestamps also shouldn't include Z unless it is
indicating UTC - in which case the timezone offset should not be appended.
Salesforce connector does not parse {ts'2003-03-11
11:42:10.5'} - gets mismatched character ' ' expecting ':'
-------------------------------------------------------------------------------------------------------------
Key: TEIID-1406
URL: https://issues.jboss.org/browse/TEIID-1406
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: John Doyle
Attachments: sfQueryError.txt, TEIID-1406.patch.txt
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
9:36 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-1406) Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismatched character ' ' expecting ':'
[
https://issues.jboss.org/browse/TEIID-1406?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1406:
---------------------------------------
So the new format should probably be:
return new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss"); //$NON-NLS-1$
Do you have an instance to test this against?
Salesforce connector does not parse {ts'2003-03-11
11:42:10.5'} - gets mismatched character ' ' expecting ':'
-------------------------------------------------------------------------------------------------------------
Key: TEIID-1406
URL: https://issues.jboss.org/browse/TEIID-1406
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: John Doyle
Attachments: sfQueryError.txt, TEIID-1406.patch.txt
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
3:41 p.m.
New subject: [JBoss JIRA] Resolved: (TEIID-1406) Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismatched character ' ' expecting ':'
[
https://issues.jboss.org/browse/TEIID-1406?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1406.
-----------------------------------
Fix Version/s: 7.1.1
Resolution: Done
updated the timestamp formatting toe not include the Z character. milliseconds do seem to
be supported by salesforce though
Salesforce connector does not parse {ts'2003-03-11
11:42:10.5'} - gets mismatched character ' ' expecting ':'
-------------------------------------------------------------------------------------------------------------
Key: TEIID-1406
URL: https://issues.jboss.org/browse/TEIID-1406
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: John Doyle
Fix For: 7.1.1
Attachments: sfQueryError.txt, TEIID-1406.patch.txt
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
5:39 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-1406) Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismatched character ' ' expecting ':'
[
https://issues.jboss.org/browse/TEIID-1406?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-1406:
----------------------------------
Fix Version/s: 7.3
Salesforce connector does not parse {ts'2003-03-11
11:42:10.5'} - gets mismatched character ' ' expecting ':'
-------------------------------------------------------------------------------------------------------------
Key: TEIID-1406
URL: https://issues.jboss.org/browse/TEIID-1406
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
Attachments: sfQueryError.txt, TEIID-1406.patch.txt
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
1:19 p.m.
New subject: [JBoss JIRA] Closed: (TEIID-1406) Salesforce connector does not parse {ts'2003-03-11 11:42:10.5'} - gets mismatched character ' ' expecting ':'
[
https://issues.jboss.org/browse/TEIID-1406?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1406.
---------------------------------
Salesforce connector does not parse {ts'2003-03-11
11:42:10.5'} - gets mismatched character ' ' expecting ':'
-------------------------------------------------------------------------------------------------------------
Key: TEIID-1406
URL: https://issues.jboss.org/browse/TEIID-1406
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
Attachments: sfQueryError.txt, TEIID-1406.patch.txt
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
5293
days inactive
5398
days old
7 comments
3 participants
participants (3)
-
John Doyle (JIRA) -
Paul Nittel (JIRA)
-
Steven Hawkins (JIRA)