View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005822 | SymmetricDS | Bug | public | 2023-05-05 16:58 | 2023-05-05 19:53 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.6 | ||||
| Target Version | 3.14.7 | Fixed in Version | 3.14.7 | ||
| Summary | 0005822: SQL Server create or alter trigger fails when table is not in default schema (dbo) | ||||
| Description | When a table is not in the dbo schema, the create or alter trigger command fails because the schema of the trigger is not specified, and SQL Server seems to not be able to find the trigger. It fails with the following error message: There is already an object named 'SYM_ON_I_FOR_XCNTRPHLT1_SRVR' in the database. When the schema prefixes the name of the trigger, everything works fine. | ||||
| Steps To Reproduce | 1. Define a table in a non-default schema 2. Make sure parameter trigger.allow.create.or.replace is set to true 3. Rebuild trigger | ||||
| Tags | sync-trigger | ||||
|
SymmetricDS: 3.14 80adf4cc 2023-05-05 17:03:03 Details Diff |
0005822: SQL Server create or alter trigger fails when table is not in default schema (dbo) |
Affected Issues 0005822 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlTriggerTemplate.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractTriggerTemplate.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-05-05 16:58 | pmarzullo | New Issue | |
| 2023-05-05 16:58 | pmarzullo | Status | new => assigned |
| 2023-05-05 16:58 | pmarzullo | Assigned To | => pmarzullo |
| 2023-05-05 16:58 | pmarzullo | Tag Attached: sync-trigger | |
| 2023-05-05 17:03 | pmarzullo | Status | assigned => resolved |
| 2023-05-05 17:03 | pmarzullo | Resolution | open => fixed |
| 2023-05-05 17:03 | pmarzullo | Fixed in Version | => 3.14.7 |
| 2023-05-05 18:00 | pmarzullo | Changeset attached | => SymmetricDS 3.14 80adf4cc |
| 2023-05-05 19:53 | pmarzullo | Project | SymmetricDS Pro => SymmetricDS |
| 2023-05-12 19:49 | admin | Status | resolved => closed |