dhis2-users team mailing list archive

[Jesus Solano-Roman <asolano@xxxxxxxxxxxxxxxxxx>]

Thanks.

The terminal returns an error message when I click on the appropriate
organization unit in the tree on the left sidebar of the Event Capture App.
The entire error can be found here: https://codeshare.io/ayJPvw

Otherwise, here's some lines:

org.springframework.jdbc.InvalidResultSetAccessException: Invalid column
name; nested exception is java.sql.SQLException: Invalid column name
at
org.springframework.jdbc.support.rowset.ResultSetWrappingSqlRowSet.findColumn(ResultSetWrappingSqlRowSet.java:152)
at
org.springframework.jdbc.support.rowset.ResultSetWrappingSqlRowSet.getString(ResultSetWrappingSqlRowSet.java:473)
at
org.hisp.dhis.dxf2.events.event.JdbcEventStore.getEventsGrid(JdbcEventStore.java:313)
... more lines

Caused by: java.sql.SQLException: Invalid column name
at
com.sun.rowset.CachedRowSetImpl.getColIdxByName(CachedRowSetImpl.java:1637)
at com.sun.rowset.CachedRowSetImpl.findColumn(CachedRowSetImpl.java:3028)
at
org.springframework.jdbc.support.rowset.ResultSetWrappingSqlRowSet.findColumn(ResultSetWrappingSqlRowSet.java:149)
... 127 more


Do you have any idea what this means?


Thanks so much for the help.


Antonio.


On Tue, Jul 11, 2017 at 1:46 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

> You can start it from a terminal window by doing "java -jar
> dhis2-live.jar", alternatively ./startup.sh
>
> On Jul 11, 2017 12:52 PM, "Jesus Solano-Roman" <asolano@xxxxxxxxxxxxxxxxxx>
> wrote:
>
>> Hi Knut.
>>
>> Not really. Since I'm using the Live distribution I only run a .jar file
>> that initializes everything. I don't think I can get acesss to a server
>> log. But this is the official Live distribution so the database should have
>> been set up correctly.
>>
>> Thanks,
>>
>>
>> On Tue, Jul 11, 2017 at 12:30 PM Knut Staring <knutst@xxxxxxxxx> wrote:
>>
>>> So you are running it in a terminal window, right?
>>>
>>> You should have some (server side) error messages in that window.
>>>
>>> Knut
>>>
>>> On Tue, Jul 11, 2017 at 12:07 PM, Jesus Solano-Roman <
>>> asolano@xxxxxxxxxxxxxxxxxx> wrote:
>>>
>>>> Hello all.
>>>>
>>>> I am attempting to record events using Event Capture (web app). The
>>>> event is not being saved into the browser. Right after clicking "save and
>>>> go back", the browser console shows a 500 Error:
>>>>
>>>> GET http://10.252.76.99:8082/api/26/events/query.json?orgUnit=Im
>>>> spTQPwCqd&progr…ment=dRliZ825YDk&order=lastUpdated:desc&pageSize=50&page=1&totalPages=true
>>>> 500 (Server Error)
>>>>
>>>>
>>>>    1. httpStatus:"Internal Server Error"
>>>>    2. httpStatusCode:500
>>>>    3. message:"Invalid column name"
>>>>    4. status:"ERROR"
>>>>
>>>>
>>>> I am using the DHIS2 Live implementation running locally on my Mac,
>>>> (Sierra 10.12.15). Any ideas why this is happening?
>>>>
>>>> Thanks for the help!
>>>>
>>>>
>>>> *Antonio Solano-Roman*
>>>>
>>>> Data Visualization & User Experience Design
>>>> Sabeti Lab - Broad Institute
>>>>
>>>> _______________________________________________
>>>> 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
>>>>
>>>>
>>>
>>>
>>> --
>>> Knut Staring
>>> Dept. of Informatics, University of Oslo
>>> Norway: +4791880522 <+47%20918%2080%20522>
>>> Skype: knutstar
>>> http://dhis2.org
>>>
>>