: How to manage SQL views with dependencies in DHIS 2? 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

Posted in: #Dhis2

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?

10.01% popularity Vote Up Vote Down

: Innocent pop-ups and interstitials With the recent news of Goole planning to penalise pop-ups and interstitials on search result pages in Jan 2017, I became concerned as we often use Hotjar to

@Sue5673885

Posted in: #Interstitial #PopUp #Seo

1 Comments

: 301 redirected page indexes with old URL still It has been months since I redirected some pages and the URL has not updated in Google's index. I am also unable to see a cached version of

@Sue5673885

Posted in: #Indexing #Seo

1 Comments

: How is Godaddy able to sell domains for as cheap as ? I read this question which made me realize why domains are worth around . Almost a year ago, I purchased a domain from Godaddy

@Sue5673885

Posted in: #Domains

1 Comments

: Do search engines still crawl a noindex page Do search engines crawl a page that has a 'noindex' meta attribute? The reason I ask is because we have near duplicate content caused by faceted

@Sue5673885

Posted in: #DuplicateContent #Nofollow #Noindex #Seo #WebCrawlers

2 Comments

Login to post a comment!

1 Comments

Sorted by latest first Latest Oldest Best

@Candy875

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.

10% popularity Vote Up Vote Down

Feed

: How to manage SQL views with dependencies in DHIS 2? 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

More posts by @Sue5673885

: Innocent pop-ups and interstitials With the recent news of Goole planning to penalise pop-ups and interstitials on search result pages in Jan 2017, I became concerned as we often use Hotjar to

: 301 redirected page indexes with old URL still It has been months since I redirected some pages and the URL has not updated in Google's index. I am also unable to see a cached version of

: How is Godaddy able to sell domains for as cheap as ? I read this question which made me realize why domains are worth around . Almost a year ago, I purchased a domain from Godaddy

: Do search engines still crawl a noindex page Do search engines crawl a page that has a 'noindex' meta attribute? The reason I ask is because we have near duplicate content caused by faceted

Login to post a comment!

1 Comments

Back to top | Use Dark Theme