Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
george — — source: Informix-list mailing list archive (1991-1998)
Hi All,
We seem to have come across a system catalog error. This occurred when we
created a trigger on a table and it gave some errors. Since then we get the
error -397: System catalog (systrigbody) corrupted whenever we try to query
the table on which the trigger was created. We are not able to drop the
trigger either (same error).
When we query systrigbody, there are no rows to be found.
I ran an oncheck as follows,
oncheck -ci xts_tst:t_xts_case
Validating indexes for xts_tst:informix.t_xts_case...
oncheck failure: gettab()Unknown error message 0.
I also tried running an oncheck on the catalogs, but it doesn't seem to
check systriggers and systrigbody.
The error description for -397 asks me to contact the Technical Support
Department.
Does anybody have any other ideas?
Thanks,
George Mathew
Senior Software Engineer
I.T.Solutions
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.