Retour
-
Titre
Sybase agent fails to activate and start data collection error "Stored procedures are not installed" -
Description
After a new installation or upgrade, the Sybase agent fails to start.
-
Cause
In recent releases the rapsinstall scripts are kicked off automatically during cartridge install or upgrade. In some cases the automated installation of the scripts may fail.
-
Résolution
After installing the cartridge, update the Sybase account for Foglight by manually downloading and running the scripts "DB_Sybase_FirstRun_Scripts" located under Foglight | Dashboards | Administration | Agents | Cartridges | Components for Download .
- Run script rapsAdmin.sql as "sa" user. This script creates only two helper stored procedures: sp_fgl_addgrant and sp_fgl_adduser.
isql -Usa -Ppassword -SserverName -i rapsAdmin.sql -o rapsAdmin.out - Send the setup_mon_tables.sql file to your Sybase DBA for review and configuration of relevant Sybase MDA parameters.
- Run these scripts to complete the upgrade and to display the correct information on the new dashboards. For script execution instructions, see "Configuring Sybase Login Privileges" in the Foglight for Sybase User and Reference Guide. Failure to upgrade the user account results in broken agent instances.
- Once you have installed the cartridge, deploy the agent package. For complete information, see "Deploying agent packages to monitored hosts" in the Foglight Administration and Configuration Help. After upgrading the cartridge and starting the agent, the Agent log will display the database version, cartridge version, EBF leve, etc.
- Run script rapsAdmin.sql as "sa" user. This script creates only two helper stored procedures: sp_fgl_addgrant and sp_fgl_adduser.