Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Clear sync cache

3 posts in General Discussion Last posting was on 2005-01-31 20:12:57.0Z
Marcin Zastawny Posted on 2005-01-26 09:36:17.0Z
Reply-To: "Marcin Zastawny" <marcinz@infocon.pl>
From: "Marcin Zastawny" <marcinz@infocon.pl>
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Clear sync cache
Lines: 21
Organization: Infocon
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: 132-mia-10.acn.waw.pl
Message-ID: <41f7648d$1@forums-2-dub>
X-Original-Trace: 26 Jan 2005 01:36:13 -0800, 132-mia-10.acn.waw.pl
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 Jan 2005 01:36:14 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 Jan 2005 01:36:17 -0800
X-Trace: forums-1-dub 1106732177 10.22.108.75 (26 Jan 2005 01:36:17 -0800)
X-Original-Trace: 26 Jan 2005 01:36:17 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:238
Article PK: 8789

Hi everyone,

I am trying to find a way to totally clear the device cache (pocketPC).

Doing a clearcache from the UI, only the web page cache is cleared, but the
XML databases on the device stay untouched.

I usually have to sync my device on the users account, so that when the user
syncs after me, the server will sense a different device connecting and will
resend the pages AND the database.

What actually happens when a different device syncs?
Why does the server only THEN resend the database (i need this functionality
when the users database goes corrupt)?
Maybe I can clear some record in the Sybase ASA database for that user, so
that on the next sync the whole XML database will be sent?

cheers,
Marcin


Tom Posted on 2005-01-27 14:42:31.0Z
From: "Tom" <nospam@nospam.com>
Newsgroups: ianywhere.public.mbusinessanywhere.general
References: <41f7648d$1@forums-2-dub>
Subject: Re: Clear sync cache
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
X-Original-NNTP-Posting-Host: vpn-dub-034.sybase.com
Message-ID: <41f8fdd2$1@forums-2-dub>
X-Original-Trace: 27 Jan 2005 06:42:26 -0800, vpn-dub-034.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 27 Jan 2005 06:42:29 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 27 Jan 2005 06:42:31 -0800
X-Trace: forums-1-dub 1106836951 10.22.108.75 (27 Jan 2005 06:42:31 -0800)
X-Original-Trace: 27 Jan 2005 06:42:31 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:240
Article PK: 8791

You can get the id of the user from the AGUSER table if you need to do this
by username

SELECT id FROM AGUSER where username='foo'

then delete all the revelant records for that user:


DELETE FROM AGXMLDBSTATE WHERE fk_aguser=id_of_user
DELETE FROM AGXMLRECORDSTATE WHERE fk_aguser=id_of_user

this will cause all the XML records to be sent again.

"Marcin Zastawny" <marcinz@infocon.pl> wrote in message
news:41f7648d$1@forums-2-dub...
> Hi everyone,
>
> I am trying to find a way to totally clear the device cache (pocketPC).
>
> Doing a clearcache from the UI, only the web page cache is cleared, but
> the XML databases on the device stay untouched.
>
> I usually have to sync my device on the users account, so that when the
> user syncs after me, the server will sense a different device connecting
> and will resend the pages AND the database.
>
> What actually happens when a different device syncs?
> Why does the server only THEN resend the database (i need this
> functionality when the users database goes corrupt)?
> Maybe I can clear some record in the Sybase ASA database for that user, so
> that on the next sync the whole XML database will be sent?
>
> cheers,
> Marcin
>
>


Marcin Zastawny Posted on 2005-01-31 20:12:57.0Z
Reply-To: "Marcin Zastawny" <marcinz@infocon.pl>
From: "Marcin Zastawny" <marcinz@infocon.pl>
Newsgroups: ianywhere.public.mbusinessanywhere.general
References: <41f7648d$1@forums-2-dub> <41f8fdd2$1@forums-2-dub>
Subject: Re: Clear sync cache
Lines: 49
Organization: Infocon
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: avd136.neoplus.adsl.tpnet.pl
X-Original-NNTP-Posting-Host: avd136.neoplus.adsl.tpnet.pl
Message-ID: <41fe9149@forums-1-dub>
Date: 31 Jan 2005 12:12:57 -0800
X-Trace: forums-1-dub 1107202377 83.27.37.136 (31 Jan 2005 12:12:57 -0800)
X-Original-Trace: 31 Jan 2005 12:12:57 -0800, avd136.neoplus.adsl.tpnet.pl
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:242
Article PK: 8792

thanks for that answer.

will try that definitely.


marcin

U¿ytkownik "Tom" <nospam@nospam.com> napisa³ w wiadomo¶ci
news:41f8fdd2$1@forums-2-dub...

> You can get the id of the user from the AGUSER table if you need to do
> this by username
>
> SELECT id FROM AGUSER where username='foo'
>
> then delete all the revelant records for that user:
>
>
> DELETE FROM AGXMLDBSTATE WHERE fk_aguser=id_of_user
> DELETE FROM AGXMLRECORDSTATE WHERE fk_aguser=id_of_user
>
> this will cause all the XML records to be sent again.
>
> "Marcin Zastawny" <marcinz@infocon.pl> wrote in message
> news:41f7648d$1@forums-2-dub...
>> Hi everyone,
>>
>> I am trying to find a way to totally clear the device cache (pocketPC).
>>
>> Doing a clearcache from the UI, only the web page cache is cleared, but
>> the XML databases on the device stay untouched.
>>
>> I usually have to sync my device on the users account, so that when the
>> user syncs after me, the server will sense a different device connecting
>> and will resend the pages AND the database.
>>
>> What actually happens when a different device syncs?
>> Why does the server only THEN resend the database (i need this
>> functionality when the users database goes corrupt)?
>> Maybe I can clear some record in the Sybase ASA database for that user,
>> so that on the next sync the whole XML database will be sent?
>>
>> cheers,
>> Marcin
>>
>>
>
>