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 12.0, NT, Error 2801

2 posts in Windows NT Last posting was on 2000-07-19 20:20:41.0Z
Peter Posted on 2000-07-19 20:15:48.0Z
From: "Peter" <nospam@nospam.com>
Subject: ASE 12.0, NT, Error 2801
Date: Wed, 19 Jul 2000 21:15:48 +0100
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <1UBvX9b8$GA.196@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: modem-184.fu-manchu-lion-fish.dialup.pol.co.uk 62.136.215.184
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1849
Article PK: 1089334

When the system is busy, I'm getting error 2801: " Stored procedure
'*00019500000000_0034c8' not found. Specify owner.objectname or use sp_help
to check whether the object exists (sp_help may produce lots of output)."

The procedure in the error may be : *00023500000000_003732,
*00008000000000_0034c8, *00032700000000_0034c8, *00002400000000_001ffb...etc

There is a similar 'solved case' on the sybase website (10500870), which was
for 1191 on HP-UX - the solution was that 'the server was maxing out the
number of open objects'. I've checked with sp_monitorconfig "open objects"
and sp_configure "number of open objects", and set the max number of open
objects to 2000, but the maximum used (as shown by sp_monitorconfig) has
been 400 - so this isn't the problem here.

Any other ideas? - thanks.


Peter Posted on 2000-07-19 20:20:41.0Z
From: "Peter" <nospam@nospam.com>
References: <1UBvX9b8$GA.196@forums.sybase.com>
Subject: Re: ASE 12.0, NT, Error 2812
Date: Wed, 19 Jul 2000 21:20:41 +0100
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <mG4ZGAc8$GA.202@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: modem-184.fu-manchu-lion-fish.dialup.pol.co.uk 62.136.215.184
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1848
Article PK: 1089335

Apologies, error code was 2812 (not 2801)....

> When the system is busy, I'm getting error 2801: " Stored procedure
> '*00019500000000_0034c8' not found. Specify owner.objectname or use
sp_help
> to check whether the object exists (sp_help may produce lots of output)."
>
> The procedure in the error may be : *00023500000000_003732,
> *00008000000000_0034c8, *00032700000000_0034c8,
*00002400000000_001ffb...etc
>
> There is a similar 'solved case' on the sybase website (10500870), which
was
> for 1191 on HP-UX - the solution was that 'the server was maxing out the
> number of open objects'. I've checked with sp_monitorconfig "open objects"
> and sp_configure "number of open objects", and set the max number of
open
> objects to 2000, but the maximum used (as shown by sp_monitorconfig) has
> been 400 - so this isn't the problem here.
>
> Any other ideas? - thanks.
>
>