Loading
Feature Disruption - Service Cloud VoiceRead More
Feature degradation | Gmail Email delivery failureRead More

Consumer Goods Cloud: Offline App v260 sync fails with INVALID_FIELD "duplicate field selected: Id"

Publish Date: May 24, 2026
Description

This article explains why Consumer Goods Cloud Offline Mobile App users cannot sync after upgrading to app version 260.00004.00 and how to resolve the error.

Customers describe this as: "After upgrading to version 260.00004.00 we started having problems logging into the offline application" and "Sales Reps getting Error in the CG Retail Execution Mobile App during Synchronisation after app update to version 260".

On login or sync, the app returns: "ERROR at Row:1:Column:145 duplicate field selected: Id" with errorCode "INVALID_FIELD" against a query similar to "SELECT cgcloud__Mobility_Sales_Org__c, cgcloud__Sales_Org__c, id FROM User WHERE Id = '<user id>'".

Trigger condition: the Consumer Goods Cloud Offline Mobile App was upgraded to version 260.00004.00 (or later) on Android or iOS, and one or more Tracked Objects, Named Queries, or Named Fetch Trees in the org reference User fields with incorrect lowercase casing (for example $User.id instead of $User.Id, or a lowercase id field added to a SELECT clause).

The v260 release introduced stricter SOQL casing validation; the sync engine always appends the canonical Id column, so a user-supplied lowercase id selection produces a duplicate-field error.

Affected scope: All users in any sales org assigned a Sync Configuration that contains lowercase User attribute references, all editions where Consumer Goods Cloud Retail Execution is enabled, both Android and iOS clients, and all sandbox and production environments. This is tracked as Known Issue KI-68738.

Resolution

Apply the workaround documented in Known Issue KI-68738 by correcting the casing of every User attribute reference used by the offline sync configuration.

 

  1. In Salesforce, open Developer Console and run the following SOQL to identify Tracked Object configurations that may contain incorrectly cased attribute references:
    SELECT Id, Name, cgc_sync__Object_Api_Name__c, cgc_sync__Where__c, cgc_sync__Where_2__c, cgc_sync__Where_3__c, cgc_sync__Where_4__c, cgc_sync__Order_By__c, cgc_sync__Custom_Index_List__c, cgc_sync__Dependent_Lookups__c FROM cgc_sync__Sync_Tracked_Object_Config__c
  2. Run this SOQL to inspect Named Queries:
    SELECT Id, Name, cgc_sync_Bindable_Name__c, cgc_sync_SOQL_Statement__c, cgc_sync_SOQL_Statement2__c, cgc_sync_SOQL_Statement3__c, cgc_sync_SOQL_Statement4__c, cgc_sync_Type__c FROM cgc_sync__Sync_Named_Query__c
  3. Run this SOQL to inspect Named Fetch Tree nodes:
    SELECT Id, Name, cgc_sync__Object_Api_Name__c, cgc_sync__Fetch_Tree_Name__c, cgc_sync__Join_Field__c, cgc_sync__Parent_Join_Field__c, cgc_sync__Child_Join_Field__c, cgc_sync__Where__c, cgc_sync__Where_2__c, cgc_sync__Where_3__c, cgc_sync__Where_4__c FROM cgc_sync__Sync_Named_Fetch_Tree_Nodes__c
  4. In the result sets, search every WHERE, SOQL_Statement, Order_By, Custom_Index_List, Dependent_Lookups, Join_Field, Parent_Join_Field, and Child_Join_Field column for the strings "$User.id", ", id", " id ", "Id,id", or any lowercase "id" reference to the User object.
  5. For each match, edit the record from App Launcher > Sync Management > Sync Configurator and replace the lowercase reference with the correct uppercase form. Specifically, change "$User.id" to "$User.Id". Apply the same correction to any other User field that uses non-standard casing (for example, change "$User.cgcloud__mobility_sales_org__c" to "$User.cgcloud__Mobility_Sales_Org__c").
  6. Save each updated Tracked Object, Named Query, and Named Fetch Tree record.
  7. From App Launcher > Sync Management > Sync Configurator, open each updated Tracked Object and click Execute on the WHERE clause section to validate that the SOQL parses without an INVALID_FIELD error.
  8. On the affected Android or iOS device, open the Consumer Goods Cloud Offline Mobile App, sign out, clear the app cache, then sign in again to trigger an Initial Sync.
  9. Confirm the issue is resolved by signing in to the Consumer Goods Cloud Offline Mobile App version 260.00004.00 on the originally affected Android or iOS device and completing an Initial Sync without the "duplicate field selected: Id" INVALID_FIELD error.
Knowledge Article Number

005385111

 
Loading
Salesforce Help | Article