View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005969 | SymmetricDS Pro | Bug | public | 2023-09-01 19:10 | 2024-04-10 17:47 |
| Reporter | jvanmeter | Assigned To | jvanmeter | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.0 | ||||
| Target Version | 3.14.14 | Fixed in Version | 3.14.14 | ||
| Summary | 0005969: When using SQL Server Log based, you cannot select two different SQL Server Database instances | ||||
| Description | Selecting two different database instances of SQL Server when using log based replication causes an issue where it looks for the application table in the wrong database instance. | ||||
| Additional Information | This appears to be coming from the RoutingService. Stacktrace: org.jumpmind.db.sql.SqlException: com.microsoft.sqlserver.jdbc.SQLServerException: Database 'testDB' does not exist. Make sure that the name is entered correctly. at org.jumpmind.db.sql.ChangeCatalogConnectionHandler.before(ChangeCatalogConnectionHandler.java:52) at org.jumpmind.db.platform.AbstractJdbcDdlReader$6.execute(AbstractJdbcDdlReader.java:1450) at org.jumpmind.db.platform.AbstractJdbcDdlReader$6.execute(AbstractJdbcDdlReader.java:1445) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:496) at org.jumpmind.db.platform.AbstractJdbcDdlReader.getSchemaNames(AbstractJdbcDdlReader.java:1445) at org.jumpmind.db.platform.AbstractDatabasePlatform.readTableFromDatabase(AbstractDatabasePlatform.java:299) at org.jumpmind.db.platform.AbstractDatabasePlatform.getTableFromCache(AbstractDatabasePlatform.java:346) at com.jumpmind.symmetric.console.impl.du.a(TriggerRouterScreen.java:844) at com.jumpmind.symmetric.console.impl.du.x(TriggerRouterScreen.java:686) at com.jumpmind.symmetric.console.impl.dt$1.doWork(SummaryScreen.java:166) at com.jumpmind.symmetric.console.ui.common.K$1.onBackgroundDataRefresh(InProgressDialog.java:102) at com.jumpmind.symmetric.console.ui.b.a(BackgroundRefresherService.java:88) at com.jumpmind.symmetric.console.ui.b$2.run(BackgroundRefresherService.java:127) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Database 'testDB' does not exist. Make sure that the name is entered correctly. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:299) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:132) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:37) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:26) at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:3904) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7785) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3793) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:3908) at com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:4279) at org.apache.commons.dbcp2.DelegatingConnection.setCatalog(DelegatingConnection.java:825) at org.apache.commons.dbcp2.DelegatingConnection.setCatalog(DelegatingConnection.java:825) at org.jumpmind.db.sql.ChangeCatalogConnectionHandler.before(ChangeCatalogConnectionHandler.java:43) ... 19 more | ||||
| Tags | dialect: sql-server | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-09-01 19:10 | jvanmeter | New Issue | |
| 2023-09-01 19:10 | jvanmeter | Tag Attached: dialect: sql-server | |
| 2024-04-10 17:47 | jvanmeter | Assigned To | => jvanmeter |
| 2024-04-10 17:47 | jvanmeter | Status | new => closed |
| 2024-04-10 17:47 | jvanmeter | Resolution | open => fixed |
| 2024-04-10 17:47 | jvanmeter | Fixed in Version | => 3.14.14 |