The Last Update time on the left bottom screen of iRep didn't change after a successful sync. There is no error appearing in the Error tab. When checking the user Activity log, it contains sync warnings such as:
Location_Child_vod__r.Name !=null AND SystemModstamp > 2017-01-16T10:36:45.992Z ^ERROR at Row:1:Column:626unexpected token: AND
The sync warning prevents the iRep Last Update time from being updated. It comes from the where clause in VMobile Object Configuration (VMOC).
Since incremental sync appends "AND SystemModstamp > ..." to the query, make sure the entire WHERE Clause is included in brackets if it contains the OR logical connector.
Example: When Veeva released the Product Metrics for Child Accounts feature, the WHERE clause of the Product_Metric_vod VMOC needs to be changed. The brackets are required for the entire WHERE Clause.
- The default is: WHERE Account_vod__r.Name != null
- Change to: WHERE (Account_vod__r.Name != null or Location_Child_vod__r.Name !=null)
Check the VMOC WHERE clause of the warning object. If it contains the OR logical connector, add brackets to the entire WHERE clause.
CRM Help Documentation: Product Metrics for Child Accounts