Riva Insight: No such column 'Field__c' on entity 'Object__c'

Applies to Riva Sync & Riva Insight for Salesforce.

Issue

Riva Insight displays an error similar to the one shown: 

Riva Manager logs also show the error:

Cause

A custom field referenced in the error message is either missing, present when it shouldn't be, or not set correctly on the associated object in the Riva sync policy's CRM connection.

Solution

1. Determine whether the field is needed or not.
   1. For example, if your sync policy is not configured to sync Leads, Riva should not query Lead fields.
      
       
2. Remove it from the CRM connection object definition in the Riva Manager if not needed; alternatively, add it (with correct spelling) if it is supposed to sync.
    
3. If the field is needed, and present in the CRM connection object definition, add the field to the object in CRM.