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.

ASE - Database Options

14 posts in General Discussion Last posting was on 2003-07-29 20:00:50.0Z
Oscar_Verdeja Posted on 2003-07-23 17:02:04.0Z
From: Oscar_Verdeja
Date: Wed, 23 Jul 2003 13:02:04 -0400
Newsgroups: ianywhere.public.general
Subject: ASE - Database Options
Message-ID: <1A60C9D855B38DBF005D92CF85256D6C.005D92DD85256D6C@webforums>
Lines: 7
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1438
Article PK: 3671

Im using ASE 11 and Im trying to synchronize my database, but Im getting
this warning that I should change some database options, but I cant find
where I change this options..

DEFAULT_TIMESTAMP_INCREMENT and TRUNCATE_TIMESTAMP_VALUES

Thanks


Nick Elson Posted on 2003-07-23 21:44:00.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
References: <1A60C9D855B38DBF005D92CF85256D6C.005D92DD85256D6C@webforums>
Subject: Re: ASE - Database Options
Date: Wed, 23 Jul 2003 17:44:00 -0400
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
x-mimeole: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <OUsz#SWUDHA.346@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: nicelson-xp.sybase.com 172.31.143.50
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1447
Article PK: 3680

Those are ASA options and would most likely need
to be set on your ASA remotes.

<Oscar_Verdeja> wrote in message
news:1A60C9D855B38DBF005D92CF85256D6C.005D92DD85256D6C@webforums...
> Im using ASE 11 and Im trying to synchronize my database, but Im getting
> this warning that I should change some database options, but I cant find
> where I change this options..
>
> DEFAULT_TIMESTAMP_INCREMENT and TRUNCATE_TIMESTAMP_VALUES
>
> Thanks


Oscar_Verdeja Posted on 2003-07-23 22:36:38.0Z
From: Oscar_Verdeja
Date: Wed, 23 Jul 2003 18:36:38 -0400
Newsgroups: ianywhere.public.general
Subject: Re: ASE - Database Options
Message-ID: <EFFAFF1182839D29007C344085256D6C.007BFDF785256D6C@webforums>
References: <1A60C9D855B38DBF005D92CF85256D6C.005D92DD85256D6C@webforums> <OUsz#SWUDHA.346@forums-2-dub>
Lines: 2
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1448
Article PK: 3681

Im not an DB Administrator, could you give me more a detailed explanation
on how to change them?


Breck Carter [TeamSybase] Posted on 2003-07-24 10:54:27.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Subject: Re: ASE - Database Options
Date: Thu, 24 Jul 2003 06:54:27 -0400
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <9gevhvkhrh4mof2s1tm9acksr6qnsk4l3b@4ax.com>
References: <1A60C9D855B38DBF005D92CF85256D6C.005D92DD85256D6C@webforums>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: bcarter.sentex.ca 64.7.134.118
Lines: 18
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1452
Article PK: 3685

Use dbisql to connect to your ASA database.

Run these commands:

SET OPTION PUBLIC.DEFAULT_TIMESTAMP_INCREMENT = nnn;

SET OPTION PUBLIC.TRUNCATE_TIMESTAMP_VALUES = 'ON';

where nnn is the value suggested in the error message.

Breck

On Wed, 23 Jul 2003 13:02:04 -0400, Oscar_Verdeja wrote:

>Im using ASE 11 and Im trying to synchronize my database, but Im getting
>this warning that I should change some database options, but I cant find
>where I change this options..
>
>DEFAULT_TIMESTAMP_INCREMENT and TRUNCATE_TIMESTAMP_VALUES
>
>Thanks

bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
http://www.risingroad.com


Oscar_Verdeja Posted on 2003-07-24 20:52:30.0Z
From: Oscar_Verdeja
Date: Thu, 24 Jul 2003 16:52:30 -0400
Newsgroups: ianywhere.public.general
Subject: Re: ASE - Database Options
Message-ID: <971C383BA43E37BD0072AB8685256D6D.0040969C85256D6D@webforums>
References: <1A60C9D855B38DBF005D92CF85256D6C.005D92DD85256D6C@webforums> <9gevhvkhrh4mof2s1tm9acksr6qnsk4l3b@4ax.com>
Lines: 9
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1457
Article PK: 3690

