Database replication issue: No member selected in for column: null - null

0
We are using the database replication module to import data on a daily basis. At a certain point the following issue occurs: 2012-11-07 23:09:03.906 INFO - DBReplication: Statistics - FINAL statistics, Objects of type 'Production.Locker' created: 2430 Objects of type 'Production.Locker' synchronized: 11793 Objects of type 'Production.Locker' not found: 0 Objects of type 'Production.Locker' skipped: 0 2012-11-07 23:09:04.156 ERROR - ImportActivitySet: Failed importing activityset: 2 2012-11-07 23:09:04.156 ERROR - ImportActivitySet: com.mendix.core.CoreException: lh: No member selected in for column: null - null at DatabaseReplication.ProcessActivitySet (JavaAction : 'Call 'ImportByImportCall'') at DatabaseReplication.ProcessActivitySet.nested.4902209f-89c1-455c-8b13-8ced855f1063 [4 of 4] (SubMicroflow : 'Call 'ProcessActivitySet'') at DatabaseReplication.ProcessActivitySet (NestedLoopedMicroflow : '') Advanced stacktrace: at com.mendix.core.Core.execute(SourceFile:295) Caused by: lh: No member selected in for column: null - null at DatabaseReplication.ProcessActivitySet (JavaAction : 'Call 'ImportByImportCall'') at DatabaseReplication.ProcessActivitySet.nested.4902209f-89c1-455c-8b13-8ced855f1063 [4 of 4] (SubMicroflow : 'Call 'ProcessActivitySet'') at DatabaseReplication.ProcessActivitySet (NestedLoopedMicroflow : '') Advanced stacktrace: at mA.a(SourceFile:188) Caused by: com.mendix.core.CoreException: No member selected in for column: null - null at databasereplication.actions.ImportByMapping.InitialiseImport(ImportByMapping.java:234) at databasereplication.actions.ImportByMapping.importFromDatabaseWithImportCall(ImportByMapping.java:132) at databasereplication.actions.ImportByImportCall.executeAction(ImportByImportCall.java:55) at databasereplication.actions.ImportByImportCall.executeAction(ImportByImportCall.java:23) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hk.b(SourceFile:156) at com.mendix.core.Core.execute(SourceFile:212) at lo.a(SourceFile:70) at mA.a(SourceFile:73) at mz.executeAction(SourceFile:101) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hk.b(SourceFile:156) at com.mendix.core.Core.executeSync(SourceFile:189) at lp.a(SourceFile:71) at mA.a(SourceFile:73) at mz.executeAction(SourceFile:101) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hk.b(SourceFile:156) at com.mendix.core.Core.executeSync(SourceFile:189) at lN.a(SourceFile:66) at mA.a(SourceFile:73) at mz.executeAction(SourceFile:101) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hk.b(SourceFile:156) at com.mendix.core.Core.execute(SourceFile:291) at com.mendix.core.Core.execute(SourceFile:267) at databasereplication.actions.ImportActivitySet.executeAction(ImportActivitySet.java:45) at databasereplication.actions.ImportActivitySet.executeAction(ImportActivitySet.java:23) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hk.b(SourceFile:156) at com.mendix.core.Core.execute(SourceFile:212) at lo.a(SourceFile:70) at mA.a(SourceFile:73) at mz.executeAction(SourceFile:101) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hk.b(SourceFile:156) at com.mendix.core.Core.executeSync(SourceFile:189) at lN.a(SourceFile:66) at mA.a(SourceFile:73) at mz.executeAction(SourceFile:101) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hk.b(SourceFile:156) at com.mendix.core.Core.executeSync(SourceFile:189) at lp.a(SourceFile:71) at mA.a(SourceFile:73) at mz.executeAction(SourceFile:101) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hk.b(SourceFile:156) at com.mendix.core.Core.execute(SourceFile:212) at hp.c(SourceFile:136) at hp.run(SourceFile:103) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source) at java.util.concurrent.FutureTask.runAndReset(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) I'm trying to find out what 'No member selected in for column: null - null' means. I have checked the mapping and the data that is being imported, and I can't find any issues in both. Can anyone give me a clue about what could be wrong?
asked
1 answers
2

The message: "No member selected for column: null - null" suggests that there is an empty column in your table mapping. Because this exception is only thrown in case the reference: "ColumnMapping_MxObjectMember" is empty

Can you check your table mapping configuration for empty rows?

(or maby you've renamed an attribute?)

answered