Creating options and optionsets via api

Support - Assistance technique
1

Hi

As with most of our current metadata, this process is not documented. It does however follow the normal flow of all our metadata, which means that objects that are based on UID most be referenced, instead of directly contained.

A sample payload would be something like this:

{

“options”: [

{ “name”: “Option 1”, “code”: “option_1” },

{ “name”: “Option 2”, “code”: “option_2” },

{ “name”: “Option 3”, “code”: “option_3” }

],

“optionSets”: [

{ “name”: “Options”, “options”: [ { … here you must match either on id or code … }]

]

}

Remember that if you want to create it all in one go, and don’t have the ID, you can set matching strategy to code.

If you want to get a larger sample, you can have a look at the output from this (admin / district):

https://apps.dhis2.org/dev/api/metadata.json?assumeTrue=false&options=true&optionSets=true

The way options/optionSets have changed in 2.17 to allow for them to be translated as our other metadata.

···

–
Morten

On Thu, Sep 25, 2014 at 12:15 AM, Mahendra Kariya mahendra.kariya@thoughtworks.com wrote:

Hi,

Could you please point us to the documentation for the API to create options and option sets?

We tried searching the user manual, but couldn’t find anything.

Thanks,

Mahendra

ThoughtWorks

2

Also please note, we are moving all of the “dev” stuff to a new Developer Guide (https://www.dhis2.org/doc/snapshot/en/developer/html/dhis2_developer_manual.html) where we hope to be able to offer more up to date and more technical information in the near future.

Regards,

Jason

···

On Thu, Sep 25, 2014 at 6:05 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

Hi

As with most of our current metadata, this process is not documented. It does however follow the normal flow of all our metadata, which means that objects that are based on UID most be referenced, instead of directly contained.

A sample payload would be something like this:

{

“options”: [

{ “name”: “Option 1”, “code”: “option_1” },

{ “name”: “Option 2”, “code”: “option_2” },

{ “name”: “Option 3”, “code”: “option_3” }

],

“optionSets”: [

{ “name”: “Options”, “options”: [ { … here you must match either on id or code … }]

]

}

Remember that if you want to create it all in one go, and don’t have the ID, you can set matching strategy to code.

If you want to get a larger sample, you can have a look at the output from this (admin / district):

https://apps.dhis2.org/dev/api/metadata.json?assumeTrue=false&options=true&optionSets=true

The way options/optionSets have changed in 2.17 to allow for them to be translated as our other metadata.

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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

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

–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

–
Morten

On Thu, Sep 25, 2014 at 12:15 AM, Mahendra Kariya mahendra.kariya@thoughtworks.com wrote:

Hi,

Could you please point us to the documentation for the API to create options and option sets?

We tried searching the user manual, but couldn’t find anything.

Thanks,

Mahendra

ThoughtWorks

3

It should be there in rev 16809. Not really sure why it went away, but should be back now.

···

–
Morten

On Thu, Sep 25, 2014 at 12:26 PM, Mahendra Kariya mahendra.kariya@thoughtworks.com wrote:

Thanks Jason. We will also refer to the dev guide.

Hi Morten,

We tried to create options using the api but were not able to. (We are on r 16808 of trunk).

We posted the following payload to /api/metadata

{

“options”: [

{

  "code": "ab2d9bcef33",

  "id": "ab2d9bcef33",

  "name": "Dressings"

}

]

}

The response from DHIS is as follows.

{

"importCount": {

    "imported": 0,

    "updated": 0,

    "ignored": 0,

    "deleted": 0

}

}

DHIS logs are as below.

  • INFO 2014-09-25 10:50:07,220 User ‘admin’ started import at Thu Sep 25 10:50:07 IST 2014 (DefaultImportService.java [qtp461220547-20])
  • INFO 2014-09-25 10:50:07,220 Building object-bridge maps (preheatCache: true). (DefaultObjectBridge.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,223 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,223 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,223 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,224 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,468 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,468 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,469 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,469 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [qtp461220547-20])
  • INFO 2014-09-25 10:50:07,469 Building object-bridge maps took 0.25 seconds. (DefaultObjectBridge.java [qtp461220547-20])
  • INFO 2014-09-25 10:50:07,470 Importing 1 Options (DefaultImportService.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,470 Importer for object of type Option not found. (DefaultImportService.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,471 Can not find getter for ‘userCredentials’. (DefaultImportService.java [qtp461220547-20])
  • INFO 2014-09-25 10:50:07,472 Import done. Completed in 0.25 seconds. (DefaultImportService.java [qtp461220547-20])

On Thu, Sep 25, 2014 at 10:31 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Also please note, we are moving all of the “dev” stuff to a new Developer Guide (https://www.dhis2.org/doc/snapshot/en/developer/html/dhis2_developer_manual.html) where we hope to be able to offer more up to date and more technical information in the near future.

Regards,

Jason

On Thu, Sep 25, 2014 at 6:05 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

Hi

As with most of our current metadata, this process is not documented. It does however follow the normal flow of all our metadata, which means that objects that are based on UID most be referenced, instead of directly contained.

A sample payload would be something like this:

{

“options”: [

{ “name”: “Option 1”, “code”: “option_1” },

{ “name”: “Option 2”, “code”: “option_2” },

{ “name”: “Option 3”, “code”: “option_3” }

],

“optionSets”: [

{ “name”: “Options”, “options”: [ { … here you must match either on id or code … }]

]

}

Remember that if you want to create it all in one go, and don’t have the ID, you can set matching strategy to code.

If you want to get a larger sample, you can have a look at the output from this (admin / district):

https://apps.dhis2.org/dev/api/metadata.json?assumeTrue=false&options=true&optionSets=true

The way options/optionSets have changed in 2.17 to allow for them to be translated as our other metadata.

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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

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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

–

–
Morten

On Thu, Sep 25, 2014 at 12:15 AM, Mahendra Kariya mahendra.kariya@thoughtworks.com wrote:

Hi,

Could you please point us to the documentation for the API to create options and option sets?

We tried searching the user manual, but couldn’t find anything.

Thanks,

Mahendra

ThoughtWorks

4

Hi Morten,

We are facing the same error when loading /api/metaData.json when there are program stages in DHIS. We were able to resolve this by adding the foreign-key attribute for the programStages list in Program.hbm.xml

  <key column="programid" **foreign-key="fk_programstage_program"** />

  <list-index column="sort_order" base="1" />

  <one-to-many class="org.hisp.dhis.program.ProgramStage" />

Do let us know if you are ok with this fix.

Work on our next release for MSF is using DHIS trunk. It would be great if you could let us know when you have committed this change to DHIS trunk

Regards,

Simanta

···

On Thu, Sep 25, 2014 at 2:04 PM, Mahendra Kariya mahendra.kariya@thoughtworks.com wrote:

Thanks Morten. Its working in rev 16809. :slight_smile:

But we are facing another issue. The program stage screen is not coming up on DHIS. The program type is “Single Event Without Registration”.

We are posting the following payload to create the program stage. (We are posting sortOrder along with the program stage.)

{

“programStages”: [

{

“sortOrder”: 1,

  "id": "ab17f8e7729",

  "name": "Some Program Stage",

  "description": "Some Program Stage",

  "programStageDataElements": [

    {

      "displayInReports": true,

      "dataElement": {

        "id": "a4e69b09a1a",

        "name": "Date"

      },

      "allowProvidedElsewhere": false,

      "compulsory": false,

      "allowDateInFuture": false

    }

  ],

  "program": {

    "id": "a625b2495e7",

    "name": "Some Program"

  }

}

]

}

Here are the DHIS logs when we try to open program stage screen.

  • ERROR 2014-09-25 14:01:34,269 Exception rendering #parse(/dhis-web-maintenance-program/programStage.vm) at /main.vm[line 152, column 9] (Log4JLogChute.java [qtp166867992-134])
  • ERROR 2014-09-25 14:01:34,269 Unable to render Velocity Template, ‘/main.vm’ (CommonsLogger.java [qtp166867992-134])

org.hibernate.HibernateException: null index column for collection: org.hisp.dhis.program.Program.programStages

at org.hibernate.persister.collection.AbstractCollectionPersister.readIndex(AbstractCollectionPersister.java:818)

at org.hibernate.collection.internal.PersistentList.readFrom(PersistentList.java:402)

at org.hibernate.loader.Loader.readCollectionElement(Loader.java:1312)

at org.hibernate.loader.Loader.readCollectionElements(Loader.java:872)

at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:723)

at org.hibernate.loader.Loader.processResultSet(Loader.java:940)

at org.hibernate.loader.Loader.doQuery(Loader.java:910)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:311)

at org.hibernate.loader.Loader.loadCollection(Loader.java:2228)

at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:65)

at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:674)

at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:80)

at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:1848)

at org.hibernate.collection.internal.AbstractPersistentCollection$4.doWork(AbstractPersistentCollection.java:549)

at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:234)