Im using ASE, not ASA, I try to run the command as you suggested.

SET OPTION PUBLIC.DEFAULT_TIMESTAMP_INCREMENT = 10000

Server Message: Number 156, Severity 15
Line 1:
Incorrect syntax near the keyword 'OPTION'

Any suggetions?


Nick Elson Posted on 2003-07-24 20:37:55.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
References: <1A60C9D855B38DBF005D92CF85256D6C.005D92DD85256D6C@webforums> <9gevhvkhrh4mof2s1tm9acksr6qnsk4l3b@4ax.com> <971C383BA43E37BD0072AB8685256D6D.0040969C85256D6D@webforums>
Subject: Re: ASE - Database Options
Date: Thu, 24 Jul 2003 16:37:55 -0400
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
x-mimeole: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <eGTcvSiUDHA.346@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: nicelson-xp.sybase.com 172.31.143.50
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1458
Article PK: 3691

That's correct. ASE does not support those operations.
They are not even TSQL compatible. They are only for
ASA functionality, meant to mitigate differences between
the two servers handle datetime values.

Okay . . . let restart this thread from the beginning.

You should only be getting your original warning
[[What was that exact text again? and When do you get it?]]
IFF:

1A - One of your remotes is an ASA database
1B - You are replicating datetime (ASA calls it timestamp) information
and
1C - ASE is receiving date information into a date time column which
does not conform to the TSQL standards for that (~1/300ths of
a second increments in the millisecond portion )
OR

2 - You are getting garbage data or trying to mix data types with
different schemas a two different sites.

SOOOO . . . .

????? R U trying to tell us that this is strictly an ASE-to-ASE
SSRemote replication setup you have?????

<Oscar_Verdeja> wrote in message
news:971C383BA43E37BD0072AB8685256D6D.0040969C85256D6D@webforums...
> Im using ASE, not ASA, I try to run the command as you suggested.
>
> SET OPTION PUBLIC.DEFAULT_TIMESTAMP_INCREMENT = 10000
>
> Server Message: Number 156, Severity 15
> Line 1:
> Incorrect syntax near the keyword 'OPTION'
>
> Any suggetions?


Oscar_Verdeja Posted on 2003-07-24 21:46:00.0Z
From: Oscar_Verdeja
Date: Thu, 24 Jul 2003 17:46:00 -0400
Newsgroups: ianywhere.public.general
Subject: Re: ASE - Database Options
Message-ID: <CF72800BF6E99BF70077911785256D6D.007645A485256D6D@webforums>
References: <1A60C9D855B38DBF005D92CF85256D6C.005D92DD85256D6C@webforums> <9gevhvkhrh4mof2s1tm9acksr6qnsk4l3b@4ax.com> <971C383BA43E37BD0072AB8685256D6D.0040969C85256D6D@webforums> <eGTcvSiUDHA.346@forums-2-dub>
Lines: 21
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1459
Article PK: 3692

Ok, this is an ASE - ASA remote database sync...

Im using mobilink to synchronize the database to the ASA, so I can have
mobile databases in PDA's

When I sync, I move all the info, not just the changes, when I look into
the log of the sync, I get this message

I. 07/23 15:47:39. <1.5> [ml_saot_completa_tcp]: 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).
I. 07/23 15:47:39. <1.5> [ml_saot_completa_tcp]: Warning: [10018] You may
resolve the timestamp precision mismatch by setting the
DEFAULT_TIMESTAMP_INCREMENT option on the remote database to 10000 and
TRUNCATE_TIMESTAMP_VALUES to 'On'.

Im hoping this will solve my problem...

I have ASE 11.0.5 and the ASA remote database that creates the dbinit
command in the ASA 8.0.2


