After upgrading to v5.8, we can not anymore import objects with a relation to an external database object.
Setup business space:
BO "Product", with attributes:
- naam (plain text)
- CompanyRemote (peer relation)
BO CompanyRemote (using existing table), attributes:
- compname (primary key, plain text)
When I import a csv like this:
Product.CompanyRemote.compname,Product.naam
Mercedes,Magic Car II
So I want to use the "compname" of my CompanyRemote as a relational key for importing Products.
But when running the import I get the message "Internal error".
Logfile gives:
2014-06-03 09:02:03,501 IMPORT Default#admin -Importing business object Product
2014-06-03 09:02:03,532 ERROR Default#admin -Error running a query to find object instance in row1 null
2014-06-03 09:02:03,544 ERROR Default#admin -Error reading input file. Importing data has been terminated.
java.lang.NullPointerException
at com.bas.basserver.executionengine.F.B(Unknown Source)
at com.bas.basserver.executionengine.F.A(Unknown Source)
at com.bas.basserver.executionengine.F.A(Unknown Source)
at com.bas.basserver.executionengine.U.A(Unknown Source)
at com.bas.basserver.executionengine.I.execute(Unknown Source)
at com.bas.basserver.executionengine.U.execute(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.importData(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.bas.basserver.bsmanager.F.B(Unknown Source)
at com.bas.basserver.bsmanager.F.A(Unknown Source)
at com.bas.basserver.bsmanager.F.A(Unknown Source)
at com.bas.basserver.iopipes.ComponentSink.processMessage(Unknown Source)
at org.openadaptor.adaptor.STPipelineController.processMessage(Unknown Source)
at com.bas.openadaptor.NonTransactionalController.processMessage(Unknown Source)
at org.openadaptor.adaptor.AbstractSimplePipe.processMessage(Unknown Source)
at org.openadaptor.adaptor.STPipelineController.processMessage(Unknown Source)
at com.bas.openadaptor.NonTransactionalController.processMessage(Unknown Source)
at org.openadaptor.adaptor.AbstractSimpleSource.processMessage(Unknown Source)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(Unknown Source)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(Unknown Source)
at com.bas.openadaptor.A$_A.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
Can this be fixed for 5.8+?
BTW: on v 4.9 this was working fine.