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.

fatal error 913

2 posts in JConnect version 3.0 Last posting was on 1999-07-08 10:56:47.0Z
forums.sybase.com Posted on 1999-07-08 00:24:27.0Z
From: "forums.sybase.com" <terranv@digitalthink.com>
Subject: fatal error 913
Date: Wed, 7 Jul 1999 17:24:27 -0700
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <j#eCEfNy#GA.280@forums.sybase.com>
Newsgroups: sybase.public.jconnect30
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.jconnect30:245
Article PK: 254578

I'm getting this exception with Sybase 11.0.3 and JConnect 3:

com.sybase.jdbc.SybSQLException: WARNING - Fatal Error 913 occurred at Jul
7 19
99 5:22PM. Please note the error and time, and contact a user with System
Admi
nistrator (SA) authorization.

Any ideas?


Lance Andersen Posted on 1999-07-08 10:56:47.0Z
Message-ID: <378483EF.54E235D6@sybase.com>
Date: Thu, 08 Jul 1999 06:56:47 -0400
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 4.6 [en] (X11; I; SunOS 5.7 sun4m)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: fatal error 913
References: <j#eCEfNy#GA.280@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jconnect30
Lines: 67
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.jconnect30:244
Article PK: 256623


"forums.sybase.com" wrote:
>
> I'm getting this exception with Sybase 11.0.3 and JConnect 3:
>
> com.sybase.jdbc.SybSQLException: WARNING - Fatal Error 913 occurred at Jul
> 7 19
> 99 5:22PM. Please note the error and time, and contact a user with System
> Admi
> nistrator (SA) authorization.
>
> Any ideas?

913 is an ASE error. the rest ofo the format in your message is due to
the
SQLException handler that your program uses

from out ASE troubleshooting guide
--

Error 913

Severity Level

22

Error Message Text

Could not find row in sysdatabases with database
id %d. Run DBCC CHECKTABLE on sysdatabases.

Explanation

This error occurs when Adaptive Server cannot find an entry in
sysdatabases when looking for a specific database ID.

Possible causes of Error 913 are:

* Accessing a stored procedure or view that refers to a table in a
database that has been dropped.

* Accessing a stored procedure or view that refers to a table in a
database that has been dropped and re-created.

* A nonclustered index on the sysdatabases table in the master
database has been corrupted.

This is a serious error if the index is corrupt or recovery fails.

Action

If the 913 error is caused by accessing a stored procedure or view that
refers to a table in a database that has been dropped, either re-create
the database or update the procedure or view to point to the
appropriate database.

When a database has been dropped and re-created, it can end up
with a different database ID. If a stored procedure still references the
old database ID, drop and re-create the stored procedure so that it
will reference the new database ID. Refer to drop procedure and create
procedure in the Adaptive Server Reference Manual for information about
dropping and re-creating stored procedures.

If the cause of the error is a corrupted nonclustered index on a system
table, use one of these options:

Use the sp_fixindex stored procedure to repair the index.

* Restore master from backup. Refer to "System Database
Recovery" on page 1-1 for information about restoring the master
database.

Releases in Which This Error Is Raised

11.0 and later

===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Product Support Engineering Phone:(781) 564-6336
77 South Bedford Street Fax: (781) 564-6148
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================