Invalid column name on Event Capture (error 500)

Support - Assistance technique
1

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=ImspTQPwCqd&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

2

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@broadinstitute.org 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=ImspTQPwCqd&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@lists.launchpad.net

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

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

–

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

3

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:07 PM, Jesus Solano-Roman asolano@broadinstitute.org 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=ImspTQPwCqd&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@lists.launchpad.net

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

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

–
Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

4

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@broadinstitute.org 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@gmail.com 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@broadinstitute.org 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=ImspTQPwCqd&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@lists.launchpad.net

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

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

–
Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

5

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@gmail.com 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@broadinstitute.org 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@gmail.com 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@broadinstitute.org 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=ImspTQPwCqd&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@lists.launchpad.net

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

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

–
Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org