Too many fields or filter conditions are too complicated.

  • 37Views
  • Last Post 20 September 2017
0
votes
Jason Southern posted this 19 September 2017

I'm receving this error message when trying to perform a synchronization from Salesforce to MySQL:

Query is either selecting too many fields or the filter conditions are too complicated.

Run # 8138694 for Package # 35776.

What needs to be done to correct this error? Could not find anything in documentation or support portal.

Jason Southern

 

 

1
votes
Mariia Zaharova posted this 20 September 2017

This is a Salesforce error and it is related to SOQL limits. Please refer to:

https://developer.salesforce.com/docs/atlas.en-us.salesforce_app_limits_cheatsheet.meta/salesforce_app_limits_cheatsheet/salesforce_app_limits_platform_soslsoql.htm

https://help.salesforce.com/articleView?id=000176969&type=1

https://developer.salesforce.com/forums/?id=906F00000008zdZIAQ

 

Thus, it seems, that you have a lot of custom fields in some of your tables that are included in the package, e.g. in Contact or Account. You can exclude unnecessary fields by editing the task for corresponding table in your Replication package:

https://skyvia.com/resources/docs/index.html?how_to_create_replication_task.htm

  • Supported by
  • Jason Southern
Close