Hi everyone,
We are working with a copy of a country's DHIS2 instance to build a push
mechanism to transfer data from our databases to DHIS2. DHIS2 is
relatively new to our team and we've run into an error that our first
line of support wasn't able to answer and wanted to see if anyone here
had any advice.
We are running the following command:
curl -k
"https://[removed]/dhis/api/dataValueSets?dataSet=lyVV9bPLlVy&period=2016&orgUnit=BnmNOtKZ12G";
-H "Accept:application/json" -u [username]:[password]
and are seeing the following error in catalina.out:
==> catalina.out <==
* INFO 2016-04-06 15:12:07,665 Login success for user: 'clinipak', ip:
'127.0.0.1' (DefaultUserAuditService.java [tomcat-http-7])
* INFO 2016-04-06 15:12:07,691 'clinipak' create
org.hisp.dhis.period.Period, name: 2016, uid: 2016
(AuditLogUtil.java [tomcat-http-7])
* WARN 2016-04-06 15:12:07,693 SQL Error: 0, SQLState: 42501
(SqlExceptionHelper.java [tomcat-http-7])
* ERROR 2016-04-06 15:12:07,693 ERROR: permission denied for sequence
hibernate_sequence (SqlExceptionHelper.java [tomcat-http-7])
Apr 06, 2016 3:12:07 PM
org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [webapi] in context with path
[/dhis] threw exception [Request processing failed; nested exception
is org.hibernate.exception.SQLGrammarException: could not extract
ResultSet] with root cause
org.postgresql.util.PSQLException: ERROR: permission denied for
sequence hibernate_sequence
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
Any help is appreciated.
Thanks!
Seth
--
http://vecnacares.org
Information is Power
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
