Skip to main content
hamburger menu Created with Sketch.
Veeva Support EU & US Holiday: May 29th - Limited staff, please plan accordingly

Search the Knowledge Base

Error: unexpected token: ')' due to OwnerId IN () - Occurs in CRM Sync

  • Updated

Overview:

Veeva CRM Sync Error unexpected token: ')' due to OwnerId IN ().

Root Cause:

This error occurs when all the following conditions are true:

  • VMOC WHERE clause contains the META-SOQL variable @@VOD_USERS_IN_MY_TERRITORY:OwnerId@@
  • Sync User's Territory is Changed in Salesforce
  • Veeva Cache is not cleared
  • Sync User's Previous Territory no longer contains any users
  • A User Syncs

Solution:

To avoid the error, do the following:

  1. Clear Veeva Cache after making user Territory changes.

Related Documentation:

CRM Help Documentation:

Powered by Zendesk