Breck Carter [TeamSybase] Posted on 2003-07-25 12:04:10.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Subject: Re: ASE - Database Options
Date: Fri, 25 Jul 2003 08:04:10 -0400
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <3472iv801nuumtlg6n26hsaff3g2v535m0@4ax.com>
References: <1A60C9D855B38DBF005D92CF85256D6C.005D92DD85256D6C@webforums> <9gevhvkhrh4mof2s1tm9acksr6qnsk4l3b@4ax.com> <971C383BA43E37BD0072AB8685256D6D.0040969C85256D6D@webforums> <eGTcvSiUDHA.346@forums-2-dub> <CF72800BF6E99BF70077911785256D6D.007645A485256D6D@webforums>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: bcarter.sentex.ca 64.7.134.118
Lines: 38
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1462
Article PK: 3695

SO YOU *ARE* USING ASA (shouting intended :)

Here are the instructions again...

=====
Use dbisql to connect to YOUR *ASA* DATABASE..

Run these commands:

SET OPTION PUBLIC.DEFAULT_TIMESTAMP_INCREMENT = nnn;

SET OPTION PUBLIC.TRUNCATE_TIMESTAMP_VALUES = 'ON';

where nnn is the value suggested in the error message.
=====

On Thu, 24 Jul 2003 17:46:00 -0400, Oscar_Verdeja wrote:

>Ok, this is an ASE - ASA remote database sync...
>
>Im using mobilink to synchronize the database to the ASA, so I can have
>mobile databases in PDA's
>
>When I sync, I move all the info, not just the changes, when I look into
>the log of the sync, I get this message
>
>I. 07/23 15:47:39. <1.5> [ml_saot_completa_tcp]: 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).
>I. 07/23 15:47:39. <1.5> [ml_saot_completa_tcp]: Warning: [10018] You may
>resolve the timestamp precision mismatch by setting the
>DEFAULT_TIMESTAMP_INCREMENT option on the remote database to 10000 and
>TRUNCATE_TIMESTAMP_VALUES to 'On'.
>
>Im hoping this will solve my problem...
>
>I have ASE 11.0.5 and the ASA remote database that creates the dbinit
>command in the ASA 8.0.2

bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
http://www.risingroad.com


Oscar_Verdeja Posted on 2003-07-25 15:52:13.0Z
From: Oscar_Verdeja
Date: Fri, 25 Jul 2003 11:52:13 -0400
Newsgroups: ianywhere.public.general
Subject: Re: ASE - Database Options
Message-ID: <7FB31391956FD1ED00572DC085256D6E.0049A6D285256D6E@webforums>
References: <1A60C9D855B38DBF005D92CF85256D6C.005D92DD85256D6C@webforums> <9gevhvkhrh4mof2s1tm9acksr6qnsk4l3b@4ax.com> <971C383BA43E37BD0072AB8685256D6D.0040969C85256D6D@webforums> <eGTcvSiUDHA.346@forums-2-dub> <CF72800BF6E99BF70077911785256D6D.007645A485256D6D@webforums> <3472iv801nuumtlg6n26hsaff3g2v535m0@4ax.com>
Lines: 16
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1465
Article PK: 3698

Trying to understand this message

You may

>resolve the timestamp precision mismatch by setting the
>DEFAULT_TIMESTAMP_INCREMENT option on the remote database to 10000 and
>TRUNCATE_TIMESTAMP_VALUES to 'On'.

this is the situation, I have a consolidated database that is ASA, my
remote database is ASE, the changes are supposed to be done in ASE, since
its my remote.

I have done the changes anyway in ASA, but I still get the message.

How can I solve this precision mismatch so that both ASA and ASE, can
resolve this issue


