dhis2-devs team mailing list archive

[Uddin Fatema <fatemacse@xxxxxxxxx>]

Thanks Bharath Anna and Alex.

Actually i checked period table with this( 2009-12-31) startdate and there
is no duplicate period with same startdate.

Additionally, for test purpose i deleted this period from period table and
from other related table with this periodid.

Several time restart the tomcat and clear the cash.

Although, problem remain same.

"Process failed: PreparedStatementCallback; 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 constraint "_dateperiodstructure_pkey" Detail: Key
(dateperiod)=(2009-12-31) already exists.
2015-03-20 12:03:45 Generating resource tables  "

What can i do now?

On Fri, Mar 20, 2015 at 5:22 PM, Alex Tumwesigye <atumwesigye@xxxxxxxxx>
wrote:

> 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 "
>



-- 
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>