SAP - MDM - Unable to unarchive

[giri_dharan]

Hi Experts,

When i am trying to unarchive a repository, the MDM throws an error saying "Table Not found".

The same repository i was able to archive, but unable unarchive, the same issue occurs on all archives, i could see all archive files were available.

Please letme know what could be the issue.

Regards,

Giridharan

[giri_dharan · Accepted solution]

Hi Ankeet,

After a long analysis with SAP its found that the issues is with the user privileges.

Actually the schema tables were created with a user id and during server migration the schema got transferred to DBA user id, hence the current ownership of the schema lied on DBA user id.

Hence the original user id is no more valid to create or unarchive repositories. From DBA user id we were able to unarchive and create repositories.

We have not yet taken decision wether to continue with DBA user id or to migrate the schema from DBA to the regular id.

Thanks for all the inputs.

Regards,

Giridharan

[Former Member]

Hi,

As soon as we archive a repository in MDM a new instance is created in underlying database.

The above error suggests, MDM is unable to find the required instance.

You could restart the MDM Server and try archiving and unarchiving the same.

Regards,

[giri_dharan]

Hi Ankit,

I did MDM restart as well, but it did not help.

Still i face the Table not found error.

Regards,

Giridharan

[Former Member]

Hi,

If u are still facing the problem, it could be because of 2 reasons.

1. Back-end connectivity with DBMS layer

2. Error while archiving the repository.

Check out the following threads, if necessary u need to delete the repository from the database layer and re-create from the old archive.

http://scn.sap.com/docs/DOC-41633

https://scn.sap.com/thread/1364703

Regards,

[Former Member]

Hi,

Is ur issue resolved?

Regards,

[giri_dharan]

Hi Ankit,

Issue is not solved, i had posted message to SAP, will let know if it gets resolved.

Regards,

Giridharan

[Former Member]

Sure, do post the solution, it will help others.