dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

I don't think so, unfortunately. Perhaps the programmessage table?

On Sun, Oct 9, 2016 at 6:55 PM, Sam Johnson <samuel.johnson@xxxxxxxxxx>
wrote:

> Hi all,
>
>
>
> Still banging my head against the wall with this one.  Is there any schema
> documentation available for DHIS2?
>
>
>
> Cheers, Sam.
>
>
>
>
>
> *From: *Dhis2-devs <dhis2-devs-bounces+samuel.johnson=qebo.co.uk@lists.
> launchpad.net> on behalf of Sam Johnson <samuel.johnson@xxxxxxxxxx>
> *Date: *Friday, 7 October 2016 at 15:11
> *To: *DHIS2 Developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>
> *Subject: *Re: [Dhis2-devs] Cannot create new program stage reminder
> template
>
>
>
> Hi all,
>
>
>
> Am still struggling with this missing UID bug on my own instance.  Does
> anyone know the name of the table into which these ProgramStage reminder
> templates are persisted?  (Is there any schema documentation available for
> DHIS2?)
>
>
>
> Cheers, Sam.
>
>
>
>
>
> *From: *Dhis2-devs <dhis2-devs-bounces+samuel.johnson=qebo.co.uk@lists.
> launchpad.net> on behalf of Sam Johnson <samuel.johnson@xxxxxxxxxx>
> *Date: *Thursday, 6 October 2016 at 13:48
> *To: *Lars Helge Øverland <lars@xxxxxxxxx>, Knut Staring <knutst@xxxxxxxxx
> >
> *Cc: *DHIS2 Developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> *Subject: *Re: [Dhis2-devs] 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.
>
>
>
> https://www.dhis2.org/225-upgrade
>
>
>
> Are you able to upgrade to 2.25 snapshot?
>
>
>
> best regards,
>
>
>
> Lars
>
>
>
>
>
>
>
>
>
>
>
> On Thu, Oct 6, 2016 at 1:26 PM, Sam Johnson <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, 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
> 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
>
> lars@xxxxxxxxx
>
> http://www.dhis2.org <https://www.dhis2.org/>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org