VERIFIED SOLUTION i
X

Resolve "MALFORMED_QUERY" fault using the Salesforce translator component in Spectrum

Issue

Data is read from one or more views over the Salesforce connector using a WHERE clause. When the query is run a malformed query fault is thrown. In this case the data federation module is used.

Excerpt from stack trace below:-

Caused by: com.pb.spectrum.platform.server.common.datasource.DataSourceException: org.teiid.jdbc.TeiidSQLException: TEIID30504 VDS1-monSFDC-salesforce: [MalformedQueryFault [ApiQueryFault [ApiFault  exceptionCode='MALFORMED_QUERY'
INFO   | jvm 1    | 2015/07/17 14:05:34 |  exceptionMessage='
INFO   | jvm 1    | 2015/07/17 14:05:34 | WHERE Opportunity.AccountId != NULLOpportunity.IsClosed = true
INFO   | jvm 1    | 2015/07/17 14:05:34 |                               ^
INFO   | jvm 1    | 2015/07/17 14:05:34 | ERROR at Row:X:Column:Y
INFO   | jvm 1    | 2015/07/17 14:05:34 | Bind variables only allowed in Apex code'
INFO   | jvm 1    | 2015/07/17 14:05:34 | ]
INFO   | jvm 1    | 2015/07/17 14:05:34 |  row='X'
INFO   | jvm 1    | 2015/07/17 14:05:34 |  column='Y'

where X and Y are numbers.

Cause

There is a bug with the Salesforce translator component. 

Resolution

UPDATED: October 13, 2017


This issue has been fixed in the 10.1 release.

Environment Details


 

Downloads

  • No Downloads