I found a workaround : 1) Import meta-data twice first with dry option then normal to 2.19 live 2) Meta-data detailed export from 2.19 live (separate files) 3) Import meta-data with dry run = yes to 2.19 server 4) Import meta-data option "new and update" with dry run = no and preload cache = no to 2.19 server
It works with: Data elements Indicators Sets and groups Users and users role but later need reassign roles to users do not work with: organization units If anybody tries please inform about the results. -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1474419 Title: metadata import into empty db in 2.19 dhis2 fails Status in DHIS: New Bug description: Dhis2 version: 2.19 tested: local and with the demo Sierra Leone server. OS: Local Windows 7, tomcat(-7.0.62) , postgres 9.4 browser: Firefox and Chrome. Problem statement Dhis2 version 2.19 fails to imports metadate into empty database. Goes fine with 2.18 version. How tested Test 1. Do a default meta data export in msf dhis2 data on dhis2 version 2.19. Stop tomcat, drop database , create a new empty database. 1. Start tomcat, start metadata import as admin user. 2. Check import summary, see Detailed error description below. Detailed error description Import never finishes it gets ‘stuck’ during importing of Data sets. In tomcat cat log the following is found. SEVERE: Servlet.service() for servlet [webapi] in context with path [/dhis] threw exception org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement at … (a lot of java class exceptions calls that are not helpful) Test 2, same but then with an meta data export into the Sierra Leone demo server. With same result ( as described in the detailed err description). Test 3. Same but then with 2.18 version of dhis2 installed local and with a dhis2 import with Sierra leone demo data and our data, both goes fine. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1474419/+subscriptions _______________________________________________ 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
