Attempts to run the ccmdb_check in IBM Rational Synergy results in the error "bad value for has_parent (xxxxxx)".
When you run ccmdb_check for a database you will see an error similar to the following:
bad value for has_parent (123456) in record:
has_asm = 1/project/ABC/XYZ (cvid = 654321)
has_bound_bs = Non-existent (bsid = 234567)
has_child = 1/dir/abc Module/4 (cvid = 534411)
has_parent = Non-existent (cvid = 123456)
This can happen if you were deleting some objects and the delete failed and did not complete.
Resolving the problem
Run the following SQL commands to resolve the issue:
%dbaccess <database "leaf" name> << eoc
%delete from bind where has_parent=123456;
Review technote 1424014: How to run Informix SQL commands for your Rational Synergy database on a UNIX or Linux environment to set the dbaccess command.