dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

I'm getting the following SQL error when my DXF import reaches the
Organisation Units:

* INFO  10:29:26,703 Imported DataSets (DefaultDXFImportService.java
[Thread-62]                                                        )
* INFO  10:29:27,204 Imported DataSet members (DefaultDXFImportService.java
[Thr                                                        ead-62])
* ERROR 10:29:27,269 The process threw exception (ProcessExecutor.java
[Thread-6                                                        2])
java.lang.RuntimeException: Failed to insert
org.hisp.dhis.organisationunit.Orga
nisationUnit
        at
org.amplecode.quick.batchhandler.AbstractBatchHandler.insertObject(Ab
stractBatchHandler.java:158)
        at
org.hisp.dhis.importexport.converter.AbstractOrganisationUnitConverte
r.importUnique(AbstractOrganisationUnitConverter.java:52)
        at
org.hisp.dhis.importexport.converter.AbstractOrganisationUnitConverte
r.importUnique(AbstractOrganisationUnitConverter.java:39)
        at
org.hisp.dhis.importexport.converter.AbstractConverter.read(AbstractC
onverter.java:85)
        at
org.hisp.dhis.importexport.dxf.converter.OrganisationUnitConverter.re
ad(OrganisationUnitConverter.java:157)
        at
org.hisp.dhis.importexport.invoker.DefaultConverterInvoker.invokeRead
(DefaultConverterInvoker.java:45)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:182)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
        at
org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:106)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
        at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
        at $Proxy364.invokeRead(Unknown Source)
        at
org.hisp.dhis.importexport.dxf.importer.DefaultDXFImportService.parse
DXFv1(DefaultDXFImportService.java:878)
        at
org.hisp.dhis.importexport.dxf.importer.DefaultDXFImportService.impor
tData(DefaultDXFImportService.java:382)
        at
org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(Im
portInternalProcess.java:95)
        at
org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
(AbstractStatementInternalProcess.java:79)
        at
org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
(AbstractStatementInternalProcess.java:37)
        at
org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:1
25)
        at java.lang.Thread.run(Thread.java:619)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near
")"
  Position: 30
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2062)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1795)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:257)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:479)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:353)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdb
c2Statement.java:299)
        at
org.amplecode.quick.batchhandler.AbstractBatchHandler.insertObject(Ab
stractBatchHandler.java:152)
        ... 23 more


-- 
Cheers,
Knut Staring