← Back to team overview

dhis2-devs team mailing list archive

Re: Cannot create new program stage reminder template


Hi Knut and Lars,

Many thanks for such a prompt response.

Knut, thanks for the reminder about the upgrade notes; apologies, I should have been clearer: I did actually follow these upgrade instructions, noting the one SQL script (which I didn’t bother running, as at the time I hadn’t created any program rule variables, and was only using programs-with-registration anyway).  But I was wondering if any further scripts were required for the updates that have been done to 2.24, since I started with a very early release of 2.24?

Lars, I’ve unfortunately developed a proof-of-concept which I need to demonstrate in the next day or two, and I’m guessing that 2.25 isn’t yet stable enough for a client-facing demo?  (I’d need to be sure that all aspects of a complex Tracker program would run smoothly!)

In the meantime, do you have any idea why I’m getting this UID error?  What seems to be missing from that failed row?

Cheers, Sam.

From: Lars Helge Øverland <lars@xxxxxxxxx>
Date: Thursday, 6 October 2016 at 12:47
To: Sam Johnson <samuel.johnson@xxxxxxxxxx>
Cc: DHIS2 Developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Dhis2-devs] Cannot create new program stage reminder template

Hi Sam,

okay. You would probably like to know that for 2.25, the "reminder message template" functionality has been replaced by a new version referred to as "program notifications" and "program stage notifications". This is a better implementation of the notifications system and is mostly equivalent in terms of features.


Are you able to upgrade to 2.25 snapshot?

best regards,


On Thu, Oct 6, 2016 at 1:26 PM, Sam Johnson <samuel.johnson@xxxxxxxxxx<mailto:samuel.johnson@xxxxxxxxxx>> wrote:
Hi all,

I’m using a 2.24 instance which I’ve just updated to 704143a, and am attempting to create reminder templates on a repeatable program stage.  I can successfully use the front end to create this reminder on one of the program stages on play.dhis2.org/demo<http://play.dhis2.org/demo>, but when I attempt it in my own instance, I get the ‘An exception occurred’ page, with the following log entries:
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "uid" violates not-null constraint
Detail: Failing row contains (1190, null, null, null, null, ANCReminder, -1, This is a reminder that you are due to come to the clinic for a ..., null, 1, 2, 1, null, null, null).

Why would my instance not be populating this uid column?  (I’ve tested this same reminder on other program stages and on the program itself, and all attempts at saving return the same error.)

A couple of notes:

•         My instance was originally installed as 2.21, and upgraded to 2.22, 2.23 and then 2.24.

•         My user has a role with ‘ALL’ and every other authority in it, and has all programs assigned to it.

•         I’ve done all updates to 2.24 by simply replacing the .war file – were any database scripts required for any updates?

Many thanks for any help you can give, as I’m currently stuck and unable to create reminders!

Cheers, Sam.

Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland

Follow ups