Sybase SAP ASE agent Home page displays "Not Collecting Eng. Summary" in red text (4302635)

Sybase SAP ASE agent Home page displays "Not Collecting Eng. Summary" in red text

Sybase SAP ASE agent Home page displays "Not Collecting Eng. Summary" in red text on Sybase dashboard headers.

CAUSE 1

The Performance collection group is not enabled. 

CAUSE 2

Sybase agent Stored procedures not installed.

-and/or-

Sybase Monitoring Parameters not Set.

CAUSE 3

The account used by the Sybase agent has other roles in addition to "mon_role"; for example, the "sa_role". This prevents temporal tables like "tempdb..fgl_sy2_deltatable" created during agent from creating properly. 

CAUSE 4

Default database is something other than sybsystemprocs

RESOLUTION 1

Enable Performance Collection group or included collections on the agent ASP and deactivate, then activate the agent(s).

RESOLUTION 2

Manually run the rapsAdmin.sql and setup_mon_tables.sql script then deactivate, then activate the agent(s).

RESOLUTION 3

Make sure that the account used by the Sybase agent only has the "mon_role" 

1. Deactivate the Sybase agent
2. Check that the Sybase user has valid permissions.
3. Manually delete any stored procedures beginning with "sp_fgl_" and the db user if they had sa.
4. Start the Sybase agent, the stored procedure script will run when the agent starts up.
5. Check the agent log file, there should be a message like "Installing new stored procedures".

RESOLUTION 4
1- Stop the Sybase SAP ASE agent.

2- Verify Default database 'sybsystemprocs'
exec sp_displaylogin USERNAME 

3- Check the default temporary database for the user, it should be tempdb
sp_tempdb 'show'
go

4- Drop all the sp_fgl_% stored procs owned by dbo

5- Run attached script rapsAdmin.sql as sa user and . Do not modify this script.

6- exec sp_fgl_adduser 'USERNAME' , 'foglightGroup'  (if the user doesn't already exist)

7- Grant mon_role to 'USERNAME'
NOTE: The user should have only one role: mon_role, use sp_displayroles USERNAME to view the roles 

8- Enable the Sybase agent

setup_mon_tables
rapsAdmin