Hi,
I got this from the support, but the OCUM database is corrupt again. I can't delete some datasources.
Thats the hint from the support (not tested):
• mysql> select * from opm.config where name like 'NUMBER_OF_DAYS_TO_RETAIN_DATA';
+----+-------------------------------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | name | value | description |
+----+-------------------------------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 3 | NUMBER_OF_DAYS_TO_RETAIN_DATA | 390 | This is how many days we keep OPM specific data (acquisitionInfo, forecasts, incidents and change events) in the database. Anything older than this value is deleted daily. |
+----+-------------------------------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
o You can see here that the default value is 390 days. Setting this to something like 180 or 270 should be sufficient.
• mysql> update opm.config set value=270 where id=3;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
• mysql> select * from opm.config where name like 'NUMBER_OF_DAYS_TO_RETAIN_DATA';
+----+-------------------------------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | name | value | description |
+----+-------------------------------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 3 | NUMBER_OF_DAYS_TO_RETAIN_DATA | 270 | This is how many days we keep OPM specific data (acquisitionInfo, forecasts, incidents and change events) in the database. Anything older than this value is deleted daily. |
+----+-------------------------------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
Marcus