My Oracle Support Banner

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

Last updated on MAY 15, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.