1

We have two SQL views created in DHIS2 v2.24 where one view depends on other one (say, A depends on B). We have also scheduled an automatic maintenance event every day at 12.00 a.m. Problem is DHIS2 tries to drop view B first during this automated procedure and as a result whole procedure fails including analytics table generation.

Is there a way to make DHIS2 scheduled event drop A before B in above case?

1

Currently the approach to achieve this is to rely on the alphabetical ordering of SQL view names. For the scheduled tasks, the system first drops the SQL views in reversed alphabetical order. Finally, the system regenerates the SQL views in alphabetical order.

So in your case where A depends on B, you should ensure that that the name of SQL view B comes before the name of SQL view A alphabetically. This way, the system will first drop A, then B, and when it is time to regenerate the views, first generate B, then A, and you should be good.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.