MDM 7.1.4 SP4 don't Export Repository Schema

[former_member581526]

Hi,

I am using SRM-MDM Catalog3.0 , MDM 7.1 SP04 , in console , to operate Export Repository Schema failed.

MDS log:

Could not transport expression because it contained a non-transportable element: 'Item Status [Approved]'

Assignment Code='Set_Status_Code13' of Table Code='MDMSRM_CATALOG_ITEMS' requires additional steps before transport.

how to solve?

thanks in advance

Jesse

[former_member206388 · Accepted solution]

Hi Jesse

Login to the MDM Data Manager for the selected repository.

Navigate to the Assignments tab, you will find an entry there.

Delete it.

Save and now try to export the repository schema. It will work.

Regards

Bala

[Former Member · Accepted solution]

I got this error when trying to export the repository schema. There was a single assignment that was setting the status on the catalog items table which I deleted using data manager. I attempeted the export again and it worked fine.

[former_member205403]

Hi,

I faced exactly same problem like you and was getting error because of this Item status assignment field.

I deleted and recreated this assignment and Everything started working again....

Try it and revert with the result in your case.

Best Regards,

Shiv

[former_member581526]

the problem is solved.

thank you ,yours suggestion are all very useful.

Jesse

[Former Member]

Hi Jesse,

Please refer SAP Note: 1385073:

In the Note>Navigate to General>Note the following

1. A code field was added for Validations and Assignments. All repositories must undergo verify/repair before loading for

the first time in MDM 7.1 SP04 so that the added codes for Validations and Assignments are implemented.

2. Validations and assignments from previous versions that contain lookup values will need modifying before the repository schema can be transported as the lookup values in expressions will now internally include the lookup table ID in addition to the value itself. This change was made to ensure that expressions with lookup values are transported correctly.

In order to modify these expressions you will need to load the repository and delete all the referenced lookup values from

each expression and then add them back into the expressions. If you try to transport the repository schema before modifying

the expressions, you will receive a transport error and a message will be generated in the MDS.log stating the assignments or validations that need to be updated.

Regards,

Mandeep Saini

[Former Member]

Hello Jesse

I mean you are use repository from MDM 5.5

We had the same problem when migrate from 5.5 to 7.1.

Under WinOracle all working fine but at the new platform IBMDB2 we got the same error during schema export.

You should doing next steps:

1) Delete(or delete old and recreate) all validations

2) Delete(or delete old and recreate) all assignments

3) Delete(or delete old and recreate) all active and completed workflows in Data manager "workflow" Tab

4) Delete all old workflows(or delete old and recreate) in workflow table

after all that operations you should start repair process for repository

Import to schema wil be work

Very important notice: new schema had a very big size(in our case more then 200 Mb)

Regards

Kanstantsin Chernichenka