No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

The N2000 BMS Server Fails to Query Data Due to Insufficient Objects and Indexes

Publication Date:  2012-07-25 Views:  46 Downloads:  0
Issue Description
When sp_helpdb is running on the N2000 BMS server, the following error is prompted:
Msg 8207, Level 17, State 1:
Line 1:
Couldn’t find an available descriptor for an object.Configure your system for more descriptors.
The data query fails. 
 
Alarm Information
 When the sp_helpdb is running, the system prompts the following error:
Msg 8207, Level 17, State 1:
Line 1:
Couldn’t find an available descriptor for an object.Configure your system for more descriptors. 
 
Handling Process
1. Check the logs of database and find no error logs.
2. The N2000 BMS server controls eight clients, so it handles a large amount of data when querying data and delivering profiles.
3. Check the number of indexes and objects on the database, and find that the number is small. Consult with sybase engineers and confirm that Msg 2812 means that the operation on this object cannot find the related description, which causes the failure of handling. In this case, you can change this value to 6000.
The method to change this value is as follows:
Open the N2000DBServer.cfg file under the /opt/sybase directory, and then modify two parameters: number of open objects and number of open indexes. After the modification is finished, restart the sybase database. Run sp_helpdb again and you can query the data successfully. 
 
Root Cause
1. The database is faulty.
2. A lot of operations are performed on the N2000 BMS.
3. The database index is faulty.
4. The number of database objects is incorrect. 
 
Suggestions
Null

END