dhis2-devs team mailing list archive

[Alex Tumwesigye <atumwesigye@xxxxxxxxx>]

Dear Fatema,

If I remember correctly, this used to be an issue in 2.16. I guess, it has
been carried to 2.18.

The problem was that, two similar dates were created and when you try to
run the resource table, that range is already created.
Query the period table directly for this date "2009-12-31", two duplicates
may exist.Please try to attempt to compare ranges for different period
types, this is where the problem is (You will encounter a range that is
meant to be for a week, yet it is assigned to daily or monthly)
If so, you may need drop it manually for the resource tables to be
generated.
Let me look for the script

Thanks.

Alex


On Fri, Mar 20, 2015 at 2:06 PM, Uddin Fatema <fatemacse@xxxxxxxxx> wrote:

> Dear All,
>
> I have upgrade our application from 2.16 to 2.18.
> However, when we generate Resource table,we have get error. the error
> short note given in bellow.
>
>  ERROR, category: RESOURCETABLE_UPDATE, t
> ime: Fri Mar 20 16:52:29 BDT 2015, message: Process failed:
> PreparedStatementCal
> lback; SQL [insert into _dateperiodstructure values
> (?,?,?,?,?,?,?,?,?,?,?,?)];
> ERROR: duplicate key value violates unique constraint
> "_dateperiodstructure_pkey
> "
>   Detail: Key (dateperiod)=(2009-12-31) already exists.; nested exception
> is org
> .postgresql.util.PSQLException: ERROR: duplicate key value violates unique
> const
> raint "_dateperiodstructure_pkey"
>   Detail: Key (dateperiod)=(2009-12-31) already exists.]
> (InMemoryNotifier.java
> [taskScheduler-1])
> * ERROR 2015-03-20 16:52:29,445 Unexpected error occurred in scheduled
> task. (Ta
> skUtils.java [taskScheduler-1])
>
> Additionally, here i attached the bug file.
>
> Could anyone please help us.
> --
> Regards,
> *Fatema Uddin*
>
> Technical Advisor (HIS)-Support to the Health Sector Program II
> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
> German House
> House 10/A-2, Road 90
> Gulshan 2, Dhaka 1212, Bangladesh
>
> T          +880 9666701000
> F          +880 28823099
> M         +880 19 6206 4721
> I           www.giz.de
> <https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.&URL=http%3a%2f%2fwww.giz.de%2f>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems -
DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don't want to be anything other than what I have been - one tree hill "