dhis2-users team mailing list archive

[Mark Spohr <mhspohr@xxxxxxxxx>]

Thanks for the suggestions...
I've been playing with this today trying to get it to import and it always
gets the same error message at the start of the <orgunitrelationships>
section.  I've removed the last of the facilities and it goes through the
end of them and then errors at the same place.  I haven't found any
duplicate orgunitrelationships so don't know why it's complaining.
I'll try to deconstruct it further tomorrow.

Kind regards,
Mark

On Mon, Feb 27, 2012 at 12:35 AM, Nathan H. Omukwenyi <
nathan.omukwenyi@xxxxxxxxx> wrote:

> From the error message I could hazard a guess that there is a duplicate
> entry in the DXF file for the “Bun” OrgUnit.  Organization Unit names and
> internal IDs need to be unique.****
>
> ** **
>
> You could search through the file to find if that is true or check any
> already imported data for the presence of OrgUnits that are in the DXF file.
> ****
>
> ** **
>
> I don’t think your problem has anything to do with the amount of data you
> are importing.****
>
> ** **
>
> ** **
>
> Regards,****
>
> ** **
>
> Nathan H. Omukwenyi,****
>
> +250 7830 10 981****
>
> ** **
>
> *From:* dhis2-users-bounces+nathan.omukwenyi=gmail.com@xxxxxxxxxxxxxxxxxxx[mailto:
> dhis2-users-bounces+nathan.omukwenyi=gmail.com@xxxxxxxxxxxxxxxxxxx] *On
> Behalf Of *Mark Spohr
> *Sent:* Saturday, February 25, 2012 10:59 PM
> *To:* dhis2-users@xxxxxxxxxxxxxxxxxxx
> *Subject:* [Dhis2-users] Import dxf failed...****
>
> ** **
>
> I'm trying to import a large data set into the dhis-live so I can review
> the data and run some reports.
> I encounter an error processing the dxf file (about line 10,000 of the
> import file):
>
> (null,'Buni',null,'Buni','020302','1990-01-01',null,true,'Buni Health
> Facility',null,null,null,'2010-06-07',false),(null,'Lokuru',null,'Lokuru','020309','1990-01-01',null,true,'Lokuru
> Health
> Facility',null,null,null,'2010-06-07',false),(null,'Jella',null,'Jella','020313','1990-01-01',null,true,'Jella
> Health Facility',null,null,null,'2010-06-07',false) [23505-154]
>     at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
>     at org.h2.message.DbException.get(DbException.java:167)
>     at org.h2.message.DbException.get(DbException.java:144)
>     at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:80)
>     at org.h2.index.PageBtree.find(PageBtree.java:121)
>     at org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:146)
>     at org.h2.index.PageBtreeLeaf.addRowTry(PageBtreeLeaf.java:100)
>     at org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java:93)
>     at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:84)
>     at org.h2.table.RegularTable.addRow(RegularTable.java:127)
>     at org.h2.command.dml.Insert.insertRows(Insert.java:126)
>     at org.h2.command.dml.Insert.update(Insert.java:86)
>     at org.h2.command.CommandContainer.update(CommandContainer.java:69)
>     at org.h2.command.Command.executeUpdate(Command.java:212)
>     at
> org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:125)
>     at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:110)
>     at
> org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:295)
>     ... 7 more
>
> The dxf import file (created from dhis 2.5) looks like this:
>
> <uuid>9952BDB6-18CD-4DFB-BFF7-16B907DA2715</uuid>
> <name>Buni</name>
> <shortName>Buni</shortName>
> <code>020302</code>
> <openingDate>1990-01-01</openingDate>
> <closedDate></closedDate>
> <active>true</active>
> <comment>Buni Health Facility</comment>
> <geoCode></geoCode>
> <feature type="">
> </feature>
> <lastUpdated>2010-06-07</lastUpdated>
> </organisationUnit>
> <organisationUnit>
> <id>562</id>
> <uuid>9828E889-C99F-4B62-BBD6-C608040E89D8</uuid>
> <name>Lokuru</name>
> <shortName>Lokuru</shortName>
> <code>020309</code>
> <openingDate>1990-01-01</openingDate>
> <closedDate></closedDate>
> <active>true</active>
> <comment>Lokuru Health Facility</comment>
> <geoCode></geoCode>
> <feature type="">
> </feature>
> <lastUpdated>2010-06-07</lastUpdated>
> </organisationUnit>
> <organisationUnit>
> <id>566</id>
> <uuid>C258A163-CB4E-42AD-AD76-FD6EC5DBA10F</uuid>
> <name>Jella</name>
> <shortName>Jella</shortName>
> <code>020313</code>
> <openingDate>1990-01-01</openingDate>
> <closedDate></closedDate>
> <active>true</active>
> <comment>Jella Health Facility</comment>
> <geoCode></geoCode>
> <feature type="">
> </feature>
> <lastUpdated>2010-06-07</lastUpdated>
> </organisationUnit>
> </organisationUnits>
> <organisationUnitRelationships>
> <organisationUnitRelationship>
> <parent>879</parent>
> <child>495</child>
> </organisationUnitRelationship>
> <organisationUnitRelationship>
> <parent>879</parent>
> <child>683</child>
> </organisationUnitRelationship>
> <organisationUnitRelationship>
> <parent>879</parent>
> <child>538</child>
> </organisationUnitRelationship>
> <organisationUnitRelationship>
> <parent>879</parent>
> <child>739</child>
> </organisationUnitRelationship>
>
> Note: Jella appears to be the last facility before the transition to the
> organisationUnitRelationship set of data (which goes on for several
> thousand lines).
>
> Any ideas on the problem here?
> Is this just too much data to try to import?
>
> .Mark
>
> --
> Mark Spohr, MD****
>



-- 
Mark Spohr, MD