dhis2-devs team mailing list archive

[Aamer Mohammed <aamerm@xxxxxxxxxxxxxxxx>]

Hi Lars,

Thanks for the fix (removal of constraint). Yes we are trying to import the
metadata into a new 2.24 db. The metadata is exported from an instance
which is upgraded from 2.21 to 2.24.

1) After your fix, there is no constraint violation error and we are able
to continue further. But this time we got the below issue in the later part
of the import.
-----------
* INFO  2016-10-06 11:46:09,906 (admin) Creating 1003 object(s) of type
ReportTable (DefaultObjectBundleService.java [qtp923727115-15])
org.hibernate.TransientObjectException: object references an unsaved
transient instance - save the transient instance before flushing:
org.hisp.dhis.dataelement.DataElement
------------

The complete stack trace is also attached. Any suggestions please.


Thanks
Aamer.


On Tue, Oct 4, 2016 at 1:23 PM, Lars Helge Øverland <lars@xxxxxxxxx> wrote:

> Hi Aamer,
>
>
> On Thu, Sep 29, 2016 at 1:31 PM, Aamer Mohammed <aamerm@xxxxxxxxxxxxxxxx>
> wrote:
>
>> Hi,
>>
>> For continuation of testing, we changed the metadata to ensure that a
>> Group can be part of only one GroupSet.
>> 1) We got the below issue.
>> {"status":"ERROR","stats":{"total":1,"created":0,"updated":
>> 0,"deleted":0,"ignored":1},"typeReports":[{"klass":"org.hisp
>> .dhis.indicator.Indicator","stats":{"total":1,"created":0,
>> "updated":0,"deleted":0,"ignored":1},"objectReports":[{"
>> klass":"org.hisp.dhis.indicator.Indicator","index":277,"uid"
>> :"oMbElS3lhOO","errorReports":[{"message":"Missing required property
>> `numerator`.","mainKlass":"org.hisp.dhis.indicator.Indicator
>> ","errorKlass":"java.lang.String","errorCode":"E4000"}]}]}]}
>>
>> which means that Numerator is required field for an indicator. This was
>> not the case in 2.21. This restriction was introduced in some version after
>> 2.21. However, we modified the metadata for the indicator having this issue
>> and proceeded further.
>>
>>
> Right, we did make indicator numerator and denominator not-null in the
> schema. You can say that this is something we should have done from the
> very start. In 2.24 we tightened up the schema, which is very helpful to
> avoid problems in the source code, but could require some modifications in
> existing solutions.
>
>
>
>
>> 2) Now we got the below issue.
>> {"httpStatus":"Internal Server Error","httpStatusCode":500,"s
>> tatus":"ERROR","message":"ERROR: duplicate key value violates unique
>> constraint \"dataelement_operand_unique_key\"\n  Detail: Key
>> (dataelementid, categoryoptioncomboid)=(4497, 3576) already exists."}
>>
>> This means that you cannot have duplicate combination of (dataelementid,
>> categoryoptioncomboid) in dataelementoperand table. This constraint was not
>> present in 2.21 version.
>> When we see dataelementoperand table, there are lot of such duplicates.
>> We would like to understand more around this constraint and why it was
>> introduced.
>> *Is there any note which has the details about the constraints being
>> introduced in a DHIS version?*
>>
>
> This is interesting because i) it has been like this for many years and
> ii) I agree this constraint should not be there. Not sure why this surfaced
> now - likely because you have started a new db. I have removed this
> constraint in master and 2.24 now.
>
>
> best regards,
>
> Lars
>
>
>> 3) Also this constraint (dataelement_operand_unique_key) is not present
>> in the instance which was upgraded from 2.21 to 2.24. But it is present in
>> the instance which is directly on 2.24. Any thoughts on this. Did the
>> constraint not get created in upgraded instance because the data was not
>> abiding to the constraint rules? What happens in a dhis upgrade if there is
>> any constraint being introduced and existing data does not confirm to the
>> constraint? Please suggest.
>>
>>
>> Thanks
>> Aamer.
>>
>>
>> On Sat, Sep 24, 2016 at 5:54 PM, Lars Helge Øverland <lars@xxxxxxxxx>
>> wrote:
>>
>>> Hi Aamer,
>>>
>>> the problem here happens because the hibernate mapping between GroupSet
>>> and Group is one-to-many, ie. a Group can only be part of one GroupSet.
>>>
>>> There is a reason for this, but it is not very good ;) When we store
>>> favorites with group sets, we need to know which dimension (GroupSet) a
>>> dimension item (Group) is part of. If the Group is part of many GroupSets,
>>> we need another link object in between to represent which dimension it is
>>> part of. This can clearly be done and this is something we plan to fix, but
>>> it is a bit of work and it requires an upgrade routine to upgrade existing
>>> databases.
>>>
>>> So I am pretty sure that is why you see these duplicates: You have
>>> groups which are part of multiple group sets. In these cases, Hibernate
>>> will create duplicate GroupSets as a result of the database integrity issue.
>>>
>>> So short term solution is to change the metadata, long term we will fix
>>> this properly and allow for many-to-many between Group and GroupSet.
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>>
>>>
>>>
>>> On Thu, Sep 15, 2016 at 7:28 AM, Morten Olav Hansen <morten@xxxxxxxxx>
>>> wrote:
>>>
>>>> Hi Aamer
>>>>
>>>> Lars knows what is wrong, he will provide a fix shortly :)
>>>>
>>>> --
>>>> Morten Olav Hansen
>>>> Senior Engineer, DHIS 2
>>>> University of Oslo
>>>> http://www.dhis2.org
>>>>
>>>> On Thu, Sep 15, 2016 at 12:26 PM, Aamer Mohammed <
>>>> aamerm@xxxxxxxxxxxxxxxx> wrote:
>>>>
>>>>> Thanks Morten. Let us know if any other details are required from our
>>>>> end in this regard.
>>>>>
>>>>> Thanks
>>>>> Aamer.
>>>>>
>>>>> On Mon, Sep 12, 2016 at 6:01 PM, Morten Olav Hansen <morten@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> That's interesting.
>>>>>>
>>>>>> @Lars any suggestions why this happens? I guess there is something
>>>>>> wrong with our mapping. Will have a look tomorrow.
>>>>>>
>>>>>> --
>>>>>> Morten Olav Hansen
>>>>>> Senior Engineer, DHIS 2
>>>>>> University of Oslo
>>>>>> http://www.dhis2.org
>>>>>>
>>>>>> On Mon, Sep 12, 2016 at 5:42 PM, Victor Garcia <vgarciabnz@xxxxxxxxx>
>>>>>> wrote:
>>>>>>
>>>>>>> Hi Morten, Sultan,
>>>>>>>
>>>>>>> I think we know the reason of duplicates: categoryOptionGroups are
>>>>>>> shared between categoryOptionGroupSets, for example, ">= 15" is
>>>>>>> used in three categoryOptionGroupSets (Paediatrics, HIV and general). In
>>>>>>> the API, categoryOptionGroups appear duplicated as many times as they are
>>>>>>> re-used.
>>>>>>>
>>>>>>> We don't know if sharing categoryOptionGroups is something to avoid,
>>>>>>> but it seems to be the cause of this issue.
>>>>>>>
>>>>>>> Regards,
>>>>>>>
>>>>>>> Víctor
>>>>>>>
>>>>>>> On 12 September 2016 at 09:41, Morten Olav Hansen <morten@xxxxxxxxx>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hi again
>>>>>>>>
>>>>>>>> Would it be possible to share your database with me? I haven't seen
>>>>>>>> this
>>>>>>>> issues anywhere else.
>>>>>>>>
>>>>>>>> --
>>>>>>>> Morten Olav Hansen
>>>>>>>> Senior Engineer, DHIS 2
>>>>>>>> University of Oslo
>>>>>>>> http://www.dhis2.org
>>>>>>>>
>>>>>>>> On Mon, Sep 12, 2016 at 2:28 PM, Sultanahamar Mohammad <
>>>>>>>> sultanm@xxxxxxxxxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>> > Hi Morten,
>>>>>>>> >
>>>>>>>> > This is what our table is showing up when we say \d dataelement.
>>>>>>>> I think
>>>>>>>> > there is nothing suspicious out here.
>>>>>>>> >
>>>>>>>> >
>>>>>>>> > ​
>>>>>>>> > Regards,
>>>>>>>> > Sultan Ahamar.
>>>>>>>> >
>>>>>>>> > On Fri, Sep 9, 2016 at 2:13 PM, Morten Olav Hansen <
>>>>>>>> morten@xxxxxxxxx>
>>>>>>>> > wrote:
>>>>>>>> >
>>>>>>>> >> I'm not sure what is causing it, but it shouldn't be allowed to
>>>>>>>> begin
>>>>>>>> >> with. Is there any constraint on the UID column in your database?
>>>>>>>> >>
>>>>>>>> >> [image: Inline image 1]
>>>>>>>> >>
>>>>>>>> >> --
>>>>>>>> >> Morten Olav Hansen
>>>>>>>> >> Senior Engineer, DHIS 2
>>>>>>>> >> University of Oslo
>>>>>>>> >> http://www.dhis2.org
>>>>>>>> >>
>>>>>>>> >> On Fri, Sep 9, 2016 at 12:31 PM, Sultanahamar Mohammad <
>>>>>>>> >> sultanm@xxxxxxxxxxxxxxxx> wrote:
>>>>>>>> >>
>>>>>>>> >>> Hi Morten,
>>>>>>>> >>>
>>>>>>>> >>> Hope you are doing good. Let us know your thoughts on the above
>>>>>>>> issue
>>>>>>>> >>> and please let us know if you need any information that you
>>>>>>>> might require.
>>>>>>>> >>>
>>>>>>>> >>> Regards,
>>>>>>>> >>> Sultan Ahamar.
>>>>>>>> >>>
>>>>>>>> >>> On Tue, Sep 6, 2016 at 6:14 PM, Sultanahamar Mohammad <
>>>>>>>> >>> sultanm@xxxxxxxxxxxxxxxx> wrote:
>>>>>>>> >>>
>>>>>>>> >>>> Hi Morten,
>>>>>>>> >>>>
>>>>>>>> >>>> We have pulled latest code from 2.24 and tried import /
>>>>>>>> export again.
>>>>>>>> >>>> We have some interesting observations
>>>>>>>> >>>>
>>>>>>>> >>>> *DB snapshot:*
>>>>>>>> >>>>
>>>>>>>> >>>>
>>>>>>>> >>>> ​
>>>>>>>> >>>> There are no duplicate items in DB. We double checked.
>>>>>>>> >>>>
>>>>>>>> >>>>
>>>>>>>> >>>>
>>>>>>>> >>>>
>>>>>>>> >>>> *Entity endpoint snapshot:*
>>>>>>>>
>>>>>>>> >>>>
>>>>>>>> >>>> ​Interestingly we found few duplicate entities when we try to
>>>>>>>> fetch
>>>>>>>> >>>> this data through the API. In Maintenance app, we are not able
>>>>>>>> to see these
>>>>>>>> >>>> duplicate entities. Does it also explain why we get repeating
>>>>>>>> entries (with
>>>>>>>> >>>> same UID's) in the full export JSON as well?  Let us know on
>>>>>>>> how to proceed
>>>>>>>> >>>> and if you need more input.
>>>>>>>> >>>>
>>>>>>>> >>>> Thanks for all the help in advance.
>>>>>>>> >>>>
>>>>>>>> >>>> Regards,
>>>>>>>> >>>> Sultan Ahamar.
>>>>>>>> >>>>
>>>>>>>> >>>>
>>>>>>>> >>>> On Tue, Sep 6, 2016 at 9:34 AM, Morten Olav Hansen <
>>>>>>>> morten@xxxxxxxxx>
>>>>>>>> >>>> wrote:
>>>>>>>> >>>>
>>>>>>>> >>>>> Hi Vanya
>>>>>>>> >>>>>
>>>>>>>> >>>>> This should now have been fixed in master and 224. It will
>>>>>>>> now do a
>>>>>>>> >>>>> global UID check first, and report back any duplicates, if it
>>>>>>>> finds a
>>>>>>>> >>>>> duplicate it will remove them from the import and report back
>>>>>>>> an
>>>>>>>> >>>>> `ErrorReport` (as it would do with other validation issues).
>>>>>>>> So if it finds
>>>>>>>> >>>>> a duplicate, you will need to set atomic mode to NONE to have
>>>>>>>> it import and
>>>>>>>> >>>>> ignore the duplicates.
>>>>>>>> >>>>>
>>>>>>>> >>>>> (btw, there was several duplicates in your file, not sure how
>>>>>>>> that
>>>>>>>> >>>>> happened.. maybe something needs to be cleaned in your source
>>>>>>>> instance)
>>>>>>>> >>>>>
>>>>>>>> >>>>> --
>>>>>>>> >>>>> Morten Olav Hansen
>>>>>>>> >>>>> Senior Engineer, DHIS 2
>>>>>>>> >>>>> University of Oslo
>>>>>>>> >>>>> http://www.dhis2.org
>>>>>>>> >>>>>
>>>>>>>> >>>>> On Mon, Sep 5, 2016 at 2:37 PM, Morten Olav Hansen <
>>>>>>>> morten@xxxxxxxxx>
>>>>>>>> >>>>> wrote:
>>>>>>>> >>>>>
>>>>>>>> >>>>>> Hi Vanya
>>>>>>>> >>>>>>
>>>>>>>> >>>>>> This should have been caught by the importer... but there
>>>>>>>> are several
>>>>>>>> >>>>>> duplicates without the file you sent me, MaO4Ik8f34O is used
>>>>>>>> in 3 category
>>>>>>>> >>>>>> option groups, same with oqeVQ71LCgY..
>>>>>>>> >>>>>>
>>>>>>>> >>>>>> I will look into making the validation process more robust..
>>>>>>>> but at
>>>>>>>> >>>>>> least you should know that this file have issues
>>>>>>>> >>>>>>
>>>>>>>> >>>>>> --
>>>>>>>> >>>>>> Morten Olav Hansen
>>>>>>>> >>>>>> Senior Engineer, DHIS 2
>>>>>>>> >>>>>> University of Oslo
>>>>>>>> >>>>>> http://www.dhis2.org
>>>>>>>> >>>>>>
>>>>>>>> >>>>>> On Mon, Sep 5, 2016 at 1:20 PM, Morten Olav Hansen <
>>>>>>>> morten@xxxxxxxxx>
>>>>>>>> >>>>>> wrote:
>>>>>>>> >>>>>>
>>>>>>>> >>>>>>> Ok, thanks Vanya, I'm looking into it now
>>>>>>>> >>>>>>>
>>>>>>>> >>>>>>> --
>>>>>>>> >>>>>>> Morten Olav Hansen
>>>>>>>> >>>>>>> Senior Engineer, DHIS 2
>>>>>>>> >>>>>>> University of Oslo
>>>>>>>> >>>>>>> http://www.dhis2.org
>>>>>>>> >>>>>>>
>>>>>>>> >>>>>>> On Thu, Sep 1, 2016 at 7:28 PM, Vanya Seth <
>>>>>>>> vanyas@xxxxxxxxxxxxxxxx>
>>>>>>>> >>>>>>> wrote:
>>>>>>>> >>>>>>>
>>>>>>>> >>>>>>>> Hi Morten
>>>>>>>> >>>>>>>>
>>>>>>>> >>>>>>>> Thanks for the response.
>>>>>>>> >>>>>>>>
>>>>>>>> >>>>>>>> We ran into another issue while trying to do a full export
>>>>>>>> and
>>>>>>>> >>>>>>>> import.
>>>>>>>> >>>>>>>>
>>>>>>>> >>>>>>>> As per the previous conversations we took care of all data
>>>>>>>> >>>>>>>> migrations (as per the new constraints on the DB- pretty
>>>>>>>> much caught by the
>>>>>>>> >>>>>>>> Importer during the validation phase itself).
>>>>>>>> >>>>>>>>
>>>>>>>> >>>>>>>> Having done that we run into this issue:
>>>>>>>> >>>>>>>> The 'categoryoptiongroup' import is failing with constraint
>>>>>>>> >>>>>>>> violation for the UID. We checked the data and there is no
>>>>>>>> repeating UID in
>>>>>>>> >>>>>>>> the  database.
>>>>>>>> >>>>>>>>
>>>>>>>> >>>>>>>> The error text is attached for your reference, as well the
>>>>>>>> payload
>>>>>>>> >>>>>>>> used for the import.
>>>>>>>> >>>>>>>>
>>>>>>>> >>>>>>>> Thanks for all the help in advance.
>>>>>>>> >>>>>>>>
>>>>>>>> >>>>>>>> Regards
>>>>>>>> >>>>>>>> Vanya
>>>>>>>> >>>>>>>>
>>>>>>>> >>>>>>>>
>>>>>>>> >>>>>>>>
>>>>>>>> >>>>>>>> On Thu, Sep 1, 2016 at 11:10 AM, Morten Olav Hansen <
>>>>>>>> >>>>>>>> morten@xxxxxxxxx> wrote:
>>>>>>>> >>>>>>>>
>>>>>>>> >>>>>>>>> Thanks Aamer, I'm looking at a similar bug right now..
>>>>>>>> seems some
>>>>>>>> >>>>>>>>> objects don't get their deps properly attached..
>>>>>>>> >>>>>>>>>
>>>>>>>> >>>>>>>>> --
>>>>>>>> >>>>>>>>> Morten Olav Hansen
>>>>>>>> >>>>>>>>> Senior Engineer, DHIS 2
>>>>>>>> >>>>>>>>> University of Oslo
>>>>>>>> >>>>>>>>> http://www.dhis2.org
>>>>>>>> >>>>>>>>>
>>>>>>>> >>>>>>>>> On Thu, Sep 1, 2016 at 12:36 PM, Aamer Mohammed <
>>>>>>>> >>>>>>>>> aamerm@xxxxxxxxxxxxxxxx> wrote:
>>>>>>>> >>>>>>>>>
>>>>>>>> >>>>>>>>>> Hi Morten,
>>>>>>>> >>>>>>>>>>
>>>>>>>> >>>>>>>>>> Please find the payload for below request
>>>>>>>> >>>>>>>>>> *curl -H "Content-Type: application/json" -X GET -u
>>>>>>>> >>>>>>>>>> username:password
>>>>>>>> >>>>>>>>>> "http://localhost:8888/api/24/
>>>>>>>> metadata?filter=created:gt:2016-07
>>>>>>>> >>>>>>>>>> <http://localhost:8888/api/24/
>>>>>>>> metadata?filter=created:gt:2016-07>" >
>>>>>>>> >>>>>>>>>> metadata.224.newapi.created.json*
>>>>>>>> >>>>>>>>>>
>>>>>>>> >>>>>>>>>> Import the payload in a fresh instance for import using
>>>>>>>> >>>>>>>>>>
>>>>>>>> >>>>>>>>>> *curl -H "Content-Type: application/json" -X POST --data
>>>>>>>> >>>>>>>>>> @metadata.224.newapi.created.json -u admin:district
>>>>>>>> >>>>>>>>>> “http://localhost:8080/api/24/metadata?atomicMode=NONE
>>>>>>>> >>>>>>>>>> <http://localhost:8080/api/24/metadata?atomicMode=NONE>”
>>>>>>>> >
>>>>>>>> >>>>>>>>>> output_created_besteffort.txt*
>>>>>>>> >>>>>>>>>>
>>>>>>>> >>>>>>>>>> If the same payload is run with atomicMode=ALL, I am
>>>>>>>> getting
>>>>>>>> >>>>>>>>>> 'Invalid references' errors which is acceptable. But if
>>>>>>>> it is run with
>>>>>>>> >>>>>>>>>> atomicMode=NONE, it is throwing the error for which the
>>>>>>>> complete stack
>>>>>>>> >>>>>>>>>> trace is attached earlier. filename: '
>>>>>>>> >>>>>>>>>> *output_created_besteffort_trace.txt'*
>>>>>>>>
>>>>>>>> >>>>>>>>>>
>>>>>>>> >>>>>>>>>> Let me know if the complete payload or any other details
>>>>>>>> are
>>>>>>>> >>>>>>>>>> required from my end.
>>>>>>>> >>>>>>>>>>
>>>>>>>> >>>>>>>>>>
>>>>>>>> >>>>>>>>>> Thanks
>>>>>>>> >>>>>>>>>> Aamer.
>>>>>>>> >>>>>>>>>>
>>>>>>>> >>>>>>>>>>
>>>>>>>> >>>>>>>>>>
>>>>>>>> >>>>>>>>>> On Thu, Sep 1, 2016 at 8:52 AM, Morten Olav Hansen <
>>>>>>>> >>>>>>>>>> morten@xxxxxxxxx> wrote:
>>>>>>>> >>>>>>>>>>
>>>>>>>> >>>>>>>>>>> Hi Aamer
>>>>>>>> >>>>>>>>>>>
>>>>>>>> >>>>>>>>>>> Could you please share the payload of the object where
>>>>>>>> this
>>>>>>>> >>>>>>>>>>> happen?
>>>>>>>> >>>>>>>>>>>
>>>>>>>> >>>>>>>>>>> --
>>>>>>>> >>>>>>>>>>> Morten Olav Hansen
>>>>>>>> >>>>>>>>>>> Senior Engineer, DHIS 2
>>>>>>>> >>>>>>>>>>> University of Oslo
>>>>>>>> >>>>>>>>>>> http://www.dhis2.org
>>>>>>>> >>>>>>>>>>>
>>>>>>>> >>>>>>>>>>> On Fri, Aug 26, 2016 at 9:13 PM, Aamer Mohammed <
>>>>>>>> >>>>>>>>>>> aamerm@xxxxxxxxxxxxxxxx> wrote:
>>>>>>>> >>>>>>>>>>>
>>>>>>>> >>>>>>>>>>>> Hi Morten,
>>>>>>>> >>>>>>>>>>>>
>>>>>>>> >>>>>>>>>>>> The Importer was run with atomicMode=ALL. Though the
>>>>>>>> payload is
>>>>>>>> >>>>>>>>>>>> huge, only few errors were shown in ImportSummary. As
>>>>>>>> per errors in
>>>>>>>> >>>>>>>>>>>> previous ImportSummary, I have done below.
>>>>>>>> >>>>>>>>>>>> 1) ensured the 'short name' field is unique for each
>>>>>>>> of the
>>>>>>>> >>>>>>>>>>>> 'data elements' and 'data element group' as well
>>>>>>>> >>>>>>>>>>>> 2) UID of admin, Super User, tracked entity was
>>>>>>>> changed in
>>>>>>>> >>>>>>>>>>>> payload to be same to where it is getting imported.
>>>>>>>> >>>>>>>>>>>> I have manually resolved them and ran the importer
>>>>>>>> again with
>>>>>>>> >>>>>>>>>>>> atomicMode=ALL.
>>>>>>>> >>>>>>>>>>>>
>>>>>>>> >>>>>>>>>>>> I got exception as attached in trace file
>>>>>>>> >>>>>>>>>>>> 'output_besteffort_trace.txt'
>>>>>>>> >>>>>>>>>>>> Would these kind of issues be known only after the
>>>>>>>> import has
>>>>>>>> >>>>>>>>>>>> failed? and we need to resolve them one-by-one and
>>>>>>>> as-and-when the importer
>>>>>>>> >>>>>>>>>>>> throws them? Is there any note which has the details
>>>>>>>> about the constraints
>>>>>>>> >>>>>>>>>>>> being introduced in a new DHIS version?
>>>>>>>> >>>>>>>>>>>>
>>>>>>>> >>>>>>>>>>>> Alternatively, If we export a filtered set of metadata
>>>>>>>> using '
>>>>>>>> >>>>>>>>>>>> /api/24/metadata?filter=lastUpdated:gt:2016-05' and
>>>>>>>> run the
>>>>>>>> >>>>>>>>>>>> importer with atomicMode=NONE
>>>>>>>> >>>>>>>>>>>>
>>>>>>>> >>>>>>>>>>>> *curl -H "Content-Type: application/json" -X POST
>>>>>>>> --data
>>>>>>>> >>>>>>>>>>>> @metadata.224.newapi.json -u admin:district
>>>>>>>> >>>>>>>>>>>> “http://localhost:8080/api/24/metadata?atomicMode=NONE
>>>>>>>> >>>>>>>>>>>> <http://localhost:8080/api/24/metadata?atomicMode=NONE>”
>>>>>>>> >
>>>>>>>> >>>>>>>>>>>> output_created_besteffort_trace.txt*
>>>>>>>> >>>>>>>>>>>>
>>>>>>>> >>>>>>>>>>>> Getting below exception in trace. Complete trace also
>>>>>>>> attached.
>>>>>>>> >>>>>>>>>>>> -----
>>>>>>>> >>>>>>>>>>>> * INFO 2016-08-26 15:58:38,217 (admin) Creating 57
>>>>>>>> object(s) of
>>>>>>>> >>>>>>>>>>>> type ReportTable (DefaultObjectBundleService.java
>>>>>>>> >>>>>>>>>>>> [qtp289378424-12]) org.hibernate.TransientObjectE
>>>>>>>> xception:
>>>>>>>> >>>>>>>>>>>> object references an unsaved transient instance - save
>>>>>>>> the transient
>>>>>>>> >>>>>>>>>>>> instance before flushing:
>>>>>>>> org.hisp.dhis.indicator.Indicator
>>>>>>>> >>>>>>>>>>>> ------
>>>>>>>> >>>>>>>>>>>> Any suggestions please.
>>>>>>>> >>>>>>>>>>>>
>>>>>>>> >>>>>>>>>>>>
>>>>>>>> >>>>>>>>>>>> Thanks
>>>>>>>> >>>>>>>>>>>> Aamer.
>>>>>>>> >>>>>>>>>>>>
>>>>>>>> >>>>>>>>>>>>
>>>>>>>> >>>>>>>>>>>> On Tue, Aug 23, 2016 at 11:19 AM, Morten Olav Hansen <
>>>>>>>> >>>>>>>>>>>> morten@xxxxxxxxx> wrote:
>>>>>>>> >>>>>>>>>>>>
>>>>>>>> >>>>>>>>>>>>> Hi Aamer
>>>>>>>> >>>>>>>>>>>>>
>>>>>>>> >>>>>>>>>>>>> Probably what is happening is that the new database
>>>>>>>> has some
>>>>>>>> >>>>>>>>>>>>> constraints that the old one doesn't. We have had
>>>>>>>> some issues with
>>>>>>>> >>>>>>>>>>>>> hibernate in the past, and for certain databases that
>>>>>>>> means that many of
>>>>>>>> >>>>>>>>>>>>> the constraints was not applied..
>>>>>>>> >>>>>>>>>>>>>
>>>>>>>> >>>>>>>>>>>>> If you look at the messages, you will see that e.g
>>>>>>>> `shortName`
>>>>>>>> >>>>>>>>>>>>> must be unique for data elements.. the list of errors
>>>>>>>> is not big though,
>>>>>>>> >>>>>>>>>>>>> probably you can go through
>>>>>>>> [truncated for moderation]
>>>>>>>> _______________________________________________
>>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>>
>>> --
>>> Lars Helge Øverland
>>> Lead developer, DHIS 2
>>> University of Oslo
>>> Skype: larshelgeoverland
>>> lars@xxxxxxxxx
>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>
>>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> lars@xxxxxxxxx
> http://www.dhis2.org <https://www.dhis2.org/>
>
>

