View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006280 | SymmetricDS | Bug | public | 2024-03-11 11:53 | 2025-06-11 17:41 |
| Reporter | emiller | Assigned To | |||
| Priority | low | ||||
| Status | acknowledged | Resolution | open | ||
| Product Version | 3.14.6 | ||||
| Summary | 0006280: Trigger creation fails when Progress OpenEdge table has hundreds of columns | ||||
| Description | When a Progress OpenEdge table has a very high number of columns, trigger creation fails with a message like this one: java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Error from Java compiler. Compiler messages follow.(10727) C:\OpenEdge\WRK\SQL_11992_1192\EVANC_SYM_ON_I_FOR_TST_345_CLMNS_CLNT_TP.java:85: error: unclosed string literal "case when ? is null threturn 0; ^ C:\OpenEdge\WRK\SQL_1 It appears that there is a length limit for the Java code contained within a Progress OpenEdge trigger. It may be possible to work around this issue by enabling Stream Row for the trigger. | ||||
| Steps To Reproduce | I was able to reproduce it by configuring a trigger for a Progress OpenEdge table with 345 columns. | ||||
| Tags | trigger | ||||
| related to | 0006281 | closed | Trigger creation fails when Progress OpenEdge table has hundreds of columns |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-03-11 11:53 | emiller | New Issue | |
| 2024-03-11 11:53 | emiller | Tag Attached: trigger | |
| 2024-03-11 11:54 | emiller | Target Version | 3.14.13 => |
| 2024-03-11 11:54 | emiller | Issue cloned: 0006281 | |
| 2024-03-11 11:54 | emiller | Relationship added | related to 0006281 |
| 2025-06-11 17:41 | mdrouard | Priority | normal => low |
| 2025-06-11 17:41 | mdrouard | Status | new => acknowledged |
| 2025-06-11 17:41 | mdrouard | Note Added: 0003082 |