dhis2 2.18 upgrade - Event Capture and Resource table bugs

Support - Assistance technique
1

Dear All,

I have converted my dhis2 2.16 version to 2.18. Now i found two error those are given bellow.

  1. When i click on event capture and select Orgunite and select event program that time it shows

ERROR 2015-02-18 11:13:18,614 Error while executing action (ExceptionIntercept

or.java [http-apr-8085-exec-10])

java.lang.NullPointerException

at org.hisp.dhis.appcache.CacheManifest.execute(CacheManifest.java:101)

  1. When i click on create resource table that time shows error that are given bellow.

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-3])

Here i attached the log file.

Thanks and waiting for your important suggestion.

dhis2 2.18 event report loading shows bugs.txt (11.3 KB)

Resource Table build bug dhis2 2.18.txt (5.33 KB)

···

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

2

Hi Fatema,

···
  1. When i click on event capture and select Orgunite and select event program that time it shows

ERROR 2015-02-18 11:13:18,614 Error while executing action (ExceptionIntercept

or.java [http-apr-8085-exec-10])

java.lang.NullPointerException

at org.hisp.dhis.appcache.CacheManifest.execute(CacheManifest.java:101)

This has been fixed now in 2.18. Download in 40 minutes.

  1. When i click on create resource table that time shows error that are given bellow.

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-3])

For this I need to have a closer look at your database. Are you able to provide a login or dump without data privately?

regards,

Lars

3

This is caused by a server time zone issue and not the database. I had the
same problem in Gaza some weeks ago.
Morten said he would work on it. He said it had something to do with 1/2
hour time zones or something.

Fatema, a quick fix is to change the time zone of your server (I assume
this is your laptop) to something else (e.g. UTC) and run resource tables
again.

Ola

···

On 23 February 2015 at 13:23, Lars Helge Øverland <larshelge@gmail.com> wrote:

Hi Fatema,

1. When i click on event capture and select Orgunite and select event
program that time it shows
ERROR 2015-02-18 11:13:18,614 Error while executing action
(ExceptionIntercept
or.java [http-apr-8085-exec-10])
java.lang.NullPointerException
        at
org.hisp.dhis.appcache.CacheManifest.execute(CacheManifest.java:101)

This has been fixed now in 2.18. Download in 40 minutes.

2. When i click on create resource table that time shows error that are
given bellow.

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-3])

--------

For this I need to have a closer look at your database. Are you able to
provide a login or dump without data privately?

regards,

Lars