Meta data export import

Support - Assistance technique
1

Dear DHIS2 Expert

I am trying to export selected metadata item e.g. Chart, Event Chart, Map, Map View etc from one server and want to import in another server with same data. Don’t get anything in the UI, but log showing error

Can you please advise how can solve this problem and /or how to chart, map, pivot tables from one system to another?

Regards

Hannan Khan

HISP Bangladesh

2

Hi Hannan.

Could you please share your log file with us?

I think this will be helpfull to make the community understand quickly and help you.

Henri MOUNGUI

Cameroon

···

Le Jeudi 7 janvier 2016 11h01, Hannan Khan hannank@gmail.com a écrit :

Dear DHIS2 Expert

I am trying to export selected metadata item e.g. Chart, Event Chart, Map, Map View etc from one server and want to import in another server with same data. Don’t get anything in the UI, but log showing error

Can you please advise how can solve this problem and /or how to chart, map, pivot tables from one system to another?

Regards

Hannan Khan

HISP Bangladesh

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

3

sorry don’t attach the log. Here it is.

  • INFO 2016-01-07 15:55:04,923 User ‘admin’ started import at Thu Jan 07 15:55:04 BDT 2016 (DefaultImportService.java [taskScheduler-10])

  • INFO 2016-01-07 15:55:04,924 [Level: INFO, category: METADATA_IMPORT, time: Thu Jan 07 15:55:04 BDT 2016, message: Importing meta-data] (InMemoryNotifier.java [taskScheduler-10])

  • INFO 2016-01-07 15:55:04,924 Building object-bridge maps (preheatCache: true). (DefaultObjectBridge.java [taskScheduler-10])

  • ERROR 2016-01-07 15:55:28,801 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-10])

org.hibernate.HibernateException: More than one row with the given identifier was found: 1153390, for class: org.hisp.dhis.organisationunit.OrganisationUnitGroup

at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:104)
···

On Thu, Jan 7, 2016 at 4:01 PM, Hannan Khan hannank@gmail.com wrote:

Dear DHIS2 Expert

I am trying to export selected metadata item e.g. Chart, Event Chart, Map, Map View etc from one server and want to import in another server with same data. Don’t get anything in the UI, but log showing error

Can you please advise how can solve this problem and /or how to chart, map, pivot tables from one system to another?

Regards

Hannan Khan

HISP Bangladesh

4

and DHIS2 version 19 build 19273.

I try with latest build 19286 there message is different:

  • INFO 2016-01-07 15:48:42,986 User ‘admin’ started import at Thu Jan 07 15:48:42 BDT 2016 (DefaultImportService.java [taskScheduler-1])

  • INFO 2016-01-07 15:48:42,986 [Level: INFO, category: METADATA_IMPORT, time: Thu Jan 07 15:48:42 BDT 2016, message: Importing meta-data] (InMemoryNotifier.java [taskScheduler-1])

  • INFO 2016-01-07 15:48:42,986 Building object-bridge maps (preheatCache: true). (DefaultObjectBridge.java [taskScheduler-1])

  • ERROR 2016-01-07 15:50:25,487 HHH000123: IllegalArgumentException in class: org.hisp.dhis.validation.ValidationCriteria, setter method of property: value (BasicPropertyAccessor.java [taskScheduler-1])

  • ERROR 2016-01-07 15:50:25,487 HHH000091: Expected type: java.lang.String, actual value: java.lang.Integer (BasicPropertyAccessor.java [taskScheduler-1])

  • ERROR 2016-01-07 15:50:25,509 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-1])

org.hibernate.PropertyAccessException: IllegalArgumentException occurred while calling setter of org.hisp.dhis.validation.ValidationCriteria.value

···

On Thu, Jan 7, 2016 at 4:18 PM, Hannan Khan hannank@gmail.com wrote:

sorry don’t attach the log. Here it is.

  • INFO 2016-01-07 15:55:04,923 User ‘admin’ started import at Thu Jan 07 15:55:04 BDT 2016 (DefaultImportService.java [taskScheduler-10])
  • INFO 2016-01-07 15:55:04,924 [Level: INFO, category: METADATA_IMPORT, time: Thu Jan 07 15:55:04 BDT 2016, message: Importing meta-data] (InMemoryNotifier.java [taskScheduler-10])
  • INFO 2016-01-07 15:55:04,924 Building object-bridge maps (preheatCache: true). (DefaultObjectBridge.java [taskScheduler-10])
  • ERROR 2016-01-07 15:55:28,801 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-10])

