Kbase P132226: Error 7853 when issuing SQL UPDATE query on table with UPDATE trigger
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/11/2008 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
SYMPTOM(s):
Error 7853 when issuing SQL UPDATE query on table with UPDATE trigger
Database contains SQL UPDATE trigger
UPDATE query issued from SQL Explorer fails with the following error:
SQLState=HY000
ErrorCode=-20142
[JDBC Progress Driver]:Error in Stored Procedure Execution. (7853)
Database was copied from another server
A newer version of Java was installed on the server from which the database was copied
CAUSE:
The triggers had been compiled with a newer version of Java than the one in which they were running
FIX:
Recompile triggers and stored procedures with the Java version on the target server