View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004461 | SymmetricDS | Bug | public | 2020-07-01 13:08 | 2020-12-22 19:08 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.8 | ||||
| Target Version | 3.11.11 | Fixed in Version | 3.11.11 | ||
| Summary | 0004461: Oracle failed to create trigger, identifier is too long | ||||
| Description | On 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' | ||||
| Tags | dialect: oracle | ||||
| related to | 0004339 | closed | pmarzullo | Oracle: Version 12.2 supports 128 character names for tables, columns, constraints, and foreign key names |
| related to | 0004462 | closed | elong | Oracle failed to create trigger, identifier is too long |
| related to | 0004714 | closed | elong | Oracle fails to check compatible v$parameter |
| 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 |