Kbase P8244: Data Dictionary triggers report shows "nr" in the flags part
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/02/2003 |
|
Status: Unverified
SYMPTOM(s):
In Data Dictionary, doing a database > reports > triggers shows "nr" flags value.
CAUSE:
The _trigdat.p procedure that calculates the flag values output in the schema trigger report includes the following code:
.
.
.
proc = SEARCH(_File-trig._Proc-Name)
rcode-info:filename = proc
crc_val = rcode-info:crc-value
crc = (if _File-trig._Trig-CRC = ? then "no" else "yes")
flags = (if _File-trig._Override then "*" else "") +
(if crc = "yes" AND crc_val = ? then "nr" else ") +
(if crc = "yes" AND crc_val <> ? AND
crc_val <> _File-trig._Trig-CRC
then "m" else "").
.
.
.
The code clearly indicates that the ·nr· value is returned when the CRC check is ON and the RCODE-INFO:INFO-CRC is unknown. The RCODE-INFO:INFO-CRC evaluates to unknown only when the .r version of the schema trigger is not found in the location returned by SEARCH(_File-trig._Proc-Name).
FIX:
Place the compiled .r version of the schema trigger in the directory returned by SEARCH(_File-trig._Proc-Name) or disable CRC checking for the trigger.