MX_PERSON Entry type deleted - SAP IDM 8.0

[Former Member]

Hi Experts,

MX_PERSON entry type is deleted accidentally from our Identity store schema of IDM 8.0, created manually MX_PERSON again.

Our Initial load job is giving errors and not able to open Passes from Processes and getting error that "Retrieving Pass  failed".

Not able to see the employees details from UI admin.

How can we recover retrieve deleted MX_PERSON or passes?

Thanks

Purna

[Former Member · Accepted solution]

The issue has been resolved with the below statement.

update mxi_entry set mcEntryTypeId=<new_mx_person_entry_type_id> where

mcEntryType='MX_PERSON' and mcIdStore=<id_store_id> and

mcEntryTypeId=<old_mx_person_entry_type_id>

Thanks

Purna

[jaisuryan]

Hi,

Did you try restoring the database?

Kind regards,

Jai

[Former Member]

Jai,

We do not have database backup to restore.

Thanks

Purna

[former_member2987]

Then you can try one of two things.

Run mxmc-update, probably won't work, but anything can happen I guess

Rum mxm-remove, and then mxmc-install to remove and reinitialize the database.

Matt

[former_member201064]

I would backup anything else in the database before doing this. Tasks, jobs and any other data. Just to be sure.

Best regards

Dominik