EA-6.0 and endless DAO.Fields/DAO.Database popups

[simon.marshall]

Hi, we upgraded to 6.0 from 5.0.771, in the hope it would fix some of the nastier bugs we see, but unfortunately we've run into some other problems.  Downgrading hasn't helped - now we get them in 5.0 too.  We've never seen these before - has anyone else?

We have a hierarchy of CVS-controlled packages.  When checking out/in a package and reloading from XMI, we get popups of the form:

 DAO.Fields [3265]
 Item not found in this collection.

while it is processing the XMI, and then sometimes a few of:

 DAO.Database [3022]
 The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship.  [...]

at the end.  We can OK these to get rid of the popups, but naturally we're a little worried about the integrity of our model!  Creating a new .EAP and importing the CVS-controlled packages into it doesn't help, so I guess the problem is with the stuff that it is in the repository (I also tried to repair my .EAP but it made no difference).

There's no clue from the popups as to what is wrong or what we can do about it.  Anyone else getting this?  Any ideas what we can do?

Thanks, Simon.

[roman]

Hello Simon,

my situation is:

On workstation:
:local:d:\CVS
some cvs controled packages under project some root-nodes.

On notebook:
The same directory-tree-copy and options.

I haven't find any way how to check-out. Packages are locked for edit. The cvs and project paths are the same on workstation and on notebook (xmi, eap and cvs files).

When "Get Latest" i have seen both the DAO.Fields [3265], [3022].
note to moderator: having floating project view toolbox on right side the processing modal dialogs were outside desktop.

In \Project\Version Control  "Set Version Control Options" i see the "Current user". I have't found a way how to change. I have changed the login-user on notebook win-XP to the same as on workstation. Doesn't work. May be here is my lock-problem.

So i have seen the DAO errors too. I could not check out. I will see on monday in my office, if i find some solution having both work-station and notebook, if i'll see the DAO again.

Roman
p.s.
next cvs relevant topic "Relinking package to a different CVS directory"

[Maarten]

We experienced the same problems with regards to the DAO.Recordset[3022] problem. Lots of pop-ups appeared when we tried to check out packages or do a GetLatest. Initially the number of pop-ups was limited but recently the number exploded to several thousands of pop-ups. Doing a CheckOut or a GetLatest became very painful. We looked for the problem and were finally able to solve it. Although the response is quite late and our problem may be very specific I post our solution for those who are interested.

We have several EA models of which the packages are version controlled by means of Visual SourceSafe repositories. We migrated from Rational Rose to Enterprise Architect about a year ago. Most of our models were initially created in Rational Rose and were re-imported in Enterprise Architect. We found out that our problems were related to "Rational Rose legacy" that was stored in our xml packages. I created another post for a problem with an "Out of memory" exception which was also caused by Rational Rose legacy (http://www.sparxsystems.com.au/cgi-bin/yabb/YaBB.pl?board=general;action=display;num=1121254739;start=6#6)

I checked the packages that invoked the DAO.Recordset[3022] error. It appeared that these packages contained lots of lines like the following:

Code: [Select]

<UML:TaggedValue tag="rose_uuid" value="3EC87A0C029D" xmi.id="EAID_7FE08CAA_3A9F_4d94_8964_77C035D41FC4"/>
<UML:TaggedValue tag="rose_uuid" value="3EC87A0C029D" xmi.id="EAID_7494AAFB_5DCC_41f0_86A3_179835567B74"/>
<UML:TaggedValue tag="rose_uuid" value="3EC87A0C029D" xmi.id="EAID_394A165F_00E9_4936_B651_FF8143F5C5F9"/>
<UML:TaggedValue tag="rose_uuid" value="3EC87A0C029D" xmi.id="EAID_9414DFD5_C0E5_4fa6_8913_3801F0FF5A5A"/>
<UML:TaggedValue tag="rose_uuid" value="3EC87A0C029D" xmi.id="EAID_B23B1B65_0921_4c42_9911_587E9FB0AC51"/>
As you can see our packages contained a lot of duplicate lines containing the same rose_uuid. For each duplicate line in our package we got one DAO.Recordset[3022] pop-up (yes, I counted it :-)) Our most problematic package contained 85.000 lines of which over 78.000 were lines like above. (no, I did not counted this package)

We removed all these lines by means of a stylesheet and checked our packages in again. Everything works fine now as we got rid of those annoying pop-ups. I realize our problem was quite specific but maybe you could check the content of your packages and control if they also contain lines which seem useless.

[simon.marshall]

Thanks for the info.  It got fixed (at least as far as our problem was concerned) in 6.1.787.  It was caused by (possibly) certain associations between elements in different source controlled packages being (necessarily) saved to both XMIs.