Project Integrity Check

[Bruno.Cossi]

Hi,

can somebody help me understand how do the errors found using the "Project Integrity Check" (Tools > Data Management > Data Integrity) get into the model?
And what do errors like "Invalid Attribute" mean? What renders an attribute invalid? How would it be allowed to be entered on the first place?
Maybe I am misunderstanding something, but it seems to me that this functionality should not be required - yet I occasionally find errors using it, and I have no idea where do they come from.

Thanks!

Bruno

[Tjerk]

Hi Bruno,

I am in the same position. It seems like some actions in EA are not totally fool proof and could mess up some items in the repository. It's a scary thought  :-/, I don't know what actions result to these errors. Or maybe it is Access related and could be solved by using other databases (lets hope so). Hope Sparx can help us here.

From my experience, the shown errors could all be resolved as propossed. I have not encountered strange things, but my project is big (> 13 MB Access database) and doing an integrity check by hand is not doable.

Greetings,
Tjerk

[Bruno.Cossi]

Hi Tjerk,

it does not seem to be Access related - I have encountered the same problem with the SQL Server-based repository.
I suspect some of the problems could be due to the way EA handles locking, e.g. you could have an object locked, I as an Administrator can remove your lock, but if you still had the Properties window open, you could still chance the object and save the changes... which could potentially lead to inconsistent changes being made to the object by two users at the same time.
I have no doubt that all of the errors found could be automatically fixed by EA, however some of the erros I have found recently (Invalid Attribute, Solution: Propose, remove attribute) scared me enough not to do that. I do not want to have dozens of the attributes deleted!

My project is about the same size of yours, but SQL Server based. I encounter the same problems when I transfer it to Access, MySQL or Oracle.

Greetings,
Bruno

[Tjerk]

Hi Bruno,

I guess we need to provide more context information to Sparx before they could really pinpoint the problem. But I do not have the time to do any extensive search, neither have I enough information while encountering the problem. Bruno, I propose the following:

Sparx: could the Integrity Check be improved to include detailed screens on the invalid items? And could there be a possibility to create a small report that can be stored on disk for later analysis and maybe posting to you guys?

Greetings,
Tjerk

[thomaskilian]

Hi all,
probably this function should be hidden and executed every now and then automatically (e.g. fsck called for disks to clean up from time to time). I'm quite shure that this check is simply to circumvent parts of 'bad programming'. I regularly run this check and let EA clean up - even with small databases this seems to be neccessary.

Thomas

[Bruno.Cossi]

Good one, Tjerk! Thank you.

Bruno

Hi Bruno,

I guess we need to provide more context information to Sparx before they could really pinpoint the problem. But I do not have the time to do any extensive search, neither have I enough information while encountering the problem. Bruno, I propose the following:

Sparx: could the Integrity Check be improved to include detailed screens on the invalid items? And could there be a possibility to create a small report that can be stored on disk for later analysis and maybe posting to you guys?

Greetings,
Tjerk