AppWorx, Dollar Universe and Sysload Community

 View Only

SP Monitor : Error "resact_calendars" in logs

  • 1.  SP Monitor : Error "resact_calendars" in logs

    Posted Oct 13, 2016 08:24 AM

    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'