Sybase data is not collected due to permissions issues (4371761)

Sybase data is not collected due to permissions issues

The Sybase SAP ASE agent is installed but data cannot be seen in the panels and the logs indicate that the collections are failing.

The Sybase SAP ASE agent user was not configured correctly.

Review the steps to create the monitoring user on the Sybase SAP ASE host as detailed in the Sybase SAP ASE cartridge user guide.
https://support.quest.com/technical-documents/foglight-for-sybase/7.1.0/user-and-reference-guide/17#TOPIC-1774110

In summary
1). Create a Foglight login account in the Sybase database. For example, svcfgadmin
sp_addlogin 'svcfgadmin' , 'foglight' , sybsystemprocs
go

2).Grant the mon_role role to the account
grant role mon_role to svcfgadmin
go

3). Run the rapsAdmin.sql script as the sa user.

4). Run the sp_fgl_adduser procedure as the sa user. For example:
sp_fgl_adduser 'svcfgadmin' , 'foglightGroup'
go

The above command creates a group named foglightGroup and a user named svcfgadmin in each database, and in the sybsystemprocs database, it grants the permission for creating procedures to that user account.

5). Restart the agent

If there are any errors in the log file, then stop the agent and delete the fgl_ tables from the temp database manually in case the tables have been created with the wrong schema

drop table fgl_blocker_SQLText
go
drop table fgl_missed_SQLTest
go
drop table fgl_processes
go
drop table fgl_sy2_deltatable
go
drop table fgl_waitinfo
go

Then restart the agent again