Cisco Optical Network Planner Configuration Guide, Releases 26.x.x

Database overload notification levels and user actions

Updated: March 9, 2026

Want to summarize with AI?

On this page

Overview

Modify the threshold for database notifications
Manually clean the database

Overview

Provides details on the types of database overload notifications in Cisco Optical Network Planner, including notification levels, behavior, and recommended user actions.

This section describes the databse overloand notification in the Cisco Optical Network Planner tool.

Whenever the database is fully overloaded with networks, the subsequent network operations becomes slower such as like opening a network, saving a network, etc.
Database overload notification appears whenever these operations are performed. You can take necessary backup of unused networks and delete them.
These notifications are enabled by default. These can be disabled via feature.properties file.
Two levels of warning notifications appear – Slowness Detected and CONP Server DB capacity Exceeded. Take necessary actions appropriately.

Modify the threshold for database notifications

Use this task to modify the threshold for database notifications.

Procedure

Open the feature.properties file.

Search for hibernate.slowQuery.logging.enabled and set it to false.

By default, this property is enabled.

Modify the properties inside the hibernate.slowQuery.logging.enabled property as follows.

Properties	Description
`hibernate.slowQuery.logging.med.threshold.ms`	Medium-level threshold that triggers warning alerts when database queries exceed this execution time. If a network takes more than 5 seconds to open, this property triggers a warning alert notification. Medium timeout value is 5 seconds. 5000 is default.
`hibernate.slowQuery.logging.high.threshold.ms`	High-level threshold that triggers critical alerts when database queries exceed this execution time. If a network takes more than 10 seconds to open, this property triggers a critical alert notification. Maximum timeout value is 10 seconds. 10000 is default.
`hibernate.slowQuery.logging.min.network.count`	Threshold for maximum network count. 5000 is default.
`hibernate.slowQuery.logging.min.sites.count`	Threshold for maximum sites count. 150000 is default.

The database notification will now appear based on the threshold values that you have set.

Manually clean the database

Remove old networks from the database to optimize performance and ensure data is up-to-date.

This task is performed when you need to delete network entries that are no longer required, keeping the database lean and relevant.

Procedure

Choose File > Delete.

The Select Network(s) to Delete window opens.

Select the networks as follows.

Options	Description
Search bar	Search for the network to delete.
Select All check box	Select all the networks.
Check box list	Select the old networks.

Click Delete.

Warning message appears.

Click Yes.

The selected network is deleted.

Need help?

Open a support case

(Requires a Cisco Service Contract)

The documentation set for this product strives to use bias-free language. For the purposes of this documentation set, bias-free is defined as language that does not imply discrimination based on age, disability, gender, racial identity, ethnic identity, sexual orientation, socioeconomic status, and intersectionality. Exceptions may be present in the documentation due to language that is hardcoded in the user interfaces of the product software, language used based on RFP documentation, or language that is used by a referenced third-party product. Learn more about how Cisco is using Inclusive Language.