Error "Updating Respository" from MDM 5.5 to MDM 7.1

[Former Member]

Hi all,

We have been using MDM 5.5 SP 6 for the last 2 years; right now we have a Sandbox environment (MDM 7.1 - 7.1.02.59) to check compatibility with our developments.

We unarchive the repositories in Sandbox and "Update Repository" for each one, 4 of our 7 repositories works without problem in this option, but 3 of them display the message "Error Updating Database Schema", we cant find any logs where describes the step that is trying to do.

Does anybody know which can be the problem?

To explain more of the background installations:

- MDM 5.5 is working with SQL 2005

- MDM 7.1 is working with SQL 2005

- The username that we use to Update all repositories is the same, so it's not a problem of authorization

Thanks for your help.

[Former Member]

Hi Abhishek / Neethu

Do you have an idea of wich could be the problem?

Regards

Daniel Becerra

[Former Member]

Hello,

The log you have mentioned is the complete log or only a part of it.

This seems to be problem from MDM side.

I'm sure you have followed all the steps, still for my reference would appreciate if you could verify them

take a fresh archive of the repository from 5.5,

transfer it in the Archive folder in the MDM Distribution folder

un-archive in the Console.

Update the repository (This where the error is ??)

Load the repository using updated indices

It will be helpful if you raise it with SAP an OSS message.

Regards,

Abhishek

[michael_theis]

Hi Daniel,

is there any reason why you intent to use a relatively old MDM 7.1 version? If you'd go for a newer release (SP!) it is likely that this issue might not occur. If you really want to upgrade from 5.5 to 7.1 I'd strongly recommend to go for the current release.

Best regards

Michael

[Former Member]

Hello,

You may refer the following PDF

[Best Practice|http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/80765a21-78f3-2b10-74a2-dc2ab57a1bd2?QuickLink=index&overridelayout=true]

Regards,

Abhishek

[Former Member]

Hi,

Here I annex the log (MDS_Log), it's not very descriptive

- Begin updating 'MDM_210_PRODUCTOS' repository schema series 12 to version 1

- Returning from a function on encountering error: 0xFFAB412D

- Failed updating 'MDM_210_PRODUCTOS' repository schema series 12 to version 1. (00 seconds)

- Throwing an RCException on encountering error: 0xFFAB412D

Regards

Daniel

[Former Member]

Hi Abhishek,

The repositories begin from a Standard structure with some changes (fields, ports, etc).

We restarted the MDS, MDIS, MDSS, DB Server, even we tried in another DB Server but it's still not working.

I'll wait to close the Post for if someone else think another way to solve it, thanks for your support

Regards

Daniel Becerra

[Former Member]

Hi Daniel,

Can you provide the MDM_Log message while performing this action.

Regards,

Neethu Joy

[Former Member]

Hello,

It will be helpful if you can provide the log file from the MDM Console Logs.

Regards,

Abhishek

[Former Member]

Hi Abhishek,

Thanks for your Post but we already did that and have the same result. In the 5.5 environment each repository display "0 Faltal errors, 0 non-fatal, 0 warnings"

Regards

Daniel

[Former Member]

Hello,

Are these custom repositories or the standard ones.

Even we had faced the same issue, there was some problem with the database.

We restarted the dB and everything worked.

If this also doesn't solve, then take a completed restart of the system, MDS, db Server.

Finally if nothing works, raise it with SAP.

Regards,

Abhishek

[Former Member]

Hello,

In your 5.5 environment, do a check and repair repository, then do update indices.

Then move them to 7.1 environment.

Regards,

Abhishek