# DHIS2 patch release 2.37.3 is now available

**URL:** <https://community.dhis2.org/t/dhis2-patch-release-2-37-3-is-now-available/46095>\
**Category:** Announcements - Annonces\
**Tags:** patch-releases\
**Created:** [18 February 2022 12:40 UTC](https://community.dhis2.org/t/dhis2-patch-release-2-37-3-is-now-available/46095 "2022-02-18T12:40:41Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![phil](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/phil/32/26881_2.png) [@phil](https://community.dhis2.org/u/phil)\
**Post date:** [18 February 2022 12:40 UTC](https://community.dhis2.org/t/dhis2-patch-release-2-37-3-is-now-available/46095/1 "2022-02-18T12:40:41Z")

</div>

Dear all,

DHIS2 version 2.37.3 (patch release) is out with many bug fixes and enhancements.

> This patch release is the first major update to 2.37 as 2.37.1 and 2.37.2 were both hotfixes to patch the log4shell vulnerability.

This is the latest stable release for version 2.37, and supersedes releases 2.37.0 to 2.37.2.

The release note for this patch can be found here: [Patch 2.37.3 Release Note](https://github.com/dhis2/dhis2-releases/blob/master/releases/2.37/ReleaseNote-2.37.3.md).

Enjoy!

DHIS2 Release Team

| Release Information | Links |
| --- | --- |
| Release Note | [Patch 2.37.3 Release Note](https://github.com/dhis2/dhis2-releases/blob/master/releases/2.37/ReleaseNote-2.37.3.md) |
| Upgrade notes | [2.37 Upgrade notes](https://github.com/dhis2/dhis2-releases/blob/master/releases/2.37/README.md) |
| Download release and sample database | [https://www.dhis2.org/downloads](https://www.dhis2.org/downloads) |
| Documentation and Javadocs | [Home - DHIS2 Documentation](https://docs.dhis2.org/en) |
| Source code on Github | [Release 2.37.3 · dhis2/dhis2-core · GitHub](https://github.com/dhis2/dhis2-core/releases/tag/2.37.3) |
| Demo instance | [https://play.dhis2.org/2.37.3/](https://play.dhis2.org/2.37.3/) |
| Docker | `docker pull dhis2/core:2.37.3`  
_for more docker image variants see [dockerhub](https://hub.docker.com/repository/docker/dhis2/core)_ |

---

<div class="post-metadata">

**Author:** ![Pacifique\_Hategekima](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/pacifique_hategekima/32/33413_2.png) [@Pacifique\_Hategekima](https://community.dhis2.org/u/Pacifique_Hategekima)\
**Post date:** [18 February 2022 12:44 UTC](https://community.dhis2.org/t/dhis2-patch-release-2-37-3-is-now-available/46095/2 "2022-02-18T12:44:24Z")

</div>

wooow, this is very good news,

---

<div class="post-metadata">

**Author:** ![jthomas](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/jthomas/32/32752_2.png) [@jthomas](https://community.dhis2.org/u/jthomas)\
**Post date:** [19 February 2022 10:46 UTC](https://community.dhis2.org/t/dhis2-patch-release-2-37-3-is-now-available/46095/3 "2022-02-19T10:46:43Z")

</div>

Hi @phil

Recording this for future readers:

We had upgraded from a legacy 2.29 to 2.3x to 2.37.2 and was getting analytics error reported in [DHIS2-12277](https://jira.dhis2.org/browse/DHIS2-12277)

Now upgrading from 2.37.2 to 2.37.3 I got the following errors  
`ERROR: "analytics" is not partitioned`  
`ERROR: "analytics_completeness" is not partitioned`

and we had to

`drop table analytics cascade `  
`drop table analytics_completeness cascade`

to make analytics work. Is this a good fix? those tables got regenerated after we ran analytics succesfully

````auto
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create table if not exists analytics_2022 partition of analytics for values in (2022)]; nested exception is org.postgresql.util.PSQLException: ERROR: "analytics" is not partitioned

[taskScheduler-16] ERROR org.hisp.dhis.scheduling.AbstractSchedulingManager - org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create table if not exists analytics_completeness_2022 partition of analytics_completeness for values in (2022)]; nested exception is org.postgresql.util.PSQLException: ERROR: "analytics_completeness" is not partitioned```
````

---

<div class="post-metadata">

**Author:** ![phil](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/phil/32/26881_2.png) [@phil](https://community.dhis2.org/u/phil)\
**Post date:** [21 February 2022 08:31 UTC](https://community.dhis2.org/t/dhis2-patch-release-2-37-3-is-now-available/46095/4 "2022-02-21T08:31:14Z")

</div>

Hi @jthomas ,

Thanks for flagging this issue!

I _think_ your recovery actions are safe, but I’m checking with our development team to confirm, and also to see if this issue can be avoided for other users. I’ll confirm on this thread when I have more information.

Kind regards,  
Phil

---

<div class="post-metadata">

**Author:** ![dusan](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/dusan/32/31240_2.png) [@dusan](https://community.dhis2.org/u/dusan)\
**Post date:** [23 February 2022 17:51 UTC](https://community.dhis2.org/t/dhis2-patch-release-2-37-3-is-now-available/46095/5 "2022-02-23T17:51:17Z")

</div>

Hi @jthomas,  
it is valid procedure how to recover this failure. I am not really sure why this happen. Maybe you migrated to 2.37 before without starting full analytics export. Basically you can manually remove all analytics table and then start full export. Those tables are just another view on existing entities(options,data element, …).  
Kind regards,  
Dusan

---

<div class="post-metadata">

**Author:** ![jthomas](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/jthomas/32/32752_2.png) [@jthomas](https://community.dhis2.org/u/jthomas)\
**Post date:** [24 February 2022 04:02 UTC](https://community.dhis2.org/t/dhis2-patch-release-2-37-3-is-now-available/46095/6 "2022-02-24T04:02:53Z")

</div>

Thank you @phil & @dusan

After upgrade to 2.37 we had encountered issue [DHIS2-12277](https://jira.dhis2.org/browse/DHIS2-12277) hence analytics was failing halfway everytime till we upgraded to 2.37.3, may be that’s the reason? We couldn’t revert, so we waited till this patch

---

<div class="post-metadata">

**Author:** ![statisticalanalyst20](https://dhis2.b-cdn.net/letter_avatar_proxy/v4/letter/s/77aa72/32.png) [@statisticalanalyst20](https://community.dhis2.org/u/statisticalanalyst20)\
**Post date:** [1 March 2022 06:43 UTC](https://community.dhis2.org/t/dhis2-patch-release-2-37-3-is-now-available/46095/7 "2022-03-01T06:43:47Z")

</div>

Wonderful, this is very interest
