Error 7404

Severity

10

Message text

Could not find row in systhresholds for database %.*s describing segment %d, free space %ld.

Explanation

This error can occur for either of the following reasons:

• The row in database.dbo.systhresholds describing the segment, free space, and procedure name for the segment named in the error message is incorrect. Therefore, the threshold manager was not able to execute the stored procedure associated with the threshold.

• The clustered index on systhresholds is corrupt and Adaptive Server was not able to retrieve the row.

Action

Run dbcc checktable (systhresholds) and dbcc tablealloc (systhresholds) to check consistency of the system table. If you have corruption on systhresholds, contact Sybase Technical Support for further instructions.

Perform the threshold task that did not run because of this error:

1. Select the database:

   1> use <database_name>
   2> go
   

   Where <database_name> is the database for which the error occurred.

2. Run sp_helpthreshold <segment_name> for the segment named in the error message. This will display the stored procedure associated with the threshold.

3. Run the stored procedure manually.

If the stored procedure is not found or there are incorrect entries for segment or free space, modify the row in systhresholds with sp_modifythreshold to add a stored procedure (threshold action). Refer to the Reference Manual: Procedures for information about sp_modifythreshold.

Additional information