Unable to pick data using SFDC sender adapter.

[Former Member]

Dear All,

Getting the below error while trying to pick data from SFDC sender channel. We are using SAP PI 7.4 single/java stack.

Error Details;

Receiving Salesforce data failed: [MalformedQueryFault [ApiQueryFault [ApiFault  exceptionCode='MALFORMED_QUERY'
  exceptionMessage='SOQL statements can not be longer than 20000 characters.'
]
  row='-1'
  column='-1'
]

Does anyone know how to resolve this?

Thanks,

Shaibayan

[nitindeshpande]

Hello Shaibayan,

There is restriction on the length of the query which can be used in your SFDC channel. And the restriction of character length on query is 20000.

We had faced the same error in our project and we used different logic to reduce the query length.

Regards,

Nitin