Salesforce Data transfer Error since 4th October

[konznic]

Our Data transfer Service for Salesforce started erroring yesterday with the Error INVALID_ARGUMENT: PrepareQuery failed : ClientInputError : Server error returned in unknown format

Does anybody have the same issue or know how to resolve this. 

Thanks for your help. 

[MrLav]

Same issue , beginning October 8th. Trying to figure it out as well.

[KyleMari]

Hi @konznic,

Welcome to Google Cloud Community!

It seems to me that something odd could be going on during your data transfer process and I'm sorry to hear how this is impacting your project. It also appears that you may be working on scheduling a Salesforce transfer for BigQuery.

There's a possibility that the issue you encountered could be linked to a current incident posted through Salesforce Trust which has been announced on October 8th as well. You can also check the rest of the logged incidents or issues in Salesforce here. Continue monitoring if this error keeps happening until now. Also make sure that you're not running behind a firewall or proxy as this might be a contributing factor too.

If the issue persists, and to officially confirm and identify the root cause, it would be best to contact Salesforce support.

I hope the above information is helpful.

[konznic]

Dear @KyleMari thanks for your reply, I am reaching out to Salesforce as well, unfortunately our issue persists since last week & is still ongoing. For us a limited amount of tables worked as of yesterday, now since today morning also that stopped working. 

[peter_actual]

Hello @KyleMari and @konznic ,

I'm on the same issue, any updates ?

[konznic]

@peter_actual I am mailing with the DTS support,  looks like they don´t know the cause yet. For us some specific tables seem to cause the issue & we are currently only loading the bare minimum. 

[MrLav]

I was able to get it to run by removing a bunch of the objects... going to try to add them back one by one to figure out the problem object. Very strange.

[peter_actual]

@MrLav True ! I noticed the same thing, but when adding all objects the problem is back.

[MrLav]

Yep, and I was able to add back the other objects in full by using multiple data transfers, rather than attempting to put the full list of objects into a single one --- so this leads me to believe there is a refresh token issue with bigquery's connector. Just throwing this work around out there.

[peter_actual]

@MrLav 
I applied your solution by creating a separate data transfer for each Salesforce object AND by shifting schedules by 1 minute (it avoid to run too many jobs on Salesforce) . It's working ! 

[MrLav]

Awesome to hear! Yes, I have all my objects syncing by putting no more than 5 in each data transfer configuration. The issue does not seem to be caused by any single object, but in the quantity of selected objects, and the way they are parsed to run the sfdc queries. If you want to make it a little easier to manage, you should be ok to select up to 5 per transfer. Beyond 5 is where I begin to get the malformed preparequery error.