Sybase agents fail to start because as the agent is restarted the existing Sybase objects are not deleted. In the defined temp database (questdb), several objects already exist:
If these tables are deleted, the agent starts up fine and reports. The next time the agent is restarted, it again cannot delete the agents.
Errors similar to the following appear in the Sybase agent log.
CAUSE 1
The default database was questdb and not sybsystemprocs and the code block used to create a temporary database was run as sa and not the Foglight user.
CAUSE 2
Sybase account was different between the old and new version.
RESOLUTION 1
The default database for the Foglight user(example here: fog123) should be set to sybsystemprocs.
To check the default, issue in iSQL
exec sp_displaylogin fog123
To set an existing login's default database
exec sp_modifylogin fog123, defdb, 'sybsystemprocs'
To create a new login run the following commands as sa user (use your username and password).
Note: The new user has to have only one role: mon_role. Grant mon_role to 'username'
© ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center