dhis2-users team mailing list archive

[Seth Reddy <seth.reddy@xxxxxxxxx>]

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