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.

The precision of the timestamp columns differ...

7 posts in General Discussion Last posting was on 2006-11-07 17:43:07.0Z
Jan Posted on 2006-10-16 10:51:35.0Z
Reply-To: "Jan" <jan@cyberprop.com>
From: "Jan" <jan@cyberprop.com>
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: The precision of the timestamp columns differ...
Lines: 17
Organization: USP Designs
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: dsl-146-112-99.telkomadsl.co.za
X-Original-NNTP-Posting-Host: dsl-146-112-99.telkomadsl.co.za
Message-ID: <45336437@forums-1-dub>
Date: 16 Oct 2006 03:51:35 -0700
X-Trace: forums-1-dub 1160995895 165.146.112.99 (16 Oct 2006 03:51:35 -0700)
X-Original-Trace: 16 Oct 2006 03:51:35 -0700, dsl-146-112-99.telkomadsl.co.za
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:941
Article PK: 9151

Hi,

I'm using Mobilink (v9.0.2.2451) with MS SQL Server 2000 as my consolidated
database, and Ultralite on my remote database.

When performing a data sync, I get the warning that the precision of the
timestamp columns differs between my consolidated and remote databases.

The prescribed remedies I've seen all have to do with making changes on the
ASA consolidated database - which I'm not using...

So what do I do?

Thanks!
Jan


Shuchit Posted on 2006-10-16 12:13:12.0Z
Newsgroups: ianywhere.public.mbusinessanywhere.general,sybase.public.sqlanywhere.ultralite
Subject: Re: The precision of the timestamp columns differ...
From: Shuchit <me@privacy.net>
References: <45336437@forums-1-dub>
Message-ID: <Xns985E50F637642svelkarprivacynet@127.0.0.1>
Followup-To: sybase.public.sqlanywhere.ultralite
User-Agent: Xnews/2005.10.18 Hamster/2.1.0.0
X-Original-NNTP-Posting-Host: cpe0080c6ee7d81-cm024340006571.cpe.net.cable.rogers.com
X-Original-Trace: 16 Oct 2006 05:05:51 -0700, cpe0080c6ee7d81-cm024340006571.cpe.net.cable.rogers.com
Lines: 23
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 16 Oct 2006 05:06:34 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 16 Oct 2006 05:13:12 -0700
X-Trace: forums-1-dub 1161000792 10.22.108.75 (16 Oct 2006 05:13:12 -0700)
X-Original-Trace: 16 Oct 2006 05:13:12 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:942 sybase.public.sqlanywhere.ultralite:10411
Article PK: 9154


"Jan" <jan@cyberprop.com> wrote in news:45336437@forums-1-dub:

> Hi,
>
> I'm using Mobilink (v9.0.2.2451) with MS SQL Server 2000 as my consolidated
> database, and Ultralite on my remote database.
>
> When performing a data sync, I get the warning that the precision of the
> timestamp columns differs between my consolidated and remote databases.
>
> The prescribed remedies I've seen all have to do with making changes on the
> ASA consolidated database - which I'm not using...
>

You should post this in the UltraLite forum where the UltraLite experts would
see it. I crossposting to that group and setting followup there.

Essentially, you need to set the options in UltraLite. How you do it depends
on how you created the UltraLite schema file. If you are using the schema
painter, then it should let you set those options, otherwise if you are using
Ulinit, then set the options in the reference ASA database.

Shuchit


Jan Posted on 2006-10-17 11:14:13.0Z
Reply-To: "Jan" <jan@cyberprop.com>
From: "Jan" <jan@cyberprop.com>
Newsgroups: sybase.public.sqlanywhere.ultralite
References: <45336437@forums-1-dub> <Xns985E50F637642svelkarprivacynet@127.0.0.1>
Subject: Re: The precision of the timestamp columns differ...
Lines: 39
Organization: USP Designs
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: dsl-146-67-137.telkomadsl.co.za
X-Original-NNTP-Posting-Host: dsl-146-67-137.telkomadsl.co.za
Message-ID: <4534bb05@forums-1-dub>
Date: 17 Oct 2006 04:14:13 -0700
X-Trace: forums-1-dub 1161083653 165.146.67.137 (17 Oct 2006 04:14:13 -0700)
X-Original-Trace: 17 Oct 2006 04:14:13 -0700, dsl-146-67-137.telkomadsl.co.za
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:10415
Article PK: 1046271

Thanks!

I'll subscribe to that one, and follow the conversation there.

+++
Jan

"Shuchit" <me@privacy.net> wrote in message
news:Xns985E50F637642svelkarprivacynet@127.0.0.1...
> "Jan" <jan@cyberprop.com> wrote in news:45336437@forums-1-dub:
>
>> Hi,
>>
>> I'm using Mobilink (v9.0.2.2451) with MS SQL Server 2000 as my
>> consolidated
>> database, and Ultralite on my remote database.
>>
>> When performing a data sync, I get the warning that the precision of the
>> timestamp columns differs between my consolidated and remote databases.
>>
>> The prescribed remedies I've seen all have to do with making changes on
>> the
>> ASA consolidated database - which I'm not using...
>>
>
> You should post this in the UltraLite forum where the UltraLite experts
> would
> see it. I crossposting to that group and setting followup there.
>
> Essentially, you need to set the options in UltraLite. How you do it
> depends
> on how you created the UltraLite schema file. If you are using the schema
> painter, then it should let you set those options, otherwise if you are
> using
> Ulinit, then set the options in the reference ASA database.
>
> Shuchit


