Sequence Doesn't Get Updated In C$seq_clients After Clients Sync (Doc ID 1982754.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Lite - Version 10.3.0.3.0 to 10.3.0.3.0 [Release 10.3]
Oracle Database Mobile Server - Version 11.3.0.0.0 to 11.3.0.0.0 [Release 11.3]
Information in this document applies to any platform.

Symptoms

On : 10.3.0.3.0 version, Mobile Client For Win 32 ( Desuported version )

ACTUAL BEHAVIOR
---------------

User syncs with server for the first time. After that he creates some new records, using a sequence for a primary key field.
After adding records the user syncs with mobile server. The value of the last created ID on the client (app) does not get updated in table c@seq_clients (field cur_value).

This is done with an Android app. Server conflict rule is set to server wins. And the sequence we're using is in Native Application mode.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Install app and sync (tables en sequences are synced)
2. User adds some records to the database with the app
3. User syncs
4. Check the table c$seq_clients, field cur_value for that user and that sequence are null. This is not expected.

This is done with an Android app. Server conflict rule is set to server wins. And the sequence we're using is in Native Application mode.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms