Progress trigger: Error Code: -219901, SQL State: HY000

[lochdsmile]

Hi all,

We are now having trouble with Progress trigger on some Progress databases like below:

15:30:13 [UPDATE - 0 row(s), 0.016 secs] [Error Code: -219901, SQLState: HY000] [DataDirect][OpenEdge
JDBC Driver][OpenEdge] Internal error -2 (a column with the specified column id does not exist in the row) in SQL
from subsystem RECORD SERVICES function rec_to_data called from stub_tpl_hdl_t::extract_fields on
PUB.mncompany for address. Save log for Progress technical su
... 1 statement(s) executed, 0 row(s) affected, execution time 0.016 sec

It does not always occur. Some progress databases work, some do not. And we have not yet found the root caused. Can anyone have any idea please help me.

Please see my scenario as following:

Step 1. Create a very simple trigger code. This trigger code will be fired where there is an update on a column of a table
CREATE TRIGGER TEST_TRIGGER AFTER UPDATE OF NAME ON MNCOMPANY
REFERENCING OLDROW, NEWROW
FOR EACH ROW
BEGIN
END

Step 2. Use whatever tool to connect to the database using JDBC and try to update the column.

=> the error posted above

Plaese help me out of this

Thanks a lot in advance

 

[PeterPeeters]

Hi,

Did u allready have a solution for this problem ? is suppose yes (year : 2006 ).
We now have the same problem...
can u give me some suggestions please ?

thx in advance,
Peter Peeters
Escapo cv
Mechelen
Belgium