0

Hi, While configuring database to SQl server, hosted on remote server, I am getting this error.  But while connecting to Sql Server database which was hosted in development/local machine was running without error. And I am also able to retrieve data in application from remote database by using Database Connector.   Error Message: An error occurred while initializing the Runtime: Invalid object name 'mendixsystem$version'. Stack Trace: com.mendix.m2ee.api.AdminException: An error occurred while initializing the Runtime: Invalid object name 'mendixsystem$version'.     at com.mendix.basis.impl.MxRuntimeImplBase.start(MxRuntimeImplBase.java:267) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'mendixsystem$version'.     at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1662)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:898)     at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:793)     at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7417)     at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3488)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:262)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:237)     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:715)     at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:329)     at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:329)     at com.mendix.connectionbus.modelsynchronization.analysis.mappingreaders.DatabaseModelReaderHelpers.executeQuery(DatabaseModelReaderHelpers.scala:39)     at com.mendix.connectionbus.modelsynchronization.analysis.mappingreaders.DatabaseModelReaderHelpers.executeQuery$(DatabaseModelReaderHelpers.scala:37)     at com.mendix.connectionbus.modelsynchronization.analysis.mappingreaders.SystemTableFetcher$.executeQuery(SystemTableFetcher.scala:12)     at com.mendix.connectionbus.modelsynchronization.analysis.mappingreaders.SystemTableFetcher$.readData(SystemTableFetcher.scala:23)     at com.mendix.connectionbus.modelsynchronization.analysis.SystemVersionTableUtils$.$anonfun$getSystemVersionTableContents$1(SystemVersionTableUtils.scala:69)     at scala.util.Using$.resource(Using.scala:261)     at com.mendix.connectionbus.modelsynchronization.analysis.SystemVersionTableUtils$.getSystemVersionTableContents(SystemVersionTableUtils.scala:67)     at com.mendix.connectionbus.modelsynchronization.analysis.SystemVersionTableUtils$.getVersionsAndLastSyncDate(SystemVersionTableUtils.scala:41)     at com.mendix.connectionbus.modelsynchronization.analysis.mappingreaders.DatabaseMappingReader$.getDatabaseMappingModel(DatabaseMappingReader.scala:28)     at com.mendix.connectionbus.modelsynchronization.analysis.mappingreaders.DatabaseMappingReader$.$anonfun$getDatabaseMappingModel$1(DatabaseMappingReader.scala:19)     at scala.util.Using$.resource(Using.scala:261)     at com.mendix.connectionbus.modelsynchronization.analysis.mappingreaders.DatabaseMappingReader$.getDatabaseMappingModel(DatabaseMappingReader.scala:19)     at com.mendix.connectionbus.ConnectionBusImpl.fillMappingCache(ConnectionBusImpl.scala:397)     at com.mendix.connectionbus.ConnectionBusImpl.getInitialDatabaseCommands(ConnectionBusImpl.scala:392)     at com.mendix.basis.impl.MxRuntimeImplBase.collectDdlCommands(MxRuntimeImplBase.java:370)     at com.mendix.basis.impl.MxRuntimeImplBase.doSynchronization(MxRuntimeImplBase.java:285)     at com.mendix.basis.impl.MxRuntimeImplBase.startConnectionBus(MxRuntimeImplBase.java:274)     at com.mendix.basis.impl.MxRuntimeImplBase.start(MxRuntimeImplBase.java:246)     at com.mendix.m2ee.appcontainer.actions.StartAction.startRuntime(StartAction.scala:30)     at com.mendix.m2ee.appcontainer.actions.StartAction.execute(StartAction.scala:17)     at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandlerBase.service(HttpAdminHandlerBase.java:128)     at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)     at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764)     at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:529)     at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)     at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1383)     at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176)     at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:484)     at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174)     at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1305)     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)     at org.eclipse.jetty.server.Server.handle(Server.java:563)     at org.eclipse.jetty.server.HttpChannel.lambda$handle$0(HttpChannel.java:505)     at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:762)     at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497)     at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282)     at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314)     at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)     at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:421)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:390)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:277)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.produce(AdaptiveExecutionStrategy.java:199)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:933)     at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1077)     at java.base/java.lang.Thread.run(Thread.java:834)     Edit: Database Configuration pointing to remote Host server giving Error (on running):   With Local Database setting (No error on running):    

asked 2023-04-06

1 answers