Duplicated requirements - data intregrity checker

[MaxRussell]

Hi,

we have a script that makes use of the API to pull requirements out of EA and copy them into HP Quality Center. The script looks for new/updated requirements and compares them with Quality Center. Where there is an update to be made, or a change in the structure (e.g. containing project), this is carried out.

Recently the DB folks ran the Data Integrity checker tool. Now, when the script is run, we see duplication of the requirements in Quality Center. This would seem to be because at the EA side, the refreshed items are seen as new - so when added into Quality Center, they are duplicated.

Does the data integrity checker refresh GUIDs? If the script is making use of the EA Element to perform the functionality above and the ID of the element has changed, what amendments would be required to alleviate this situation?

[Geert Bellekens]

Max,

I'm not sure, but I believe indeed that the integrity checker does change guid's from time to time. (in case of duplicates for example).
What I would do in your case is try to identify the requirements by their fully qualified name and eliminate the duplicates that way.

Geert

[bch]

Hi,

we have a script that makes use of the API to pull requirements out of EA and copy them into HP Quality Center. The script looks for new/updated requirements and compares them with Quality Center. Where there is an update to be made, or a change in the structure (e.g. containing project), this is carried out.

Recently the DB folks ran the Data Integrity checker tool. Now, when the script is run, we see duplication of the requirements in Quality Center. This would seem to be because at the EA side, the refreshed items are seen as new - so when added into Quality Center, they are duplicated.

Does the data integrity checker refresh GUIDs? If the script is making use of the EA Element to perform the functionality above and the ID of the element has changed, what amendments would be required to alleviate this situation?

Would you be willing to share the script?  This is precisely what I was looking for.

[MaxRussell]

Unfortunately I can't.

[qwerty]

Would you be willing to share the script?  This is precisely what I was looking for.

How about SELECT * FROM T_OBJECT WHERE TYPE = "Requirement" and evaluate the results?

q.

[MaxRussell]

Quick question - is the an Element determined by quid? That is to say, within the EA API, when I reference via Element, is the actual identification occuring on the GUID?

[Geert Bellekens]

I don't think so. If you log all database calls when using the API I think it mainly uses the regular ID field to identify the elements.

Geert