Missing table cause rollup and purging to fail.
ManagementServer log is generating the following error message:
yyyy-mm-dd tt:tt.tt.ttt ERROR [main] com.quest.nitro.service.persistence.obs.storage.StorageManagerService - An error occurred while truncating table obs_string_xxxx: java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'foglight.obs_string_xxxx' doesn't exist
The reason how/why they were removed is unknown.
The missing table has to be recreated using the following SQL syntax:
mysql>DROP TABLE IF EXISTS `foglight`.`obs_string_xxxx`;
mysql>CREATE TABLE `foglight`.`obs_string_xxxx` (
`os_id` int(11) NOT NULL AUTO_INCREMENT,
`os_object_id` int(11) NOT NULL,
`os_observation_id` int(11) NOT NULL,
`os_start_time` bigint(20) NOT NULL,
`os_end_time` bigint(20) NOT NULL,
`os_sampled_period` bigint(20) NOT NULL,
`os_index` int(11) NOT NULL,
`os_value` longtext COLLATE utf8_bin,
PRIMARY KEY (`os_id`),
KEY `i_os_obj_type_time_0081` (`os_object_id`,`os_observation_id`,`os_end_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center