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.

Possible bug: global autoincrement high water mark wrong after reloading database

2 posts in General Discussion (old) Last posting was on 2008-09-25 07:36:40.0Z
Markus KARG Posted on 2008-09-23 10:06:18.0Z
From: "Markus KARG" <karg@quipsy.de>
Newsgroups: sybase.public.sqlanywhere
Subject: Possible bug: global autoincrement high water mark wrong after reloading database
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48d8bf9a@forums-1-dub>
Date: 23 Sep 2008 03:06:18 -0700
X-Trace: forums-1-dub 1222164378 10.22.241.152 (23 Sep 2008 03:06:18 -0700)
X-Original-Trace: 23 Sep 2008 03:06:18 -0700, vip152.sybase.com
X-Authenticated-User: panorama
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:172
Article PK: 866619

In our Sybase 8 database, we have a column defaulted to global
autoincrement. Some rows are existing. Each time I add a new one, the PK is
automatically incremented. Fine.

Now I am using Sybase Central 11 to reload into a new, automatically created
database file. After few minutes, the tool is done. Everything seems to work
fine, but not the global autoincrement: It says the PK is already existing!
After adding a row with a new high water mark manually, all works fine
again.

It seems the unload tool is not correctly initializing the global
autoincrement high water mark after a reload.

Is that a bug or do I something wrong? Where to report it?

Thanks
Markus


Markus KARG Posted on 2008-09-25 07:36:40.0Z
From: "Markus KARG" <karg@quipsy.de>
Newsgroups: sybase.public.sqlanywhere
References: <48d8bf9a@forums-1-dub>
Subject: Re: Possible bug: global autoincrement high water mark wrong after reloading database
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48db3f88@forums-1-dub>
Date: 25 Sep 2008 00:36:40 -0700
X-Trace: forums-1-dub 1222328200 10.22.241.152 (25 Sep 2008 00:36:40 -0700)
X-Original-Trace: 25 Sep 2008 00:36:40 -0700, vip152.sybase.com
X-Authenticated-User: panorama
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:173
Article PK: 866620

Info: Since there was no reaction, I meanwhile added this problem to Sybase
Case-Express (http://case-express.sybase.com/cx) as Case ID 11477982.

Regards
Markus

"Markus KARG" <karg@quipsy.de> schrieb im Newsbeitrag
news:48d8bf9a@forums-1-dub...

> In our Sybase 8 database, we have a column defaulted to global
> autoincrement. Some rows are existing. Each time I add a new one, the PK
> is automatically incremented. Fine.
>
> Now I am using Sybase Central 11 to reload into a new, automatically
> created database file. After few minutes, the tool is done. Everything
> seems to work fine, but not the global autoincrement: It says the PK is
> already existing! After adding a row with a new high water mark manually,
> all works fine again.
>
> It seems the unload tool is not correctly initializing the global
> autoincrement high water mark after a reload.
>
> Is that a bug or do I something wrong? Where to report it?
>
> Thanks
> Markus
>