WARNING - Fatal Error 631 occurred , Sybase

Posted on 2009-04-30
Last Modified: 2012-06-21

In one of the shell script, which calls the stored procedure ,I am receiving the following error:
Msg 21, Level 21, State 1:
Server 'servername', Procedure 'Procedure name', Line 92:
WARNING - Fatal Error 631 occurred at Apr 27 2009 10:12PM.  Please note the
error and time, and contact a user with System Administrator (SA).
Now when I run the stored procedure in DBArstisan with the arguments, it works fine .
This stored procedure is called several times in the shell script and it always fail in the first call, no matter what is the argument.

One trick when it worked was I ran "delete from <Tablename>" from DBArtisan

and then ran the shell script which call stored procedure and it ran fine.

what could be the reason for this error? I asked my DBA but he don't see any problem in the log files


Shell Script


create index indexmane.<Tablename>()


delete from <Tablename>


<Procedurename> "Arg1","Arg2"


<Procedurename> "Arg1","Arg3"


<Procedurename> "Arg1","Arg4"


<Procedurename> "Arg1","Arg5"

Open in new window

Question by:rbhargaw
    LVL 13

    Accepted Solution

    This error indicates that there is a data corruption. If DBA don't see any other errors in errorlog, it might be related to another index on the table. Is there any other index on that table? Or what about other tables involved? You may need to recreate a corrupt index.

    Or you can ask DBA whether they are running dbcc checkdb or checktable or checkstorage regularly. They might have missed some errors reported during dbcc.

    Author Comment

    Recreating the index solved the problem.Thanks Alpmoon

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    After several days of searching and hunting for limited documentation, I wanted to share this guide to hopefully save someone the hassle of trying to figure this out on their own. I have tested this on Xendesktop 7.1 and PS 4.5 running simultaneousā€¦
    DECT technology has become a popular standard for wireless voice communication. DECT devices are not likely to be affected by other electronic devices and signals because they operate in a separate frequency-band.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the eā€¦
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now