Greg Fenton Posted on 2003-07-25 17:07:20.0Z
Date: Fri, 25 Jul 2003 13:07:20 -0400
From: Greg Fenton <greg.fenton_NOSPAM@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Subject: Re: ASE - Database Options
References: <1A60C9D855B38DBF005D92CF85256D6C.005D92DD85256D6C@webforums> <9gevhvkhrh4mof2s1tm9acksr6qnsk4l3b@4ax.com> <971C383BA43E37BD0072AB8685256D6D.0040969C85256D6D@webforums> <eGTcvSiUDHA.346@forums-2-dub> <CF72800BF6E99BF70077911785256D6D.007645A485256D6D@webforums> <3472iv801nuumtlg6n26hsaff3g2v535m0@4ax.com> <7FB31391956FD1ED00572DC085256D6E.0049A6D285256D6E@webforums>
In-Reply-To: <7FB31391956FD1ED00572DC085256D6E.0049A6D285256D6E@webforums>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <OToiwBtUDHA.145@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: gfenton-xp.sybase.com 172.31.140.253
Lines: 36
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1467
Article PK: 3700


Oscar_Verdeja wrote:
>
> this is the situation, I have a consolidated database that is ASA, my
> remote database is ASE, the changes are supposed to be done in ASE, since
> its my remote.

Please note: you have reversed the terminology. ASE *cannot* be a
remote database. MobiLink only support ASA and UltraLite remotes. ASE
however CAN be a consolidated.

This means that you have the MobiLink *server* connected to your ASE
*consolidated* and you are running the dbmlsync *client* against your
ASA *remote* database.

I hope that clears that up somewhat for you.


>
> I have done the changes anyway in ASA, but I still get the message.
>
> How can I solve this precision mismatch so that both ASA and ASE, can
> resolve this issue

Can you show us the exact commands you ran against the ASA remote
database to modify the timestamp settings?

Also, could you post the output of this command:

dbisql -nogui -c "..." SELECT * FROM SYSOPTION WHERE "option" IN
('Truncate_timestamp_values', 'Default_timestamp_increment')

(This should be typed in as a single line and the "..." needs to be
replaced with a connection string to connect to your ASA database).

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Oscar Verdeja Posted on 2003-07-28 16:40:27.0Z
Sender: 66db.3f25509c.1804289383@sybase.com
From: Oscar Verdeja
Newsgroups: ianywhere.public.general
Subject: Re: ASE - Database Options
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f2551fb.66fd.846930886@sybase.com>
References: <OToiwBtUDHA.145@forums-2-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Jul 2003 09:40:27 -0700
X-Trace: forums-1-dub 1059410427 10.22.241.41 (28 Jul 2003 09:40:27 -0700)
X-Original-Trace: 28 Jul 2003 09:40:27 -0700, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1473
Article PK: 3703

I had previously made some changes on my remote ASA dataase,
so I got this anwser from the command

Execution time 0.09 seconds
user_id option setting
2 Default_timestamp_increment 10000
2 Truncate_timestamp_valus Off


Greg Fenton Posted on 2003-07-28 17:03:14.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4; MultiZilla v1.4.0.4A) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ASE - Database Options
References: <OToiwBtUDHA.145@forums-2-dub> <3f2551fb.66fd.846930886@sybase.com>
In-Reply-To: <3f2551fb.66fd.846930886@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-xp.sybase.com
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <3f255752$1@forums-1-dub>
Date: 28 Jul 2003 10:03:14 -0700
X-Trace: forums-1-dub 1059411794 172.31.140.253 (28 Jul 2003 10:03:14 -0700)
X-Original-Trace: 28 Jul 2003 10:03:14 -0700, gfenton-xp.sybase.com
Lines: 19
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1474
Article PK: 3704


Oscar wrote:
> user_id option setting
> 2 Default_timestamp_increment 10000
> 2 Truncate_timestamp_valus Off

The error message you posted in a previous article says:

> I. 07/23 15:47:39. <1.5> [ml_saot_completa_tcp]: Warning: [10018] You may
> resolve the timestamp precision mismatch by setting the
> DEFAULT_TIMESTAMP_INCREMENT option on the remote database to 10000 and
> TRUNCATE_TIMESTAMP_VALUES to 'On'.
>


But as you can see above, TRUNCATE is off.

Hope this helps,
greg.fenton


