View Issue Details

IDProjectCategoryView StatusLast Update
0005822SymmetricDSBugpublic2023-05-05 19:53
Reporterpmarzullo Assigned Topmarzullo  
Status closedResolutionfixed 
Product Version3.14.6 
Target Version3.14.7Fixed in Version3.14.7 
Summary0005822: SQL Server create or alter trigger fails when table is not in default schema (dbo)
DescriptionWhen 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 Reproduce1. Define a table in a non-default schema
2. Make sure parameter trigger.allow.create.or.replace is set to true
3. Rebuild trigger


There are no notes attached to this issue.

Related Changesets

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
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/ Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/ Diff File

Issue History

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