lochdsmile
New Member
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
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