0006281: Trigger creation fails when Progress OpenEdge table has hundreds of columns - SymmetricDS

ID	Project	Category	View Status	Date Submitted	Last Update

0006281	SymmetricDS	Bug	public	2024-03-11 11:54	2025-05-21 17:52

Reporter	emiller	Assigned To
Priority	normal
Status	closed	Resolution	won't fix
Product Version	3.15.0

Summary	0006281: 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

Date Modified	Username	Field	Change
2024-03-11 11:54	emiller	New Issue
2024-03-11 11:54	emiller	Tag Attached: trigger
2024-03-11 11:54	emiller	Issue generated from: 0006280
2024-03-11 11:54	emiller	Relationship added	related to 0006280
2024-06-24 15:24	elong	Note Added: 0002469
2025-05-21 17:52	cquamme	Status	new => closed
2025-05-21 17:52	cquamme	Resolution	open => won't fix
2025-05-21 17:52	cquamme	Note Added: 0002982

elong 2024-06-24 15:24 developer ~0002469	Instead of running SQL to format the values, it could format the values in Java.

cquamme 2025-05-21 17:52 developer ~0002982	As a work around you can turn off the old data.