at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:545)

at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:124)

at org.hibernate.collection.internal.PersistentList.iterator(PersistentList.java:138)

at org.apache.velocity.util.introspection.UberspectImpl.getIterator(UberspectImpl.java:116)

at org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:327)

at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207)

at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)

at org.apache.velocity.runtime.directive.Parse.render(Parse.java:260)

at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207)

at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)

at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)

at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:106)

at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)

at org.apache.velocity.Template.merge(Template.java:356)

at org.apache.velocity.Template.merge(Template.java:260)

at org.apache.struts2.dispatcher.VelocityResult.doExecute(VelocityResult.java:156)

at org.apache.struts2.dispatcher.StrutsResultSupport.execute(StrutsResultSupport.java:186)

at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:371)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:275)

at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:88)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:89)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:97)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:147)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:83)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:81)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:85)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:113)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:127)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:136)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:254)

at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:110)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)

at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:562)

at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)

at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:64)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:113)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:57)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)

at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)

at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:152)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)

at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)

at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)

at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)

at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)

at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)

at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)

at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)

at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)

at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110)

at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)

at org.eclipse.jetty.server.Server.handle(Server.java:485)

at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:290)

at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)

at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)

at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:606)

at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:535)

at java.lang.Thread.run(Thread.java:724)

  • ERROR 2014-09-25 14:01:34,272 Error while executing action (ExceptionInterceptor.java [qtp166867992-134])

