Kbase P13177: CRC for database trigger procedure does not match schema. (3242)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/18/2010 |
|
Status: Verified
SYMPTOM(s):
CRC checking for database triggers is enabled
Database trigger was modified and recompiled outside of the Data Dictionary
When running the application error 3242 is generated
CRC for database trigger procedure <procedure> does not match schema. (3242)
CAUSE:
Changing a triggers content without reregistering in the database will cause error 3242.
FIX:
Reregister the trigger by going into Data Dictionary table properties
for the specific table (Single user mode).
-- Triggers > under Event, choose the trigger type (example, DELETE)
-- Under Procedure, use the files button to choose your trigger
source .p file.
Before compiling the trigger make sure the trigger contents appear the
same within the database and the Procedure Editor.