Jan Posted on 2006-10-17 11:29:36.0Z
Reply-To: "Jan" <jan@cyberprop.com>
From: "Jan" <jan@cyberprop.com>
Newsgroups: sybase.public.sqlanywhere.ultralite
References: <45336437@forums-1-dub> <Xns985E50F637642svelkarprivacynet@127.0.0.1>
Subject: Re: The precision of the timestamp columns differ...
Lines: 59
Organization: USP Designs
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: dsl-146-67-137.telkomadsl.co.za
X-Original-NNTP-Posting-Host: dsl-146-67-137.telkomadsl.co.za
Message-ID: <4534bea0@forums-1-dub>
Date: 17 Oct 2006 04:29:36 -0700
X-Trace: forums-1-dub 1161084576 165.146.67.137 (17 Oct 2006 04:29:36 -0700)
X-Original-Trace: 17 Oct 2006 04:29:36 -0700, dsl-146-67-137.telkomadsl.co.za
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:10416
Article PK: 1046272

I'm using the UL Schema Painter.

These are the warnings I receive from Mobilink:
W. 10/17 13:20:34. <1.5> [SJ0020060]: Warning: [10017] The consolidated and
remote databases have different timestamp precisions. Consolidated database
timestamps are precise to 2 digit(s) in the fractional second while the
remote database timestamps are precise to 6 digit(s)
W. 10/17 13:20:34. <1.5> [SJ0020060]: Warning: [10018] The timestamp
precision mismatch may be resolved by setting the
DEFAULT_TIMESTAMP_INCREMENT option on the remote database to 10000 and
TRUNCATE_TIMESTAMP_VALUES to 'On'

These are the current settings in my Schema Painter:
Precision = 30
Scale = 2
Time Format = HH:NN:SS.SSS
Timestamp Format = YYYY-MM-DD HH:NN:SS.SSS
Timestamp Increment = 1

What should I change?

Thanks
+++
Jan

"Shuchit" <me@privacy.net> wrote in message
news:Xns985E50F637642svelkarprivacynet@127.0.0.1...
> You should post this in the UltraLite forum where the UltraLite experts
> would
> see it. I crossposting to that group and setting followup there.
>
> Essentially, you need to set the options in UltraLite. How you do it
> depends
> on how you created the UltraLite schema file. If you are using the schema
> painter, then it should let you set those options, otherwise if you are
> using
> Ulinit, then set the options in the reference ASA database.
>
> Shuchit

> "Jan" <jan@cyberprop.com> wrote in news:45336437@forums-1-dub:
>
>> Hi,
>>
>> I'm using Mobilink (v9.0.2.2451) with MS SQL Server 2000 as my
>> consolidated
>> database, and Ultralite on my remote database.
>>
>> When performing a data sync, I get the warning that the precision of the
>> timestamp columns differs between my consolidated and remote databases.
>>
>> The prescribed remedies I've seen all have to do with making changes on
>> the
>> ASA consolidated database - which I'm not using...
>>
>


Jan Posted on 2006-10-17 11:43:41.0Z
Reply-To: "Jan" <jan@cyberprop.com>
From: "Jan" <jan@cyberprop.com>
Newsgroups: sybase.public.sqlanywhere.ultralite
References: <45336437@forums-1-dub> <Xns985E50F637642svelkarprivacynet@127.0.0.1> <4534bea0@forums-1-dub>
Subject: Re: The precision of the timestamp columns differ...
Lines: 68
Organization: USP Designs
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: dsl-146-67-137.telkomadsl.co.za
X-Original-NNTP-Posting-Host: dsl-146-67-137.telkomadsl.co.za
Message-ID: <4534c1ed@forums-1-dub>
Date: 17 Oct 2006 04:43:41 -0700
X-Trace: forums-1-dub 1161085421 165.146.67.137 (17 Oct 2006 04:43:41 -0700)
X-Original-Trace: 17 Oct 2006 04:43:41 -0700, dsl-146-67-137.telkomadsl.co.za
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:10417
Article PK: 1046273

OK - I changed the Timestamp Increment option in the Schema painter to
10,000 - and the warning has disappeared!

Thanks!
+++
Jan