org.hibernate.HibernateException: null index column for collection: org.hisp.dhis.program.Program.programStages

at org.hibernate.persister.collection.AbstractCollectionPersister.readIndex(AbstractCollectionPersister.java:818)

at org.hibernate.collection.internal.PersistentList.readFrom(PersistentList.java:402)

at org.hibernate.loader.Loader.readCollectionElement(Loader.java:1312)

at org.hibernate.loader.Loader.readCollectionElements(Loader.java:872)

at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:723)

at org.hibernate.loader.Loader.processResultSet(Loader.java:940)

at org.hibernate.loader.Loader.doQuery(Loader.java:910)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:311)

at org.hibernate.loader.Loader.loadCollection(Loader.java:2228)

at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:65)

at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:674)

at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:80)

at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:1848)

at org.hibernate.collection.internal.AbstractPersistentCollection$4.doWork(AbstractPersistentCollection.java:549)

at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:234)

at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:545)

at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:124)

at org.hibernate.collection.internal.PersistentList.iterator(PersistentList.java:138)

at org.apache.velocity.util.introspection.UberspectImpl.getIterator(UberspectImpl.java:116)

at org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:327)

at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207)

at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)

at org.apache.velocity.runtime.directive.Parse.render(Parse.java:260)

at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207)

at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)

at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)

at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:106)

at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)

at org.apache.velocity.Template.merge(Template.java:356)

at org.apache.velocity.Template.merge(Template.java:260)

at org.apache.struts2.dispatcher.VelocityResult.doExecute(VelocityResult.java:156)

at org.apache.struts2.dispatcher.StrutsResultSupport.execute(StrutsResultSupport.java:186)

at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:371)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:275)

at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:88)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:89)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:97)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:147)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:83)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:81)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:85)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:113)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:127)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:136)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:254)

at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:110)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)

at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:562)

at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)

