Consultor Eletrônico

Status: Verified

SYMPTOM(s):

CRC error 3242 occurs after changing schema trigger code outside of Data Dictionary

CRC for database trigger procedure <procedure> does not match schema. (3242)

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

Problem does not happen if trigger work done in Data Dictionary.

Problem happens when trigger work done outside Data Dictionary

FACT(s) (Environment):

Progress 9.x
OpenEdge 10.x
All Supported Operating Systems

CAUSE:

The database schema trigger has the CRC check activated and has been changed without registering the new CRC with the data dictionary by visiting the new trigger code from within the data dictionary.

FIX:

Modified schema triggers must be re-registered in the data dictionary. Use the following steps to register these modifications using the data dictionary:

A) Character client:

1) Open Data Dictionary
2) Schema
3) Modify Table
4) Select the table of interest
5) Triggers
6) Select the trigger of interest
7) Edit the trigger
8) Apply changes
9) Compile and save the modified trigger.
B) GUI client:

1) Open Data Dictionary
2) Select the table of interest
3) Table Properties
4) Triggers
5) Select the trigger of interest
6) Use Files to navigate to the modified trigger
7) Save the trigger
8) Exit the data dictionary choosing to commit the changes.
9) Compile and save the modified trigger.