Unable to properly update the CDB because the partition was improperly assigned

Problem: An MBO with a load/synchronization parameter, using an on-demand cache group interval greater than 0, and the load parameter does not have the "Propagate to Attribute" set:

  1. A record is created by the device and synchronized to the EIS.
  2. The record is deleted in the EIS for any reason.
  3. When the on-demand cache group interval expires, the next synchronization request from the device should refresh the CDB and device correctly. Although the newly created record has been deleted from the EIS, it still exists in CDB and device where they remain.
    Solution: When designing the MBO, map it's load parameter to a corresponding attribute with "Propagate to Attribute". If there is no corresponding attribute, add one, then map it. For example, the Customer MBO has this definition:
    SELECT   id,
      fname,
      lname,
      address,
      city,
      state,
      zip,
      phone,
      company_name FROM sampledb.dba.customer
    WHERE state = :state
    Map the Customer MBO's state load argument to the state "Propagate to Attribute" from the Load Arguments tab.
Related concepts
AutoCommit Option for JDBC MBOs Using an ASE Data Source
Passing an Empty String or Byte into a Required Binary Column in ASE
Related tasks
Binding an MBO to a Database Fails
Multilevel Insert Operation Fails
Attribute Length Set Incorrectly for Operation and Load Arguments
Related reference
MBO Retrieves Incorrect Data
Relationship Error
Warning Message When Creating Relationships
Troubleshooting Default Values for Adaptive ServerĀ® Anywhere uniqueidentifiers
Preview Errors for a Web Service Mobile Business Object with date/time Types
Web Service Mobile Business Object Must Be Connected to Connection Profile
Refresh Fails Due to Missing Load Argument Default Values
Input Parameters Fail to Generate for Complex Data Sources
Output Mapping Warning Message for Multilevel Insert Operations
Syntax Errors When Creating a Database Mobile Business Object
Sybase MBOs That Invalidate the Cache