View Issue Details

IDProjectCategoryView StatusLast Update
0004461SymmetricDSBugpublic2020-12-22 19:08
Reporterelong Assigned Toelong  
Status closedResolutionfixed 
Product Version3.11.8 
Target Version3.11.11Fixed in Version3.11.11 
Summary0004461: Oracle failed to create trigger, identifier is too long
DescriptionOn Oracle 12.2 and newer in compatibility mode, it will fail to startup and create triggers because the object names used are too long.

2020-06-30 12:25:00,273 ERROR [server] [TriggerRouterService] [server-sync-triggers-1] Failed to create triggers for sym_transform_table StackTraceKey.init [SqlException:1115083280] org.jumpmind.db.sql.SqlException: ORA-00972: identifier is too long

While Oracle 12.2 can use longer identifier names, up to 128 bytes in length versus the older 30 bytes, it can be in a compatibility mode that makes it behave like an older version of Oracle. Query for the version it is behaving as:

select value from v$parameter where name = 'compatible'
Tagsdialect: oracle


related to 0004339 closedpmarzullo Oracle: Version 12.2 supports 128 character names for tables, columns, constraints, and foreign key names 
related to 0004462 closedelong Oracle failed to create trigger, identifier is too long 
related to 0004714 closedelong Oracle fails to check compatible v$parameter 


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.11 293879d3

2020-07-01 09:12:02


Details Diff
0004461: Oracle failed to create trigger, identifier is too long Affected Issues
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/ Diff File

Issue History

Date Modified Username Field Change
2020-07-01 13:08 elong New Issue
2020-07-01 13:08 elong Status new => assigned
2020-07-01 13:08 elong Assigned To => elong
2020-07-01 13:08 elong Tag Attached: dialect: oracle
2020-07-01 13:12 elong Status assigned => resolved
2020-07-01 13:12 elong Resolution open => fixed
2020-07-01 13:12 elong Fixed in Version => 3.11.11
2020-07-01 13:12 elong Issue cloned: 0004462
2020-07-01 13:12 elong Relationship added related to 0004462
2020-07-01 13:13 elong Relationship added related to 0004339
2020-07-01 14:00 admin Changeset attached => SymmetricDS 3.11 293879d3
2020-09-01 12:19 elong Status resolved => closed
2020-12-22 19:08 elong Relationship added related to 0004714