Database Replicator Error with SQL syntax

0
Hi Community! I am having trouble with the Database replicator module when connecting to an MSSQL database, it appears that the SQL Syntax that the module is using is not accepted by the server (error output below), i was wondering if anyone knows how to change the actual query that is being sent to the SQL server by the module as i need to change the part where it says [SysObjects] to sys.sysobjects in the code: “SELECT  '2' AS [05908765-e] ,  '2' AS [DbId] ,  [mainTable].[name] AS [Name]  FROM [SysObjects] AS [mainTable]  WHERE  (mainTable.[type] = 'U' OR mainTable.[type] = 'V') “ Thanks for your help!   full error code: Exception synchronising database:  - -------- com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: replication.ReplicationSettings$MendixReplicationException: Could not execute query on the external database, the message is: Invalid object name 'SysObjects'., the executed query is: SELECT  '2' AS [05908765-e] ,  '2' AS [DbId] ,  [mainTable].[name] AS [Name]  FROM [SysObjects] AS [mainTable]  WHERE  (mainTable.[type] = 'U' OR mainTable.[type] = 'V')   | VERSION: Mx5_20161013     at com.mendix.basis.component.InternalCoreBase.execute(InternalCoreBase.java:418) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: replication.ReplicationSettings$MendixReplicationException: Could not execute query on the external database, the message is: Invalid object name 'SysObjects'., the executed query is: SELECT  '2' AS [05908765-e] ,  '2' AS [DbId] ,  [mainTable].[name] AS [Name]  FROM [SysObjects] AS [mainTable]  WHERE  (mainTable.[type] = 'U' OR mainTable.[type] = 'V')   | VERSION: Mx5_20161013     at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:159) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: replication.ReplicationSettings$MendixReplicationException: Could not execute query on the external database, the message is: Invalid object name 'SysObjects'., the executed query is: SELECT  '2' AS [05908765-e] ,  '2' AS [DbId] ,  [mainTable].[name] AS [Name]  FROM [SysObjects] AS [mainTable]  WHERE  (mainTable.[type] = 'U' OR mainTable.[type] = 'V')   | VERSION: Mx5_20161013     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36) Caused by: replication.ReplicationSettings$MendixReplicationException: Could not execute query on the external database, the message is: Invalid object name 'SysObjects'., the executed query is: SELECT  '2' AS [05908765-e] ,  '2' AS [DbId] ,  [mainTable].[name] AS [Name]  FROM [SysObjects] AS [mainTable]  WHERE  (mainTable.[type] = 'U' OR mainTable.[type] = 'V')   | VERSION: Mx5_20161013     at databasereplication.implementation.DatabaseDataManager.startSynchronizing(DatabaseDataManager.java:72) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'SysObjects'.     at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:865)     at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:762)     at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276)     at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1793)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:661)     at databasereplication.implementation.DatabaseDataManager.startSynchronizing(DatabaseDataManager.java:66)     at databasereplication.implementation.DbReader.SQLServerReader.processTables(SQLServerReader.java:55)     at databasereplication.actions.SyncDatabaseInfo.executeAction(SyncDatabaseInfo.java:51)     at databasereplication.actions.SyncDatabaseInfo.executeAction(SyncDatabaseInfo.java:28)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:79)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:57)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55)     at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:150)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)     at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:155)     at com.mendix.basis.component.InternalCoreBase.execute(InternalCoreBase.java:414)     at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:56)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:201)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:79)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:57)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55)     at com.mendix.basis.actionmanagement.DefaultActionMonitor$.$anonfun$run$1(CustomMonitoredAction.scala:18)     at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)     at com.mendix.basis.actionmanagement.IMonitoredAction.monitor(IMonitoredAction.scala:49)     at com.mendix.basis.actionmanagement.IMonitoredAction.monitor$(IMonitoredAction.scala:25)     at com.mendix.basis.actionmanagement.CustomMonitoredAction.monitor(CustomMonitoredAction.scala:22)     at com.mendix.basis.actionmanagement.DefaultActionMonitor$.run(CustomMonitoredAction.scala:18)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.runMonitoredAction(CoreActionHandlerImpl.scala:68)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:55)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55)     at com.mendix.basis.actionmanagement.AsyncExecution.$anonfun$call$1(AsyncExecution.scala:21)     at scala.util.Try$.apply(Try.scala:213)     at com.mendix.basis.actionmanagement.AsyncExecution.call(AsyncExecution.scala:21)     at com.mendix.basis.actionmanagement.AsyncExecution.$anonfun$execute$1(AsyncExecution.scala:17)     at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:658)     at scala.util.Success.$anonfun$map$1(Try.scala:255)     at scala.util.Success.map(Try.scala:213)     at scala.concurrent.Future.$anonfun$map$1(Future.scala:292)     at scala.concurrent.impl.Promise.liftedTree1$1(Promise.scala:33)     at scala.concurrent.impl.Promise.$anonfun$transform$1(Promise.scala:33)     at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:64)     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)     at java.lang.Thread.run(Thread.java:748)  
asked
0 answers