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](http://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](http://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