org.hibernate.HibernateException: More than one row with the given identifier was found: 1153390, for class: org.hisp.dhis.organisationunit.OrganisationUnitGroup

at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:104)

On Thu, Jan 7, 2016 at 4:01 PM, Hannan Khan hannank@gmail.com wrote:

Dear DHIS2 Expert

I am trying to export selected metadata item e.g. Chart, Event Chart, Map, Map View etc from one server and want to import in another server with same data. Don’t get anything in the UI, but log showing error

Can you please advise how can solve this problem and /or how to chart, map, pivot tables from one system to another?

Regards

Hannan Khan

HISP Bangladesh

5

Hi Hannan

Are both server using the exact same version/revision of DHIS2? There have been quite a bit of changes to the web-api payloads in 2.19/2.20/2.21, so I’m not sure how compatible they would be.

That said, it seems that there is also an issue with this:

org.hibernate.HibernateException: More than one row with the given identifier was found: 1153390, for class: org.hisp.dhis.organisationunit.OrganisationUnitGroup

Could you please share the full stack trace?

···

On Thu, Jan 7, 2016 at 5:24 PM, Hannan Khan hannank@gmail.com wrote:

and DHIS2 version 19 build 19273.

I try with latest build 19286 there message is different:

  • INFO 2016-01-07 15:48:42,986 User ‘admin’ started import at Thu Jan 07 15:48:42 BDT 2016 (DefaultImportService.java [taskScheduler-1])
  • INFO 2016-01-07 15:48:42,986 [Level: INFO, category: METADATA_IMPORT, time: Thu Jan 07 15:48:42 BDT 2016, message: Importing meta-data] (InMemoryNotifier.java [taskScheduler-1])
  • INFO 2016-01-07 15:48:42,986 Building object-bridge maps (preheatCache: true). (DefaultObjectBridge.java [taskScheduler-1])
  • ERROR 2016-01-07 15:50:25,487 HHH000123: IllegalArgumentException in class: org.hisp.dhis.validation.ValidationCriteria, setter method of property: value (BasicPropertyAccessor.java [taskScheduler-1])
  • ERROR 2016-01-07 15:50:25,487 HHH000091: Expected type: java.lang.String, actual value: java.lang.Integer (BasicPropertyAccessor.java [taskScheduler-1])
  • ERROR 2016-01-07 15:50:25,509 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-1])

org.hibernate.PropertyAccessException: IllegalArgumentException occurred while calling setter of org.hisp.dhis.validation.ValidationCriteria.value

–
Morten

On Thu, Jan 7, 2016 at 4:18 PM, Hannan Khan hannank@gmail.com wrote:

sorry don’t attach the log. Here it is.

  • INFO 2016-01-07 15:55:04,923 User ‘admin’ started import at Thu Jan 07 15:55:04 BDT 2016 (DefaultImportService.java [taskScheduler-10])
  • INFO 2016-01-07 15:55:04,924 [Level: INFO, category: METADATA_IMPORT, time: Thu Jan 07 15:55:04 BDT 2016, message: Importing meta-data] (InMemoryNotifier.java [taskScheduler-10])
  • INFO 2016-01-07 15:55:04,924 Building object-bridge maps (preheatCache: true). (DefaultObjectBridge.java [taskScheduler-10])
  • ERROR 2016-01-07 15:55:28,801 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-10])

org.hibernate.HibernateException: More than one row with the given identifier was found: 1153390, for class: org.hisp.dhis.organisationunit.OrganisationUnitGroup

at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:104)

On Thu, Jan 7, 2016 at 4:01 PM, Hannan Khan hannank@gmail.com wrote:

Dear DHIS2 Expert

I am trying to export selected metadata item e.g. Chart, Event Chart, Map, Map View etc from one server and want to import in another server with same data. Don’t get anything in the UI, but log showing error

Can you please advise how can solve this problem and /or how to chart, map, pivot tables from one system to another?

Regards

Hannan Khan

HISP Bangladesh