When using the TIBCO Scribe® Online Connector For Salesforce within a Replication App or Integration App, the error "MALFORMED_QUERY: Truncated SOQL:" may occur when querying or replicating a specific entity.

This error occurs due to SOQL limitations that Salesforce implements on entities that have many records and contain referential fields.

Steps to troubleshoot the TIBCO Scribe® Online Connector For Salesforce error "MALFORMED_QUERY: Truncated SOQL:"

To resolve this error, identify the referential fields within the entity. This can be done by using a Native Query block within an Integration App and eliminating fields for the entity until the error no longer occurs.

Once the specific referential fields are identified, they can be excluded from the query if using an Integration App. If using a Replication App, a new user can be created within Salesforce who does not have access to the referential fields. This new user can then be used for the Salesforce connection within the Replication App. When the Replication App queries this entity, it will exclude the referential fields that the user does not have access to.