Running a database check in Rational Synergy results in "bad value for has_parent (xxxxxx)" error
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.
More support for:
Software version: 7.0, 7.1a, 7.1, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168, 22.214.171.124, 126.96.36.199
Operating system(s): Linux, Solaris, Windows
Reference #: 1634746
Modified date: 22 April 2013