I recently upgraded a dhis2 local instance from version 2.22 to version 2.29. I tried to create and edit a few charts and tables but every time I hit the save button I get stuck on the loading message. I checked the logs and I found the error bellow:
Hi @angulube,
I think the error shows that the column analyticstype does not exist.
Qn. Did you make sequential upgrade? If yes, would you please clear cache, run maintenance and then run analytics. Let us know if this works
Qn. By sequential upgrade do you mean running the upgrade scripts? If yes, I did do so. I also cleared my cache, ran maintenance and ran analytics after starting up my upgraded local instance. I am still having the same issue.
I think I have resolved the issue. I had to manually add the column analyticstype to the programindicator table. I am now able to save and edit my pivot tables and charts. My program indicator app is also able to open now. Thank you for pointing me in the right direction @Emma_Kassy.