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:

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

When calling Technical Support, have the information available that is listed in “Reporting errors”, including the output of:

Versions in which this error is raised

All versions