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.

User error number 2601 is invalid

2 posts in General Discussion Last posting was on 2011-02-17 19:14:55.0Z
RGS Posted on 2011-02-17 16:50:51.0Z
Sender: 393b.4d5d4ea8.1804289383@sybase.com
From: RGS
Newsgroups: sybase.public.ase.general
Subject: User error number 2601 is invalid
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d5d51eb.39bc.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Feb 2011 08:50:51 -0800
X-Trace: forums-1-dub 1297961451 10.22.241.41 (17 Feb 2011 08:50:51 -0800)
X-Original-Trace: 17 Feb 2011 08:50:51 -0800, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29983
Article PK: 79211

When I execute a transaction, ASE display in my front-end:

"User error number 2601 is invalid. Number must be between
17000 and 2147483647"

I know that 2601 error means duplicate key, but ASE doesn't
show me the table name of the problem

I searched it in the sybase log but I didn't find this error

How can I know the table name of the problem? Have I to
change the configuration of the sybase log?

Thanks!!


"Mark A. Parsons" <iron_horse Posted on 2011-02-17 19:14:55.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: User error number 2601 is invalid
References: <4d5d51eb.39bc.1681692777@sybase.com>
In-Reply-To: <4d5d51eb.39bc.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d5d73af$1@forums-1-dub>
Date: 17 Feb 2011 11:14:55 -0800
X-Trace: forums-1-dub 1297970095 10.22.241.152 (17 Feb 2011 11:14:55 -0800)
X-Original-Trace: 17 Feb 2011 11:14:55 -0800, vip152.sybase.com
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29986
Article PK: 79215

ASE has basically 'reserved' all error numbers < 17000 for system use, so when you try to perform a raiserror with an
error number < 17000 ... you get this message.

I'd look through your code for raiserror commands and then make sure they aren't using an error number < 17000.

I'm surprised you didn't get more information (eg, stored/proc trigger where error occurred) from the dataserver ... or
is your front-end masking some of the error data?

On 02/17/2011 11:50, RGS wrote:
> When I execute a transaction, ASE display in my front-end:
>
> "User error number 2601 is invalid. Number must be between
> 17000 and 2147483647"
>
> I know that 2601 error means duplicate key, but ASE doesn't
> show me the table name of the problem
>
> I searched it in the sybase log but I didn't find this error
>
> How can I know the table name of the problem? Have I to
> change the configuration of the sybase log?
>
> Thanks!!