Oscar Verdeja Posted on 2003-07-29 17:25:23.0Z
From: "Oscar Verdeja" <overdeja@idataw.com>
Newsgroups: ianywhere.public.general
References: <OToiwBtUDHA.145@forums-2-dub> <3f2551fb.66fd.846930886@sybase.com> <3f255752$1@forums-1-dub>
Subject: Re: ASE - Database Options
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: www.juarez.gob.mx
X-Original-NNTP-Posting-Host: www.juarez.gob.mx
Message-ID: <3f26ae03$1@forums-1-dub>
Date: 29 Jul 2003 10:25:23 -0700
X-Trace: forums-1-dub 1059499523 148.233.137.236 (29 Jul 2003 10:25:23 -0700)
X-Original-Trace: 29 Jul 2003 10:25:23 -0700, www.juarez.gob.mx
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1478
Article PK: 3707

I have set the values to the correct setting and Im still getting the error.
I have a more detail error this time

I. 07/29 11:24:16. <1.5> [ml_saot_completa_tcp]: 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).
I. 07/29 11:24:16. <1.5> [ml_saot_completa_tcp]: Warning: [10018] You may
resolve the timestamp precision mismatch by setting the
DEFAULT_TIMESTAMP_INCREMENT option on the remote database to 10000 and
TRUNCATE_TIMESTAMP_VALUES to 'On'.

"Greg Fenton" <greg.fenton_NOSPAM_@ianywhere.com> wrote in message
news:3f255752$1@forums-1-dub...
> Oscar wrote:
> > user_id option setting
> > 2 Default_timestamp_increment 10000
> > 2 Truncate_timestamp_valus Off
>
> The error message you posted in a previous article says:
>
> > I. 07/23 15:47:39. <1.5> [ml_saot_completa_tcp]: Warning: [10018] You
may
> > resolve the timestamp precision mismatch by setting the
> > DEFAULT_TIMESTAMP_INCREMENT option on the remote database to 10000 and
> > TRUNCATE_TIMESTAMP_VALUES to 'On'.
> >
>
>
> But as you can see above, TRUNCATE is off.
>
> Hope this helps,
> greg.fenton
>


Greg Fenton Posted on 2003-07-29 20:00:50.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ASE - Database Options
References: <OToiwBtUDHA.145@forums-2-dub> <3f2551fb.66fd.846930886@sybase.com> <3f255752$1@forums-1-dub> <3f26ae03$1@forums-1-dub>
In-Reply-To: <3f26ae03$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-xp.sybase.com
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <3f26d272$1@forums-1-dub>
Date: 29 Jul 2003 13:00:50 -0700
X-Trace: forums-1-dub 1059508850 172.31.140.253 (29 Jul 2003 13:00:50 -0700)
X-Original-Trace: 29 Jul 2003 13:00:50 -0700, gfenton-xp.sybase.com
Lines: 50
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1480
Article PK: 3710


Oscar Verdeja wrote:

> I have set the values to the correct setting and Im still getting the error.
> I have a more detail error this time
>

There are two possibilities I can think of here:

1. You are setting the option only temporarily or only for the current
user. You should make certain that you are setting it globally. See
the online ASA 8.0.x docs:

ASA Database Administration Guide
Database Options
Introduction to database options
- Scope and duration of database options


2. According to the ASA 8.0.x online docs:

ASA Database Administration Guide
Database Options
Alphabetical list of options
- TRUNCATE_TIMESTAMP_VALUES option [database]

"This option should not be enabled for databases already containing
timestamp data."

I unfortunately don't have an ASE database to confirm this case, but
I believe that the existing timestamp data will not be truncated as
so gets uploaded to MobiLink with the full precision that it had on
insert. This means ML gets the data, compares its precision to the
consolidated, and throws out that warning (notice that this is an
Informational message, as denoted by the "I." at the start of the
line).

So you might need to unload any existing timestamp data and reload
it. I have posted a message to our docs team to add such a note
if this truly is the case.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/