at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:64)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:113)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:57)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)

at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)

at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:152)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)

at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)

at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)

at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)

at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)

at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)

at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)

at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)

at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)

at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110)

at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)

at org.eclipse.jetty.server.Server.handle(Server.java:485)

at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:290)

at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)

at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)

at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:606)

at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:535)

at java.lang.Thread.run(Thread.java:724)

  • WARN 2014-09-25 14:01:34,275 HHH000160: On CollectionLoadContext#cleanup, localLoadingCollectionKeys contained [1] entries (CollectionLoadContext.java [qtp166867992-134])

On Thu, Sep 25, 2014 at 12:59 PM, Morten Olav Hansen mortenoh@gmail.com wrote:

It should be there in rev 16809. Not really sure why it went away, but should be back now.

–
Morten

On Thu, Sep 25, 2014 at 12:26 PM, Mahendra Kariya mahendra.kariya@thoughtworks.com wrote:

Thanks Jason. We will also refer to the dev guide.

Hi Morten,

We tried to create options using the api but were not able to. (We are on r 16808 of trunk).

We posted the following payload to /api/metadata

{

“options”: [

{

  "code": "ab2d9bcef33",

  "id": "ab2d9bcef33",

  "name": "Dressings"

}

]

}

The response from DHIS is as follows.

{

"importCount": {

    "imported": 0,

    "updated": 0,

    "ignored": 0,

    "deleted": 0

}

}

DHIS logs are as below.

  • INFO 2014-09-25 10:50:07,220 User ‘admin’ started import at Thu Sep 25 10:50:07 IST 2014 (DefaultImportService.java [qtp461220547-20])
  • INFO 2014-09-25 10:50:07,220 Building object-bridge maps (preheatCache: true). (DefaultObjectBridge.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,223 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,223 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,223 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,224 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,468 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,468 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,469 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,469 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [qtp461220547-20])
  • INFO 2014-09-25 10:50:07,469 Building object-bridge maps took 0.25 seconds. (DefaultObjectBridge.java [qtp461220547-20])
  • INFO 2014-09-25 10:50:07,470 Importing 1 Options (DefaultImportService.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,470 Importer for object of type Option not found. (DefaultImportService.java [qtp461220547-20])
  • WARN 2014-09-25 10:50:07,471 Can not find getter for ‘userCredentials’. (DefaultImportService.java [qtp461220547-20])
  • INFO 2014-09-25 10:50:07,472 Import done. Completed in 0.25 seconds. (DefaultImportService.java [qtp461220547-20])

On Thu, Sep 25, 2014 at 10:31 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Also please note, we are moving all of the “dev” stuff to a new Developer Guide (https://www.dhis2.org/doc/snapshot/en/developer/html/dhis2_developer_manual.html) where we hope to be able to offer more up to date and more technical information in the near future.

Regards,

Jason

On Thu, Sep 25, 2014 at 6:05 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

Hi

As with most of our current metadata, this process is not documented. It does however follow the normal flow of all our metadata, which means that objects that are based on UID most be referenced, instead of directly contained.

A sample payload would be something like this:

{

“options”: [

{ “name”: “Option 1”, “code”: “option_1” },

{ “name”: “Option 2”, “code”: “option_2” },

{ “name”: “Option 3”, “code”: “option_3” }

],

“optionSets”: [

{ “name”: “Options”, “options”: [ { … here you must match either on id or code … }]

]

}

Remember that if you want to create it all in one go, and don’t have the ID, you can set matching strategy to code.

If you want to get a larger sample, you can have a look at the output from this (admin / district):

https://apps.dhis2.org/dev/api/metadata.json?assumeTrue=false&options=true&optionSets=true

The way options/optionSets have changed in 2.17 to allow for them to be translated as our other metadata.

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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

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

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

–

–
Morten

On Thu, Sep 25, 2014 at 12:15 AM, Mahendra Kariya mahendra.kariya@thoughtworks.com wrote:

Hi,

Could you please point us to the documentation for the API to create options and option sets?

We tried searching the user manual, but couldn’t find anything.

Thanks,

Mahendra

ThoughtWorks