Aras PLM Community
Enterprise Open Source PLM Software and Ideas

Export / Import using upgrade tool

rated by 0 users
This post has 6 Replies | 2 Followers

Top 25 Contributor
Posts 34
Points 485
mendenaresh1357 Posted: Thu, Jul 2 2009 1:54 AM

hi every one,

   iam using aras 8.1 framework. craeted few itemtypes,forms relations etc and added them to package com.aras.innovator.cretaor(i defined this package ).  i have few questions

1) should i export only the package i defined or entire packages present in innovator?

2)  when i try to export the whole packages i get the following error and ask me abort export.

        faultstring: Utilities: ApplyAML: GetItemEx: No items of type 'ItemType' found (2) using the criteria:

3) if  i continue to export even after the error, i get the following error during importing(import server is also aras 8.1 but on a different machine)

 faultstring: utilities: ApplyAML : Internal error: the relationship type is corrupted. Itemtype inside Relationship_id tag is corrupted

faultdetail: Failed to add the Relationshipshiptype

faultcode: 8

faultAMLError:

can anybody tell me what is the exact procedure to follow with upgrade tool.

is there any method to export data between different servers other than upgrade tool.

                                               Thanks in advance.

Regards,

Naresh Mende

  • | Post Points: 20
Top 10 Contributor
Posts 151
Points 725
SamsAn replied on Thu, Jul 2 2009 3:05 AM

1) - No. You can export a specific package only. Or even a part of the package (you can select an item type and export only it).

2) - This error can appear because of several reasons:

     a) You created an item type, added it to a package, deleted the item type. But the reference to the item type still exists in the package and it can cause the error.

     b) You are using 8.1 aras framework, but which version of solution upgrade tool is used? If the current version then it is not accurate to use since the innovator metadata in 8.1 and 9.1 have several differences.

3) - It may be caused by a reason from 2) and typical mistake during adding metadata item to a package (i believe aras should implement the prevention of this mistake): if you create a RelationshipType RelA then two metadata instances are created (RelationshipType RelA and ItemType RelA with is_relationship=1 flag). So, very often users add ItemType RelA to a package. It is incorrect. RelationshipType RelA should be added.

In general, if you add a metadata instance (ItemType for example) and all related metadata to this item type (Methods used in Server/Client Events tab, Forms used in View tab, Permissions from Permissions tab, related Workflow/Lifecycle Maps, etc.) then no errors should appear during export/import of a package.

SamsAn.
Original Mind Any Level Innovator Solutions Free-Lancer, http://sites.google.com/site/caraacc

  • | Post Points: 35
Top 25 Contributor
Posts 34
Points 485

thanks SamsAn for your information.

Can i find a upgrade tool for 8.1?  if so where can i find?

  • | Post Points: 5
Top 25 Contributor
Posts 34
Points 485

also can i export data from 8.1 to 9.1 by using upgrade tool? the upgrade tool am using is 9.0

  • | Post Points: 20
Top 10 Contributor
Posts 151
Points 725
SamsAn replied on Thu, Jul 2 2009 5:35 AM

Probably, you should contact aras to get corresponding version of the tool.

About solutions exporting/importing see http://www.aras.com/Community/forums/t/522.aspx. I repeat my statement again: You should upgrade 9.0X (from 8.1 in your case) database to 9.1 version using Innovator 9.1, then export your solution from the upgraded db. You will get correctly exported 9.1 package.

SamsAn.
Original Mind Any Level Innovator Solutions Free-Lancer, http://sites.google.com/site/caraacc

  • | Post Points: 20
Top 25 Contributor
Posts 34
Points 485

thanks SamsAn.

that really worked a lot.

i followed the steps you mentioned. there are no errors this time during export. but  while importing i get the following error:

faultstring: the UPDATE statement conflicted with the FOREIGN KEY constraint "FK_CAN_ADD_RELATED_1F4E99FE". The conflict occured in database "X" table "Y", column 'ID'.

the statement has been terminated.

 I couldnt make out this. can you please tell what it means and how t o solve this.

 

  • | Post Points: 20
Top 10 Contributor
Posts 151
Points 725
SamsAn replied on Fri, Jul 3 2009 1:17 PM

The error states that the value in related_id property of Can Add relationship does not exist among values in [Identity].id column. I guess you added a special identity to Can Add tab of an item type of your package. But did not add the identity to the package. Thus the identity is not exported and will not be imported into the target db.


SamsAn.
Original Mind Any Level Innovator Solutions Free-Lancer, http://sites.google.com/site/caraacc

  • | Post Points: 5
Page 1 of 1 (7 items) | RSS