SQL Anywhere Mobile - Problem in Deleting Old Log Files

Author

Problem in Deleting Old Log Files

Jack

2005-11-03, 8:29 pm

Hi,
We are using the ASA 9.0.1.1899 version for the client
database and synchronization with Oracle. In that we have
enabled the Delete_Old_Log files option. it is working fine
in the normal scenario like.
We are creating the User Id in the following logic.

User Id : APPSYSIDKEYNUM

APP - is Common to all clients.
SYSID - is unique to each of the client.
KEYNUM is the Key Value in the Server to Fetch the related
data from the Server to the client.

if we install our application in the client system. sysid
will be generated and it will be stored as the system id.
then based on the user selection and need that Key value may
vary.

The deletion of the Log file is working fine i.e. after
sync. it is deleting the old log file.

Process 1 :
We have the back up option also. in that after backing up.
that database may moved to some other system. in that case
the system id will change for the next synchronization. So
it will be treated as new mobilink user for the server.
after this in the client side it is not deleting the Log
files. Number of files in the database folder is increasing.
coz of this memory of the client system is occupied more on
this.

Process 2:

In the second case, they might change the Key Value number
for the data in the server. it will create a new user,
subscription again. in that case also it is not deleting the
old log files. after some time if they move back to the same
key value number. it is throwing some error like mismatching
the Offset value.

Please give me the proper solution to handle this cases.
Expecting your reply.
Regards,
Jack

Breck Carter [TeamSybase]

2005-11-03, 8:29 pm

When you create a new user and subscription, are you dropping the old
user and subscription? If not, and if you are no longer synchronizing
that old subscription, the MobiLink client will never delete any
transactions logs because it has to keep them around in the event you
finally *do* synchronize that old subscription.

I *think* dropping the old subscription is sufficient to make it work,
but I have not tested that exact scenario.

Breck

On 2 Nov 2005 21:52:49 -0700, Jack wrote:

>Hi,
>We are using the ASA 9.0.1.1899 version for the client
>database and synchronization with Oracle. In that we have
>enabled the Delete_Old_Log files option. it is working fine
>in the normal scenario like.
>We are creating the User Id in the following logic.
>
>User Id : APPSYSIDKEYNUM
>
>APP - is Common to all clients.
>SYSID - is unique to each of the client.
>KEYNUM is the Key Value in the Server to Fetch the related
>data from the Server to the client.
>
>if we install our application in the client system. sysid
>will be generated and it will be stored as the system id.
>then based on the user selection and need that Key value may
>vary.
>
>The deletion of the Log file is working fine i.e. after
>sync. it is deleting the old log file.
>
>Process 1 :
>We have the back up option also. in that after backing up.
>that database may moved to some other system. in that case
>the system id will change for the next synchronization. So
>it will be treated as new mobilink user for the server.
>after this in the client side it is not deleting the Log
>files. Number of files in the database folder is increasing.
>coz of this memory of the client system is occupied more on
>this.
>
>
>Process 2:
>
>In the second case, they might change the Key Value number
>for the data in the server. it will create a new user,
>subscription again. in that case also it is not deleting the
>old log files. after some time if they move back to the same
>key value number. it is throwing some error like mismatching
>the Offset value.
>
>Please give me the proper solution to handle this cases.
>Expecting your reply.
>Regards,
>Jack

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Sponsored Links