Error 7402



Message text

Could not spawn the threshold handler procedure for database %d, segment %d, when only %ld free pages were left in the segment.


Thresholds access Adaptive Server as a detached user. This means that, although a threshold does not access Adaptive Server through the network, it still requires a user connection. Error 7402 occurs when there are no available user connections when an Adaptive Server process reaches a threshold and Adaptive Server tries to execute the associated threshold procedure.


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 prevent this error from occurring in the future, use sp_configure to make sure that there are enough user connections to allow for all clients and the threshold manager. Refer to the chapter “Setting Configuration Parameters” in the System Administration Guide: Volume 1 for information about changing the number of user connections configuration parameter.

Additional information

Refer to “Managing Free Space with Thresholds” in the System Administration Guide: Volume 2 for information about Adaptive Server thresholds.

Versions in which this error is raised

All versions