dhis2-devs team mailing list archive

[Uddin Fatema <fatemacse@xxxxxxxxx>]

Dear Alex,

I have run this query and get two result.

select enddate,startdate,periodtypeid from period where enddate =
'2009-12-31' or startdate = '2009-12-31'

Result is

"2009-12-31";"2009-12-01";3
"2009-12-31";"2009-01-01";6

here i attached the file too.

Thanks a lot


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

> Fatema,
>
> Can you dump for me the enddate, startdate and periodtype from period
> table for that date '2009-12-31'
>
> I need to see the output of "select enddate,startdate,periodtypeid from
> period where enddate like '2009-12-31' or startdate like '2009-12-31' "
>
> Thanks.
>
> Alex
>
> On Fri, Mar 20, 2015 at 3:20 PM, Calle Hedberg <calle.hedberg@xxxxxxxxx>
> wrote:
>
>> Did you verify that all three constraints are in place on the period
>> table?
>>
>> If they are and you are 100% sure there are no duplicates, then I don't
>> know - I've had similar error messages a couple of times, but removing the
>> duplicates and re-inserting the constraint have always sorted it out.
>>
>> Clear cache (DHIS and browser), empty resource tables, re-start tomcat -
>> I'm not aware of any other tricks....
>>
>> Regards
>> Calle
>>
>> On 20 March 2015 at 14:15, Uddin Fatema <fatemacse@xxxxxxxxx> wrote:
>>
>>> Thanks Calle,
>>>
>>> I have already checked all part and this period is daily, so startdate
>>> and enddate is same 2009-12-31
>>>
>>> However, my problem is remains same
>>>
>>> What can i do.
>>>
>>>
>>> On Fri, Mar 20, 2015 at 6:11 PM, Calle Hedberg <calle.hedberg@xxxxxxxxx>
>>> wrote:
>>>
>>>> Fatema,
>>>>
>>>> note that 2009-12-31 looks like an ENDdate, not a startdate.
>>>>
>>>> Regards
>>>> Calle
>>>>
>>>> On 20 March 2015 at 14:09, Uddin Fatema <fatemacse@xxxxxxxxx> wrote:
>>>>
>>>>> 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>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> *******************************************
>>>>
>>>> Calle Hedberg
>>>>
>>>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>>>
>>>> Tel/fax (home): +27-21-685-6472
>>>>
>>>> Cell: +27-82-853-5352
>>>>
>>>> Iridium SatPhone: +8816-315-19274
>>>>
>>>> Email: calle.hedberg@xxxxxxxxx
>>>>
>>>> Skype: calle_hedberg
>>>>
>>>> *******************************************
>>>>
>>>>
>>>
>>>
>>> --
>>> 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>
>>>
>>>
>>
>>
>> --
>>
>> *******************************************
>>
>> Calle Hedberg
>>
>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>
>> Tel/fax (home): +27-21-685-6472
>>
>> Cell: +27-82-853-5352
>>
>> Iridium SatPhone: +8816-315-19274
>>
>> Email: calle.hedberg@xxxxxxxxx
>>
>> Skype: calle_hedberg
>>
>> *******************************************
>>
>>
>
>
> --
> 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>

"enddate","startdate","periodtypeid"
"2009-12-31","2009-12-01","3"
"2009-12-31","2009-01-01","6"