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:

 

Useful hint

See also ...

  • No labels