Author Topic: Error on XMI import  (Read 4010 times)

Dave_Bullet

  • EA User
  • **
  • Posts: 295
  • Karma: +0/-0
    • View Profile
Error on XMI import
« on: May 03, 2006, 05:02:03 pm »
I'm getting a

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

error when importing an XMI package.  I'm jus trying to transfer a package from one EA model to another.

The steps I'm taking are:
1. Put the EA_UML.DTD in the XML output folder
2. Right click the package in the source model and do an XMI export.  I've tried exporting using the defaults, plus checking "Use DTD"
3. Open the target model
4. Create and empty package
5. Right click the empty package and click import.  I've tried both the default options as well as "Strip GUID's"

Can you help me please?  I must be doing something really basically wrong.

Thanks,
David.
"I know I'm close to a good design, but it's like the balloon animals, squeeze in one spot and the problem moves down the line"

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: Error on XMI import
« Reply #1 on: May 03, 2006, 05:38:40 pm »
Interesting Dave,

I very recently reported a bug with the same error message. I got to the problem via a different route though.

Where did you get the XMI from?

David
No, you can't have it!

Dave_Bullet

  • EA User
  • **
  • Posts: 295
  • Karma: +0/-0
    • View Profile
Re: Error on XMI import
« Reply #2 on: May 03, 2006, 05:42:04 pm »
Hi there,

I forgot to mention it is the latest build of EA (6.1 - build 790) - licensed corp edition (if that makes any difference).

The XMI was EA's own export.  ie. I did an export of a package in EA - opened up the target model and tried to import the XMI I just generated.

Cheers,
David.
"I know I'm close to a good design, but it's like the balloon animals, squeeze in one spot and the problem moves down the line"

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8085
  • Karma: +118/-20
    • View Profile
Re: Error on XMI import
« Reply #3 on: May 03, 2006, 08:00:35 pm »
I'd recommend sending in a bug report to [email protected] with a sample XMI file or eap file with instructions about how to export it.

Dave_Bullet

  • EA User
  • **
  • Posts: 295
  • Karma: +0/-0
    • View Profile
Re: Error on XMI import
« Reply #4 on: May 08, 2006, 01:20:21 pm »
Seems like I have a case of user error  :)

This came back from Sparx Support (don't have a free floating license to try it yet....)
=-=-=-=-=
Thanks for the note and the zip file.

I believe that when you export to XMI , you get a dialog like in "Dialog.png" - the option "Unisys/Rose Format" will be checked in the "For Export to Other Tools" groupbox ( as boxed in red in "Dialog.png").
This option is used so as to structure the XMI 1.1 output of EA to be compatible with that of Rational Rose. Hence this option is used only to import EA's XMI into Rational Rose.

This option seems to be set by default. Change this default behaviour by :
1. Use the menu option : Tools -> Options
   This brings up the "Local Options" dialog box.
2. Select "XML Specifications" in the tree.
3. On the right-hand side, you will see a group-box called "Default XMI Output" whose value would be "Rose" - change it to "EA"
4. Close the dialog.

Now export to XMI - you will see that the option "Unisys/Rose Format" will be unchecked.
Import this XMI file and EA will import it successfully.

Hope this resolves your issue. If you have any further queries, feel free to write-in.
"I know I'm close to a good design, but it's like the balloon animals, squeeze in one spot and the problem moves down the line"

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: Error on XMI import
« Reply #5 on: May 09, 2006, 03:36:40 am »
But...

Why was the option set by default. Seems to me that this "user error" would be inevitable in that case.

Since the 'default' purpose of XMI 1.x (in general, not just EA) is to allow export and import within a tool - only with XMI 2.x do we have a specification for reliable transfer between tools - it strikes me that this option should be cleared by default.

Dave, I think you ran afoul of a small UI bug, and can comfortably declare yourself innocent.

David
No, you can't have it!

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8085
  • Karma: +118/-20
    • View Profile
Re: Error on XMI import
« Reply #6 on: May 10, 2006, 10:23:47 pm »
Actually, despite what our support person said, the option to generate in rose format is not set by default.  It wouldn't be set unless someone had set it.

However, I don't think that EA is completely without blame.  With that option set EA generates the rose flags, while still having 'Enable full EA Roundtrip' enabled.

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: Error on XMI import
« Reply #7 on: May 11, 2006, 03:39:36 am »
I think "blame" may be too strong a word here. Overall this feature works well, and continues to improve. For example, the import of XMI in Unisys formats has become better in recent builds.

This is more along the lines of a quirk that needs to be ironed out. Now that we've found it I have no doubt it will.
No, you can't have it!