IBM Support What's New?

Running a database check in Rational Synergy results in "bad value for has_parent (xxxxxx)" error

Technote (troubleshooting)


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.

Document information

More support for: Rational Synergy
General Information

Software version: 7.0, 7.1a, 7.1,,,,,,,

Operating system(s): Linux, Solaris, Windows

Reference #: 1634746

Modified date: 2013-04-22