If an object originating from Salesforce contains a significant number of fields, it is possible to encounter an error when importing/refreshing an object or accessing the index of the object.
Here is an example of the error message:
This error message indicates that the maximum number of fields that can be queried from the SQL Server has been reached. It is unfortunately not possible to increase this limit since it is a Microsoft SQL Server limitation.
Please see the below Microsoft Documentation for more information on this limitation:
https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16
Resolving the issue
For every object that the portal queries, it also queries the fields in the lookup object.
It is possible to resolve this issue by reducing the number of Lookup fields selected in the Magentrix field selection window when refreshing the object.
Please see the documentation below on how to refresh an object and access the field selection window:
https://help.magentrix.com/wikis/help/managing-imported-salesforce-objects
If there are no lookup fields, regular fields must be unselected until the error stops occurring when accessing the object's index.