Sometimes
you could find in log file "<sysload>\spmonitor\spmwww\logs\spm_service_resource_actions.log" this error message:
DD
MM YYYY HH:MM:SS : Error retrieving resource reaction data from database. Could
not retrieve data from database. Query error. Unknown column 'resact_calendars'
in 'field list' (SELECT *,resact_calendars FROM SPM_service_resource_action)
This
message indicates that a column is missing in the table
spm_service_resource_action. This can cause problems on the reactions
associated with the resources.
You could
correct this error as follows:
• Stop
the two services 'Sysload SP Monitor Engine' and 'Sysload SP Monitor Web
Server'
•
Perform a backup of "<sysload>\spmonitor\spmwww\logs\spm_service_resource_actions.log"
•
Start mysql.exe and start and launch this query:
MySQL:
ALTER TABLE ADD spm_service_resource_action resact_calendars text CHARACTER SET
latin1 COLLATE latin1_bin NOT NULL
SQL:
ALTER TABLE ADD spm_service_resource_action resact_calendars text CHARACTER SET
latin1 COLLATE latin1_bin NOT NULL default ''
• Restart the two services 'Sysload SP Monitor Engine'
and 'Sysload SP Monitor Web Server'