Error prune period

Yes. Thank. I can solve…

···

On Thu, Jul 31, 2014 at 6:33 AM, rin.channara@gmail.com 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

Sent: ‎Thursday‎, ‎July‎ ‎31‎, ‎2014 ‎11‎:‎16‎ ‎Morning
To: channara rin
Cc: DHIS 2 Users list, DHIS 2 Developers list

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@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

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

console-generate Table.txt (21.1 KB)

···

On Thu, Jul 31, 2014 at 6:33 AM, rin.channara@gmail.com 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

Sent: ‎Thursday‎, ‎July‎ ‎31‎, ‎2014 ‎11‎:‎16‎ ‎Morning
To: channara rin
Cc: DHIS 2 Users list, DHIS 2 Developers list

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@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

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@gmail.com 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

Cc: DHIS 2 Users list, DHIS 2 Developers list

From: channara rin

Sent: ‎Thursday‎, ‎July‎ ‎31‎, ‎2014 ‎12‎:‎37‎ ‎Evening
To: Jason Pickering

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@gmail.com 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

Sent: ‎Thursday‎, ‎July‎ ‎31‎, ‎2014 ‎11‎:‎16‎ ‎Morning
To: channara rin
Cc: DHIS 2 Users list, DHIS 2 Developers list

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@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

YES! now it work fine. After I waited to see log around 5mn for complete it’s task. It seem take longer than previous version.

Thank you for helping

···

On Thu, Jul 31, 2014 at 11:46 AM, rin.channara@gmail.com 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

Cc: DHIS 2 Users list, DHIS 2 Developers list

From: channara rin

Sent: ‎Thursday‎, ‎July‎ ‎31‎, ‎2014 ‎12‎:‎37‎ ‎Evening
To: Jason Pickering

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@gmail.com 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

Sent: ‎Thursday‎, ‎July‎ ‎31‎, ‎2014 ‎11‎:‎16‎ ‎Morning
To: channara rin
Cc: DHIS 2 Users list, DHIS 2 Developers list

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@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp