← Back to team overview

dhis2-users team mailing list archive

Re: Error message while entering data

 

Can you tell me more specific about it?  How could I fix it and what
revision number do you want and where to get it?  I am using dhis2 Live.

Samnang

On Thu, Apr 9, 2015 at 12:37 PM, Morten Olav Hansen <mortenoh@xxxxxxxxx>
wrote:

> 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
>>>
>>>
>>
>

PNG image


References