I've been up against a wall with a recent database problem on one of my
projects, hoping I can get some ideas.
Recently my database began having this issue, whenever I go to add a
column or make pretty much any structural change, I get an ERROR - A
foreign key references a table not known to be referenced (1242),
followed by an ERROR - The number of rows counted was not expected.
I have been able to UNLOAD my structure and recreate the database with
seemingly no errors, database checks out OK with AUTOCHK and R:Scope
afterwards, but as soon as I go to edit the structure the errors return.
Running R:Scope the errors are invalid row count errors in SYS_RULES,
SYS_CONSTRAINTS, and SYS_COMMENTS. I suspected something wrong with a
constraint or rule because I've made adjustments in those areas in the
last month and since the initial error indicates a problem with a
foreign key.
Any ideas about how I could go about narrowing down the specific
problem? Since everything was valid when setup, and again when
structure was recreated just not quite sure why/how this could be happening.
--
Dave McCann
