?
Solved

WARNING - Fatal Error 631 occurred , Sybase

Posted on 2009-04-30
3
Medium Priority
?
1,067 Views
Last Modified: 2012-06-21
Hello,

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

Thanks
Roop










Shell Script
------------------------------------------------------------------------------------------
create index indexmane.<Tablename>()
go
delete from <Tablename>
go
<Procedurename> "Arg1","Arg2"
go
<Procedurename> "Arg1","Arg3"
go
<Procedurename> "Arg1","Arg4"
go
<Procedurename> "Arg1","Arg5"

Open in new window

0
Comment
Question by:rbhargaw
  • 2
3 Comments
 
LVL 13

Accepted Solution

by:
alpmoon earned 2000 total points
ID: 24275717
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.
0
 

Author Comment

by:rbhargaw
ID: 24295547
Recreating the index solved the problem.Thanks Alpmoon
0
 

Author Closing Comment

by:rbhargaw
ID: 31576485
Thanks!
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

LinkedIn blogging is great for networking, building up an audience, and expanding your influence as well. However, if you want to achieve these results, you need to work really hard to make your post worth liking and sharing. Here are 4 tips that ca…
In the below post we have mentioned the best hosting type for startups. Also, check out some of the superlative web hosting companies that are proposing affordable web hosting solutions to host your startup website.
Integration Management Part 2
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…

839 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