Sybase Agent Fails with “Permission denied… CREATE PROCEDURE” on sybsystemprocs (4379813)

When deploying or upgrading the Foglight Sybase cartridge, the agent startup fails with the following error:

Disable monitoring: Cannot install agents stored procedures; details: Permission denied, database sybsystemprocs, owner dbo. You need the following permission(s) to run this command: CREATE PROCEDURE.

This occurs when the monitoring user does not have sufficient privileges to create stored procedures in the sybsystemprocs database.

The Sybase monitoring user (e.g., monitor_user) is missing required permissions to create stored procedures such as sp_fgl_version_stage, which are essential for the Foglight agent's functionality.

This typically happens when:

• A new monitoring user is introduced.

• The Sybase cartridge is upgraded.

• The helper procedures have not yet been installed or reinstalled.

To resolve the issue:

Step 1: Run rapsAdmin.sql as sa or another user with sa_role

This script creates and installs two required helper stored procedures:

• sp_fgl_addgrant

• sp_fgl_adduser

These procedures grant the necessary permissions and add the monitoring user to all appropriate databases, including master and sybsystemprocs.

Example Command:

isql -Usa -P<password> -S<serverName> -i rapsAdmin.sql -o rapsAdmin.out

Replace <password> and <serverName> with your actual sa password and server name.

For example:

isql -Usa -PMySecretPW -SSYBASE01 -i rapsAdmin.sql -o rapsAdmin.out

See Also:

Refer to the Foglight for Sybase User and Reference Guide, section “Configuring Sybase Login Privileges”, for details.

Post-Execution Notes

• After running rapsAdmin.sql, restart the affected Sybase agent(s).

• The agent log should now show successful startup with entries such as:

  • sp_fgl_version_stage created

  • Agent connected successfully

  • Database and cartridge versions

• Re-run rapsAdmin.sql whenever a new monitoring user is created or the cartridge is upgraded.
• When creating new agents, clone default collection lists to agent-specific versions to avoid conflicts.