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.

Problem with IDENTITY column during load table request

3 posts in General Discussion Last posting was on 2012-08-14 11:01:21.0Z
Raghu Posted on 2012-08-09 09:46:53.0Z
Sender: 41e1.502384cd.1804289383@sybase.com
From: Raghu
Newsgroups: sybase.public.iq
Subject: Problem with IDENTITY column during load table request
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5023870d.4216.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 9 Aug 2012 02:46:53 -0700
X-Trace: forums-1-dub 1344505613 172.20.134.41 (9 Aug 2012 02:46:53 -0700)
X-Original-Trace: 9 Aug 2012 02:46:53 -0700, 172.20.134.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4529
Article PK: 246670

I am facing a problem where when i execute a load table
request with an identity column, for the fist 22 rows the
auto increment works fine.
Then for the 23 rd row it becomes 4095.The next 22 rows the
auto increment column gives values from 4095 to 4116
Then it starts with 8189and continues for next 22 rows.
This repeats for every 22 rows.
I created new database and it has the same behaviour.
I unistalled the product and installed again. The behaviour
continues.
Can anyone help.


Sundar Posted on 2012-08-13 13:20:46.0Z
Sender: 2bff.5028fec4.1804289383@sybase.com
From: Sundar
Newsgroups: sybase.public.iq
Subject: Re: Problem with IDENTITY column during load table request
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5028ff2e.2c18.1681692777@sybase.com>
References: <5023870d.4216.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 13 Aug 2012 06:20:46 -0700
X-Trace: forums-1-dub 1344864046 172.20.134.41 (13 Aug 2012 06:20:46 -0700)
X-Original-Trace: 13 Aug 2012 06:20:46 -0700, 172.20.134.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4531
Article PK: 246671


> I am facing a problem where when i execute a load table
> request with an identity column, for the fist 22 rows the
> auto increment works fine.
> Then for the 23 rd row it becomes 4095.The next 22 rows
> the auto increment column gives values from 4095 to 4116
> Then it starts with 8189and continues for next 22 rows.
> This repeats for every 22 rows.
> I created new database and it has the same behaviour.
> I unistalled the product and installed again. The
> behaviour continues.
> Can anyone help.

Hello there,

I also got the same issue, but the problem seems to be with
a 12GB RAM machine. Don't know the root cause though.

Can anybody help us out?


Chandru Posted on 2012-08-14 11:01:21.0Z
Sender: 5f8f.502a2e34.1804289383@sybase.com
From: Chandru
Newsgroups: sybase.public.iq
Subject: Re: Problem with IDENTITY column during load table request
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <502a2ff9.600e.1681692777@sybase.com>
References: <5023870d.4216.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 14 Aug 2012 04:01:21 -0700
X-Trace: forums-1-dub 1344942081 172.20.134.41 (14 Aug 2012 04:01:21 -0700)
X-Original-Trace: 14 Aug 2012 04:01:21 -0700, 172.20.134.41
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4532
Article PK: 246673


> I am facing a problem where when i execute a load table
> request with an identity column, for the fist 22 rows the
> auto increment works fine.
> Then for the 23 rd row it becomes 4095.The next 22 rows
> the auto increment column gives values from 4095 to 4116
> Then it starts with 8189and continues for next 22 rows.
> This repeats for every 22 rows.
> I created new database and it has the same behaviour.
> I unistalled the product and installed again. The
> behaviour continues.
> Can anyone help.

Hi,

I'm able to reproduce the issue. I'm using a 12 GB machine
where I was able to reproduce the behaviour mentioned.
However in a 8 GB machine, the above behaviour is not
observed. Anyone who knows why this is happening please help
out.

Chandru