Running "Verify and Repair" results in "Invalid Entity .. in Relation," in Rational System Architect

Technote (troubleshooting)


Problem(Abstract)

Attempts to run "Verify and Repair" results in "Invalid Entity .. in Relation .., Will delete relationship” in IBM Rational System Architect (SA).

Symptom

In the "Verify and Repair" log you see the message:



    Error: Invalid Entity Id2 16940 (Id1 2912) in Relation 34, comprises
          Will delete relationship - Id1 2912 Id2 16940 Rel 34, comprises

Further in the log you will see another entry stating the relationship has been deleted, as follows:

    Deleted relationship - Id1 2912 Id2 16940 Rel 34, comprises


These "Invalid Entity .. in Relation" are known as "Invalid Relationships".

The log indicates that the invalid relationships were found and deleted, but with with subsequent "Verify and Repair" attempts the same relationships are stated to be found and deleted. This behaviour indicates that "invalid relationships" have not been deleted.


Cause

This issue is identified a product regression defect internally found and reported on SA version 11.4.2.1.


Environment

This problem has only be seen with "Workspaces Schema" encyclopedia.

Diagnosing the problem

Check the "Verify and Repair" log that is displayed in SA.

Resolving the problem

This issue with "Workspaces Schema" was fixed with the release of

4034108: IBM Rational System Architect Fix Pack 2 (11.4.2.2) for 11.4.2

You should install this fix to resolve the issue.

If you encounter this issue with a Standard (not workspace enabled) encyclopedia, you can find and delete the "invalid relationships" by running a "Query" on the database using for example Encyclopedia Manager for SA as follows:

Disclaimer

All source code and/or binaries attached to this document are referred to here as "the Program". IBM is not providing program services of any kind for the Program. IBM is providing the Program on an "AS IS" basis without warranty of any kind. IBM WILL NOT BE LIABLE FOR ANY ACTUAL, DIRECT, SPECIAL, INCIDENTAL, OR INDIRECT DAMAGES OR FOR ANY ECONOMIC CONSEQUENTIAL DAMAGES (INCLUDING LOST PROFITS OR SAVINGS), EVEN IF IBM, OR ITS RESELLER, HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.

  1. Chose the menu "Query > New" or the keyboard shortcut "CTRL+N".

  2. Enter your query.
    • You can identify the the "invalid relationships" for example with this query:

      SELECT * FROM Relationship WHERE (Relation > 355) OR (ID1 NOT IN (SELECT ID FROM Entity)) OR (ID2 NOT IN (SELECT ID FROM Entity))

    • You can delete the "invalid relationships" for example with this query:

      DELETE FROM Relationship WHERE (Relation > 355) OR (ID1 NOT IN (SELECT ID FROM Entity)) OR (ID2 NOT IN (SELECT ID FROM Entity))


  3. Choose the menu "Query > Execute" or the keyboard shortcut F5.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational System Architect
General Information

Software version:

11.4.2.1

Operating system(s):

Windows

Reference #:

1646733

Modified date:

2013-10-04

Translate my page

Machine Translation

Content navigation