View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007103 | SymmetricDS Pro | Bug | public | 2025-10-23 19:23 | 2025-10-23 19:47 |
| Reporter | emiller | Assigned To | emiller | ||
| Priority | high | ||||
| Status | assigned | Resolution | open | ||
| Product Version | 3.16.0 | ||||
| Target Version | 3.16.8 | ||||
| Summary | 0007103: Adding a SQL Server table with a non-default catalog and a default schema via the Canvas results in a trigger creation failure | ||||
| Description | Adding a SQL Server table with a non-default catalog and a default schema via the Canvas results in a trigger creation failure because the trigger's schema is left blank. Below is an example of the error message: 2025-10-23 15:09:00,720 ERROR [server] [TriggerRouterService] [server-sync-triggers-1] Failed to create triggers for test_catalog.test_table org.jumpmind.db.sql.SqlException: The object 'test_catalog.test_table' does not exist or is invalid for this operation. at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:308) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:297) at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:377) at org.jumpmind.db.sql.JdbcSqlTransaction.execute(JdbcSqlTransaction.java:284) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createTrigger(AbstractSymmetricDialect.java:453) at org.jumpmind.symmetric.service.impl.TriggerRouterService.rebuildTriggerIfNecessaryWithException(TriggerRouterService.java:2540) at org.jumpmind.symmetric.service.impl.TriggerRouterService.rebuildTriggerIfNecessary(TriggerRouterService.java:2416) at org.jumpmind.symmetric.service.impl.TriggerRouterService.updateOrCreateDatabaseTriggers(TriggerRouterService.java:2367) at org.jumpmind.symmetric.service.impl.TriggerRouterService.updateOrCreateDatabaseTrigger(TriggerRouterService.java:2210) at org.jumpmind.symmetric.service.impl.TriggerRouterService$2.run(TriggerRouterService.java:2064) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The object 'test_catalog.test_table' does not exist or is invalid for this operation. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:270) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1735) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:929) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:823) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7745) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4391) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:276) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:246) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:796) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:182) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:182) at org.jumpmind.db.sql.JdbcSqlTransaction$3.execute(JdbcSqlTransaction.java:291) at org.jumpmind.db.sql.JdbcSqlTransaction$3.execute(JdbcSqlTransaction.java:1) at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:375) ... 12 more | ||||
| Tags | configuration, dialect: sql-server, trigger | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-10-23 19:23 | emiller | New Issue | |
| 2025-10-23 19:23 | emiller | Status | new => assigned |
| 2025-10-23 19:23 | emiller | Assigned To | => emiller |
| 2025-10-23 19:23 | emiller | Tag Attached: configuration | |
| 2025-10-23 19:23 | emiller | Tag Attached: dialect: sql-server | |
| 2025-10-23 19:23 | emiller | Tag Attached: trigger | |
| 2025-10-23 19:24 | emiller | Priority | normal => high |