With the new OAUTH2 LinkedService connection established we ran into the following issue in our pipelines.
When performing the following query through Azure Data Factory:
SELECT Id FROM Account WHERE SystemModstamp > @{variables('Lastmodified Account')} OR LastModifiedDate > @{variables('Lastmodified Account')} We receive the following error.
The response from Salesforce Bulk API indicates a failure. Please check the error message to understand the reason or contact Salesforce support. Error message: {"id":"750aV00000BJOgGQAX","operation":"queryAll","object":"Account","createdById":"00509000009qvimAAA","createdDate":"2024-11-11T13:36:55.000+0000","systemModstamp":"2024-11-11T13:36:56.000+0000","state":4,"concurrencyMode":"Parallel","contentType":"CSV","apiVersion":"54.0","lineEnding":"LF","columnDelimiter":"COMMA","jobType":"V2Query","numberRecordsProcessed":0,"retries":0,"totalProcessingTime":0,"numberRecordsFailed":0,"errorMessage":"Unexpected exception encountered in query processing. Please contact support with the following id: (removed)
We tried writing the correct datetime format instead of variables which returns the same unhandled exception, at the end of my latin here.
I've also seen a similar thread that got resolved using parenthesis outside of the where clausule, this in my case did not resolve the issue.
Thanks in advance for any help.