* WARN  2016-10-06 11:45:47,429 Authentication event AuthenticationSuccessEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@b364: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: null (LoggerListener.java [qtp923727115-15])
* INFO  2016-10-06 11:45:47,608 Skipping unknown property 'date'. (DefaultRenderService.java [qtp923727115-15])
* INFO  2016-10-06 11:45:48,677 (admin) Import:Start (DefaultMetadataImportService.java [qtp923727115-15])
* INFO  2016-10-06 11:45:48,879 (admin) Import:Preheat[REFERENCE] took 0.19 seconds (DefaultPreheatService.java [qtp923727115-15])
* INFO  2016-10-06 11:45:49,492 (admin) Import:Validation took 0.44 seconds (DefaultObjectBundleValidationService.java [qtp923727115-15])
* INFO  2016-10-06 11:45:49,502 (admin) Creating 9 object(s) of type UserAuthorityGroup (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:45:49,518 (admin) Updating 1 object(s) of type UserAuthorityGroup (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:45:49,631 (admin) Creating 735 object(s) of type User (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:45:50,165 (admin) Updating 1 object(s) of type User (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:45:50,796 (admin) Creating 33 object(s) of type UserGroup (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:45:50,991 (admin) Creating 2343 object(s) of type OrganisationUnit (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:45:53,309 (admin) Creating 6 object(s) of type OrganisationUnitLevel (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:45:53,495 (admin) Creating 73 object(s) of type OrganisationUnitGroup (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:45:57,133 (admin) Creating 9 object(s) of type OrganisationUnitGroupSet (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:45:57,246 (admin) Creating 69 object(s) of type DataElementCategoryOption (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:45:57,391 (admin) Creating 37 object(s) of type CategoryOptionGroup (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:45:57,526 (admin) Creating 12 object(s) of type CategoryOptionGroupSet (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:45:57,620 (admin) Creating 22 object(s) of type DataElementCategory (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:46:00,149 (admin) Creating 28 object(s) of type DataElementCategoryCombo (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:46:00,326 (admin) Creating 149 object(s) of type DataElementCategoryOptionCombo (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:46:00,588 (admin) Creating 1389 object(s) of type DataElement (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:46:02,471 (admin) Creating 221 object(s) of type DataElementGroup (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:46:03,676 (admin) Creating 4 object(s) of type IndicatorType (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:46:03,812 (admin) Creating 485 object(s) of type Indicator (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:46:04,517 (admin) Creating 32 object(s) of type IndicatorGroup (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:46:04,770 (admin) Creating 121 object(s) of type DataSet (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:46:06,745 (admin) Creating 673 object(s) of type Section (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:46:09,441 (admin) Creating 5 object(s) of type MetaDataFilter (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:46:09,664 (admin) Updating 1 object(s) of type TrackedEntity (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:46:09,759 (admin) Creating 1 object(s) of type Report (DefaultObjectBundleService.java [qtp923727115-15])
* INFO  2016-10-06 11:46:09,906 (admin) Creating 1003 object(s) of type ReportTable (DefaultObjectBundleService.java [qtp923727115-15])
org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing: org.hisp.dhis.dataelement.DataElement
	at org.hibernate.engine.internal.ForeignKeys.getEntityIdentifierIfNotUnsaved(ForeignKeys.java:279)
	at org.hibernate.type.EntityType.getIdentifier(EntityType.java:455)
	at org.hibernate.type.ManyToOneType.isDirty(ManyToOneType.java:281)
	at org.hibernate.type.ManyToOneType.isDirty(ManyToOneType.java:291)
	at org.hibernate.type.TypeHelper.findDirty(TypeHelper.java:296)
	at org.hibernate.persister.entity.AbstractEntityPersister.findDirty(AbstractEntityPersister.java:4126)
	at org.hibernate.event.internal.DefaultFlushEntityEventListener.dirtyCheck(DefaultFlushEntityEventListener.java:528)
	at org.hibernate.event.internal.DefaultFlushEntityEventListener.isUpdateNecessary(DefaultFlushEntityEventListener.java:215)
	at org.hibernate.event.internal.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:142)
	at org.hibernate.event.internal.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:216)
	at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:85)
	at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:44)
	at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1264)
	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1780)
	at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:363)
	at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:385)
	at org.hisp.dhis.period.hibernate.HibernatePeriodStore.getPeriodType(HibernatePeriodStore.java:219)
	at org.hisp.dhis.period.hibernate.HibernatePeriodStore.reloadPeriodType(HibernatePeriodStore.java:241)
	at org.hisp.dhis.period.hibernate.HibernatePeriodStore.getPeriod(HibernatePeriodStore.java:72)
	at org.hisp.dhis.period.hibernate.HibernatePeriodStore.reloadPeriod(HibernatePeriodStore.java:164)
	at org.hisp.dhis.period.hibernate.HibernatePeriodStore.reloadForceAddPeriod(HibernatePeriodStore.java:172)
	at org.hisp.dhis.period.DefaultPeriodService.reloadPeriod(DefaultPeriodService.java:259)
	at org.hisp.dhis.period.DefaultPeriodService.reloadIsoPeriod(DefaultPeriodService.java:267)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
	at com.sun.proxy.$Proxy78.reloadIsoPeriod(Unknown Source)
	at org.hisp.dhis.preheat.DefaultPreheatService.getPersistedObject(DefaultPreheatService.java:799)
	at org.hisp.dhis.preheat.DefaultPreheatService.lambda$connectReferences$91(DefaultPreheatService.java:717)
	at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175)
	at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1374)
	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
	at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
	at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418)
	at org.hisp.dhis.preheat.DefaultPreheatService.connectReferences(DefaultPreheatService.java:684)
	at sun.reflect.GeneratedMethodAccessor613.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
	at com.sun.proxy.$Proxy243.connectReferences(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor613.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
	at com.sun.proxy.$Proxy182.connectReferences(Unknown Source)
	at org.hisp.dhis.dxf2.metadata2.objectbundle.DefaultObjectBundleService.handleCreates(DefaultObjectBundleService.java:198)
	at org.hisp.dhis.dxf2.metadata2.objectbundle.DefaultObjectBundleService.commit(DefaultObjectBundleService.java:138)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
	at com.sun.proxy.$Proxy201.commit(Unknown Source)
	at org.hisp.dhis.dxf2.metadata2.DefaultMetadataImportService.importMetadata(DefaultMetadataImportService.java:104)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
	at com.sun.proxy.$Proxy203.importMetadata(Unknown Source)
	at org.hisp.dhis.webapi.controller.metadata.MetadataImportController.postJsonMetadata(MetadataImportController.java:87)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:817)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:731)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:968)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:870)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:844)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:845)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1689)
	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:201)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	at org.hisp.dhis.security.filter.CorsFilter.doFilter(CorsFilter.java:91)
	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.oauth2.provider.authentication.OAuth2AuthenticationProcessingFilter.doFilter(OAuth2AuthenticationProcessingFilter.java:140)
	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:115)
	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:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)
	at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:87)
	at org.hisp.dhis.servlet.filter.ExcludableShallowEtagHeaderFilter.doFilterInternal(ExcludableShallowEtagHeaderFilter.java:102)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)
	at org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:151)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1160)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1092)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
	at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:213)
	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:119)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
	at org.eclipse.jetty.server.Server.handle(Server.java:518)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:308)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:244)
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
	at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
	at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceAndRun(ExecuteProduceConsume.java:246)
	at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:156)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:654)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572)
	at java.lang.Thread.run(Thread.java:745)