dhis2-users team mailing list archive

[Morten Olav Hansen <mortenoh@xxxxxxxxx>]

Ok, I think this is the relevant part:
Caused by: org.h2.jdbc.JdbcSQLException: General error:
"java.lang.NullPointerException"; SQL statement:
insert into period (periodid, periodtypeid, startdate, enddate) values
(null, ?, ?, ?) [50000-181]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.message.DbException.convert(DbException.java:295)
at org.h2.command.Command.executeUpdate(Command.java:262)
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:157)
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:143)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)
... 158 more
Caused by: java.lang.NullPointerException
at org.h2.table.Column.validateConvertUpdateSequence(Column.java:285)
at org.h2.table.Table.validateConvertUpdateSequence(Table.java:725)
at org.h2.command.dml.Insert.insertRows(Insert.java:151)
at org.h2.command.dml.Insert.update(Insert.java:114)
at org.h2.command.CommandContainer.update(CommandContainer.java:78)
at org.h2.command.Command.executeUpdate(Command.java:254)
... 162 more

I think Lars will need to have a look at this one, could you also give us
the revision number? (about dhis2)

--
Morten

On Thu, Apr 9, 2015 at 11:02 AM, ENG Samnang <eng.samnang@xxxxxxxxx> wrote:

> Hi Morten,
>
> I am a newuser of DHIS2 Live and I also got error message when I am trying
> to enter data into data entry form.  I have attach you the log for your
> review.  Please kindly help to resolve it as we need it for our malaria
> program in Cambodia.
>
> Samnang
>
> On Thu, Apr 9, 2015 at 10:49 AM, Morten Olav Hansen <mortenoh@xxxxxxxxx>
> wrote:
>
>> Hi Henri
>>
>> There should always be a similar log message in your tomcat log
>> (catalina.out), could you attach this message? (or even scroll down the
>> page a bit, so we can see more of the error message)
>>
>> --
>> Morten
>>
>> On Wed, Apr 8, 2015 at 11:47 PM, henri claude moungui <
>> henrimoungui@xxxxxxxx> wrote:
>>
>>> Thank you Lars. I've tried it but it doesn't work.
>>> Here is again a printscreen of the error message.
>>>
>>> [image: Image en ligne]
>>>
>>> Henri
>>>
>>>
>>>
>>>   Le Mercredi 8 avril 2015 17h02, Lars Helge Øverland <
>>> larshelge@xxxxxxxxx> a écrit :
>>>
>>>
>>> Hi Henri,
>>>
>>> try going to apps > data admin > resource tables and run them all. We
>>> will work on making this more robust.
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>> On Wed, Apr 8, 2015 at 5:54 PM, henri claude moungui <
>>> henrimoungui@xxxxxxxx> wrote:
>>>
>>> Hello. can you help me on this issue please?
>>>
>>> Henri
>>>
>>>
>>>
>>>   Le Samedi 4 avril 2015 22h44, henri claude moungui <
>>> henrimoungui@xxxxxxxx> a écrit :
>>>
>>>
>>> Thank you. I'm using DHIS2 v 2.18, Live with H database.
>>>
>>> Henri
>>>
>>>
>>>
>>>
>>>   Le Samedi 4 avril 2015 9h51, Guy Ekani <constyekani@xxxxxxxx> a écrit
>>> :
>>>
>>>
>>> Hi Henri,
>>>
>>> Can you tell us, What version of DHIS2 do you use ? which database ?
>>>
>>> Sincerely
>>>
>>> =========================
>>> EKANI Guy
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>   Le Vendredi 3 avril 2015 8h33, henri claude moungui <
>>> henrimoungui@xxxxxxxx> a écrit :
>>>
>>>
>>> Good day.
>>> I encountered error while entering data in my form.
>>> Here is attached a copy of error messages.
>>> Thank for your help.
>>>
>>> Henri
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>> _______________________________________________
>> 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
>>
>>
>