Data Replication -custom connection

0
I am using the same connection ,same table for many different application. Its working fine. But I am getting this below Exception for one of my application. Kindly suggest me where I am doing wrong? com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: replication.ReplicationSettings$MendixReplicationException: The column: NULLPRDGRPCDENULL could not be located in the query even though it was defined. | VERSION: 20130510 at com.mendix.core.Core.execute(SourceFile:232) Caused by: com.mendix.core.CoreRuntimeException: replication.ReplicationSettings$MendixReplicationException: The column: NULLPRDGRPCDENULL could not be located in the query even though it was defined. | VERSION: 20130510 at hG.b(SourceFile:217) Caused by: replication.ReplicationSettings$MendixReplicationException: The column: NULLPRDGRPCDENULL could not be located in the query even though it was defined. | VERSION: 20130510 at databasereplication.implementation.DataManager.startSynchronizing(DataManager.java:173) at databasereplication.actions.ImportByMapping.importFromDatabase(ImportByMapping.java:114) at databasereplication.actions.ImportByMapping.executeAction(ImportByMapping.java:96) at databasereplication.actions.ImportByMapping.executeAction(ImportByMapping.java:1) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:57) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:457) at hG.b(SourceFile:206) at com.mendix.core.Core.execute(SourceFile:226) at lp.a(SourceFile:69) at mz.a(SourceFile:77) at my.a(SourceFile:155) at my.executeAction(SourceFile:98) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:57) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:457) at hG.b(SourceFile:206) at com.mendix.core.Core.execute(SourceFile:226) at gp.execute(SourceFile:186) at jf.a(SourceFile:321) at com.mendix.externalinterface.connector.RequestDispatching$Worker.a(SourceFile:170) at com.mendix.externalinterface.connector.RequestDispatching$Worker$a.a(SourceFile:161) at com.mendix.externalinterface.connector.RequestDispatching$Worker$a.apply(SourceFile:160) at akka.actor.Actor$class.apply(Actor.scala:545) at com.mendix.externalinterface.connector.RequestDispatching$Worker.apply(SourceFile:156) at akka.actor.LocalActorRef.invoke(ActorRef.scala:910) at akka.dispatch.MessageInvocation.invoke(MessageHandling.scala:25) at akka.dispatch.ExecutableMailbox$class.processMailbox(ExecutorBasedEventDrivenDispatcher.scala:223) at akka.dispatch.ExecutorBasedEventDrivenDispatcher$$anon$4.processMailbox(ExecutorBasedEventDrivenDispatcher.scala:123) at akka.dispatch.ExecutableMailbox$class.run(ExecutorBasedEventDrivenDispatcher.scala:195) at akka.dispatch.ExecutorBasedEventDrivenDispatcher$$anon$4.run(ExecutorBasedEventDrivenDispatcher.scala:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:662) at akka.dispatch.MonitorableThread.run(ThreadPoolBuilder.scala:192)
asked
1 answers
1

Those are your escape characters. When you specify your custom connection the module doesn't validate the configuration to allow for maximum flexibility so you'll have to make sure that you create a valid configuration.

In the custom settings there are check boxes that you have to configure to use escape characters in part of your query. You have checked the boxes to use escape characters for the column names. When you check the box to use an escape character you should specify the escape character you want to use.
Leaving the escape character box empty (NULL), it will use that character so instead of escaping as in a normal query: "PRDGRPCDE", it now escapes your columns by doing NULLPRDGRPCDENULL

You should specify an escape character or uncheck the boxes touse an escape character.

answered