Error 7407

Severity

10

Message text

Failed to execute the threshold procedure for database %d, segment %d, free space %ld.  

Explanation

This error occurs when an attempt to execute a stored procedure defined in systhresholds fails.

Action

To 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 displays the stored procedure associated with the threshold.

  3. Run the stored procedure manually.

To determine whether you can prevent this error from occurring in the future, review the Adaptive Server error log for additional messages regarding this error. If there is specific information as to what caused the procedure to fail, take whatever steps are necessary to prevent future occurrences.

Versions in which this error is raised

All versions