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

Technote (troubleshooting)


Problem(Abstract)

Attempts to run the ccmdb_check in IBM Rational Synergy results in the error "bad value for has_parent (xxxxxx)".

Symptom

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)

Cause

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;
eoc

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.


Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Synergy
General Information

Software version:

7.0, 7.1a, 7.1, 7.1.0.1, 7.1.0.2, 7.1.0.3, 7.1.0.4, 7.1.0.5, 7.1.0.6, 7.1.0.7

Operating system(s):

Linux, Solaris, Windows

Reference #:

1634746

Modified date:

2013-04-22

Translate my page

Machine Translation

Content navigation