I don't think so, unfortunately. Perhaps the programmessage table? On Sun, Oct 9, 2016 at 6:55 PM, Sam Johnson <samuel.john...@qebo.co.uk> 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.john...@qebo.co.uk> > *Date: *Friday, 7 October 2016 at 15:11 > *To: *DHIS2 Developers <dhis2-devs@lists.launchpad.net> > > *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.john...@qebo.co.uk> > *Date: *Thursday, 6 October 2016 at 13:48 > *To: *Lars Helge Øverland <l...@dhis2.org>, Knut Staring <knu...@gmail.com > > > *Cc: *DHIS2 Developers <dhis2-devs@lists.launchpad.net> > *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 <l...@dhis2.org> > *Date: *Thursday, 6 October 2016 at 12:47 > *To: *Sam Johnson <samuel.john...@qebo.co.uk> > *Cc: *DHIS2 Developers <dhis2-devs@lists.launchpad.net> > *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.john...@qebo.co.uk> > 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@lists.launchpad.net > 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 > > l...@dhis2.org > > http://www.dhis2.org <https://www.dhis2.org/> > > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-devs@lists.launchpad.net > 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
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp