We have configured Sybase monitoring for one of our customer's Sybase databases. However, the customers are complaining that the users are not able to access the DB as the our Sybase monitoring profile is flooding the DB with a high number of connections, around 600+. We have checked from our end and the Sybase monitoring has been configured correctly.
Additionally, we notice this database server robot is visible in the UIM console however when we click the robot the robot is empty and we need to actually restart the nimsoft service and then the probes will be visible. However, after a short period of time the probes go missing again.
- access/permissions and/or Sybase DB patches
- log_size checkpoint (in a particular case)
User ID: specifies the authorized user identification code to the server.
The user MUST HAVE access to run selects against syslisteners.
"SELECT permission denied on column address_info of object syslisteners, database master, owner dbo"
Check to see if you can run the following as the current database user or an admin user?
select address_info from syslisteners
Object rights required:
As well as SELECT permission on column address_info of object syslisteners, database master.
Double check the sybase probe requirements at:
...especially these sections:
- Installation Considerations
- Configure Sybase Library Path
- User ID Authorization
- Advanced Mode
- ASE Configuration
- Migration Considerations
- Known Issues and Workarounds
1) Go to the hub server where the robot is located and stop the Nimsoft robot watcher service
2) Go to to the DB server and stop the Nimsoft service on the client server
3) cd to ...\Nimsoft\hub and take a backup copy of the robot.sds file
4) Remove the robot.sds (robot.sds will get recreated upon robot startup)
5) Start the Nimsoft robot watcher service on the hub server
6) Start the Nimsoft robot watcher service on the DB server
7) Deactivate the sybase probe
8) Deactivate the robot
9) Delete the robot 'niscache' folder
10) Activate the robot
11) Activate the sybase probe
Ask your Sybase DBA to make sure the Sybase Database server is up to date on all patches and patch if necessary.
If you disabled the log_size checkpoint in the sybase probe, reenable the checkpoint after the Sybase database server is patched and restarted.
Afterwards, there should be no further incidents of multiple Monitoring ID sessions on that respective DB server.
For the other issue in this environment as described, with robot selected but no probes showing in the view, note that the
As part of hub defect DE459104, deviceId was used for checking robot uniqueness at hub level to handle robot name change. This caused issues in IM in certain environments where there was a possibility of duplicate deviceIDs.
To resolve this issue in the context of the sybase environment and multiple connection issue, download and deploy hub v9.33_HF11.
1. Import the zip into the local archive.
2. Deploy the imported package to the Primary hub robot system and other hubs.
After deployment of the hub package,clear the niscache and Robot Device ID again and restart the robot and this robot/probe display issue should be resolved.