Error: No such column 'LastReferencedDate' on entity 'zuora__Product__c'.

[doyeli]

Problem:

Customer reported getting the following error from Marketo in synching to their Salesforce org:

ERROR at Row:1:Column:12
No such column 'LastReferencedDate' on entity 'zuora__Product__c'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.

[doyeli · Accepted solution]

Solution:

To resolve this issue, create a custom tab for the custom object zuora__Product__c.

The field LastReferencedDate is salesforce Standard field and is  stored as part of the tab, and do not exist for the object until a tab is created.

So, If  LastReferencedDate field is used in a query on a custom object, the error will be thrown until the Tab is created for  that custom Object.

Please refer Salesforce Article: https://help.salesforce.com/articleView?id=000230533&language=en_US&type=1