dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #04996
Re: Error prune period
Hi there. Again, hard to say without seeing the entire log. It sort of
stops at the point of generating the periodstructure table. Is there more
to the log?
Regards,
Jason
On Thu, Jul 31, 2014 at 11:46 AM, <rin.channara@xxxxxxxxx> wrote:
> Hi Jason,
> I am happy that when I run prune period, it doesn’t appear error in
> console and success. But when I run generate “Resource Table”. I got the UI
> still processing so long time. and the console appear like in attached file.
> DO you know what is this problem?
> NOTE:
> I am using
> -DHIS2 v2.16
> -Build revision: 16253
> -Java version: jre7
> -Database: PostgreSQL
> -OS: windows 8
>
> thank you
> channara
> *From:* channara rin <rin.channara@xxxxxxxxx>
> *Sent:* Thursday, July 31, 2014 12:37 Evening
> *To:* Jason Pickering <jason.p.pickering@xxxxxxxxx>
>
> *Cc:* DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>, DHIS 2
> Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>
> Here is the error.
>
> ERROR: update or delete on table "
> period" violates foreign key constraint "mapview_periods_periodid_fkey" on
> table
> "mapview_periods"
> Detail: Key (periodid)=(427)
>
> I might try "DELETE FROM mapview_period where periodid = 427;" in the
> database, clear your DHIS2 cache and try again.
>
>
> Best regards,
> Jason
>
>
>
> On Thu, Jul 31, 2014 at 6:33 AM, <rin.channara@xxxxxxxxx> wrote:
>
>> HI Jason,
>> I am using
>> -DHIS2 v2.16
>> -Build revision: 16253
>> -Java version: jre7
>> -Database: PostgreSQL
>> -OS: windows 8
>> plz check attached file.
>>
>> thanks
>> channara
>>
>>
>> *From:* Jason Pickering <jason.p.pickering@xxxxxxxxx>
>> *Sent:* Thursday, July 31, 2014 11:16 Morning
>> *To:* channara rin <rin.channara@xxxxxxxxx>
>> *Cc:* DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>, DHIS 2
>> Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>>
>> Hi Channara,
>> It will help if you could send the output of the console when you
>> execute the command, along with the usual (DHIS2 version, Java version,
>> OS).
>>
>> Best regards,
>> Jason
>>
>>
>>
>> On Thu, Jul 31, 2014 at 4:50 AM, <rin.channara@xxxxxxxxx> wrote:
>>
>>> Hi all developers,
>>> when I go to services→maintenance, then I checked run “prune period”, I
>>> always got the error in console. DO you know how can I solve this problem?
>>>
>>> thank you
>>> CHANNARA
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>
Follow ups
References