Please check previous Upgrade Notes before continuing ... |
Minyaa 4.4 includes fixes from Minyaa Reports and Minyaa Spread.
For Minyaa Reports, the bug ALKMPR-4 is relared some inconsistency in the storage of Predefined Report Config.
Some of you predefined reports may have been orphan and a clean up is required on DBMS side.
Process as follow :
Check if you are concerned by the issue :
Select * From propertystring Where id in ( Select id From propertyentry Where entity_name in('ReportConfig','reportConfig') and entity_id not in (Select report_config_id From reportentity) ); Select id, entity_id From propertyentry Where entity_name in('ReportConfig','reportConfig') and entity_id not in (Select report_config_id From reportentity); |
(SQL Statement designed for MySQL. Others DBMS may require some correction)
If previous SQL Statement returns rows, your are concerned. Then perform the following clean up of these orphan configurations ...
Delete From propertystring Where id in ( Select id From propertyentry Where entity_name in ('ReportConfig','reportConfig') and entity_id not in (Select report_config_id From reportentity) ); Delete From propertyentry Where entity_name in ('ReportConfig','reportConfig') and entity_id not in (Select report_config_id From reportentity); |
(SQL Statement designed for MySQL. Others DBMS may require some correction)
On this page: |
See also ... |