> I'm using the UL Schema Painter.
>
> These are the warnings I receive from Mobilink:
> W. 10/17 13:20:34. <1.5> [SJ0020060]: Warning: [10017] The consolidated
> and remote databases have different timestamp precisions. Consolidated
> database timestamps are precise to 2 digit(s) in the fractional second
> while the remote database timestamps are precise to 6 digit(s)
> W. 10/17 13:20:34. <1.5> [SJ0020060]: Warning: [10018] The timestamp
> precision mismatch may be resolved by setting the
> DEFAULT_TIMESTAMP_INCREMENT option on the remote database to 10000 and
> TRUNCATE_TIMESTAMP_VALUES to 'On'
>
> These are the current settings in my Schema Painter:
> Precision = 30
> Scale = 2
> Time Format = HH:NN:SS.SSS
> Timestamp Format = YYYY-MM-DD HH:NN:SS.SSS
> Timestamp Increment = 1
>
> What should I change?
>
> Thanks
> +++
> Jan
>
> "Shuchit" <me@privacy.net> wrote in message
> news:Xns985E50F637642svelkarprivacynet@127.0.0.1...
>> You should post this in the UltraLite forum where the UltraLite experts
>> would
>> see it. I crossposting to that group and setting followup there.
>>
>> Essentially, you need to set the options in UltraLite. How you do it
>> depends
>> on how you created the UltraLite schema file. If you are using the schema
>> painter, then it should let you set those options, otherwise if you are
>> using
>> Ulinit, then set the options in the reference ASA database.
>>
>> Shuchit
>
>
>> "Jan" <jan@cyberprop.com> wrote in news:45336437@forums-1-dub:
>>
>>> Hi,
>>>
>>> I'm using Mobilink (v9.0.2.2451) with MS SQL Server 2000 as my
>>> consolidated
>>> database, and Ultralite on my remote database.
>>>
>>> When performing a data sync, I get the warning that the precision of the
>>> timestamp columns differs between my consolidated and remote databases.
>>>
>>> The prescribed remedies I've seen all have to do with making changes on
>>> the
>>> ASA consolidated database - which I'm not using...
>>>
>>
>
>


David Fishburn Posted on 2006-11-07 17:03:37.0Z
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Re: The precision of the timestamp columns differ...
From: David Fishburn <fishburn_spam@off.ianywhere.com>
References: <45336437@forums-1-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns987483D452FEfishburnsybasecom@127.0.0.1>
User-Agent: Xnews/2005.10.18 Hamster/2.1.0.0
NNTP-Posting-Host: vpneast-client-023.sybase.com
X-Original-NNTP-Posting-Host: vpneast-client-023.sybase.com
Date: 7 Nov 2006 10:03:37 -0700
X-Trace: forums-1-dub 1162922617 10.18.242.30 (7 Nov 2006 10:03:37 -0700)
X-Original-Trace: 7 Nov 2006 10:03:37 -0700, vpneast-client-023.sybase.com
Lines: 45
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:979
Article PK: 9173

"Jan" <jan@cyberprop.com> wrote in news:45336437@forums-1-dub of
ianywhere.public.mbusinessanywhere.general:

J> I'm using Mobilink (v9.0.2.2451) with MS SQL Server 2000 as my
J> consolidated database, and Ultralite on my remote database.
J>
J> When performing a data sync, I get the warning that the precision of
J> the timestamp columns differs between my consolidated and remote
J> databases.
J>
J> The prescribed remedies I've seen all have to do with making changes
J> on the ASA consolidated database - which I'm not using...

If I open the UltraLite USM file using the UltraLite Schema Painter and
right click on the database, choose Properties:

I see (at the bottom of the list) the "Timestamp Increment" which
defaults to a value of "1" (which is the same as ASA).

This can be changed there.

How did you create the USM originally? Did you use the UltraLite Schema
Painter or did you use ulinit.exe?

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList


Shuchit Posted on 2006-11-07 17:43:07.0Z
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Re: The precision of the timestamp columns differ...
From: Shuchit <me@privacy.net>
References: <45336437@forums-1-dub> <Xns987483D452FEfishburnsybasecom@127.0.0.1>
Message-ID: <Xns98748A07775C0svelkarprivacynet@127.0.0.1>
User-Agent: Xnews/2005.10.18 Hamster/2.1.0.0
NNTP-Posting-Host: vpneast-client-049.sybase.com
X-Original-NNTP-Posting-Host: vpneast-client-049.sybase.com
Date: 7 Nov 2006 10:43:07 -0700
X-Trace: forums-1-dub 1162924987 10.18.242.56 (7 Nov 2006 10:43:07 -0700)
X-Original-Trace: 7 Nov 2006 10:43:07 -0700, vpneast-client-049.sybase.com
Lines: 23
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:980
Article PK: 17846


> How did you create the USM originally? Did you use the UltraLite Schema
> Painter or did you use ulinit.exe?
>

Jan had responded in the UltraLite newsgroup. I have copied his response
below.

Shuchit
=================================================================

Subject: Re: The precision of the timestamp columns differ...
From: "Jan"
Newsgroups: sybase.public.sqlanywhere.ultralite
Reply-To: "Jan" <jan@cyberprop.com>
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
Date: 17 Oct 2006 04:43:41 -0700

OK - I changed the Timestamp Increment option in the Schema painter to
10,000 - and the warning has disappeared!

Thanks!
+++
Jan