IdM IC, Schema update (1094) differ to procedure version ( 1072 )

[Former Member]

We are making a sps update on  IdM 7.2 components below from sps 5  to  7 .

1- UI IdM by deploying IDMIC applications (IDMIC07_4-20005939.SCA) .

2 - DB IdM  by mxmc-update.sql ( from ICDESIGNTIME07_3-10009681.ZIP)

3 - IdM designtime, deinstall and reinstalling ( from ICDESIGNTIME07_3-10009681.ZIP)

4 - IdM IC runtime, deinstall and reinstalling   (from ICRUNTIME07_2-20005938.ZIP)

5 - VDS, deinstall and reinstalling  ( from VDSERVER07_1-20005940.ZIP)

After did the IdM update the error message appeared as we can see on figure below.

Our IdM connection to database is OK.

Which updates we have to install more than the items above or other procedures ?

Thanks in advance ?

Rodrigo

[former_member2987 · Accepted solution]

Rodrigo,

Here's how I would handle it.

Turn off all dispatchers and event agents.

Uninstall all IDM components:

Designtime

Runtime

Download the version of SAP IDM you are interested in from the SAP Marketplace

Install the designtime

Update the database using the proper database upgrade script (I'd work with your DBAs if possible)

Install the runtime

Recreate dispatchers/event agents as needed

Start up the dispatchers

Start up the MMC console, all should be good now.

[Former Member · Accepted solution]

Hi Matt,
thanks for your attention.

We did the update procedure as you suggest but the error remain the same .

After all IdM components installed (SP 7) we try to create a new dispatcher since we delete the dispatchers and events before uninstall all IdM components and reinstall them. Then the error below appeared :

Some table is missing on database.

We guess that the erro is related with IC, Identity Center Version field, brought from database or other source .

Do you know the Identity Center Version field data source ?

We  already run the mxmc-update.sql script one more time  without erros as we could see on attachment (mxmc-update.log)

thanks for everybody

mxmc-update.txt.zip

[former_member2987 · Accepted solution]

Hi Rodrigo,

Please have your DBAs run the update using SA/administrator credentials. You might be missing a permission to create / modify one of the database objects.

Matt

[Former Member · Accepted solution]

Hi Matt,

we did the update using mxmc_update.sh with sucess.

[keith_zhang]

Hello Rodrigo,

It seems there may be issues when updating identity center database. It should use user _oper to do this(script mxmc-update)right? Please check log mxmc-update.log if there is any issues recorded.

BR, Keith

[Former Member]

Hi Keith,
the script mxmc_update.sql was running by user_oper .

We will check it in detail the logs. We saw that the identity center version was 7.20.5 on Identity Center Version field, even the when 7.20.7 ( SPS 7) was displayed during IC startup.

The Identity Center field on IC could be the initial problem evidence, that we have to investigate.

[keith_zhang]

Hi Rodrigo,

Yes, that field shows the build number and date version for identity cetner database. When IDM MMC starts up, the version it shows I think should be the IDM MMC version. Note 1595765 explains how to check the versions for different IDM components.

So the update log mxmc-update.log may record something details during the DB update. Good luck.

BR, Keith

[terovirta]

What I think the message means is the procedure MMC is trying to run is older than the installed DB schema. So something wrong with design time installation. Did you uninstall MMC / design time before you installed the new version?

[Former Member]

Yes Tero we did . The MMC was uninstalled, because if we try to install a new version without uninstall MMC, the update doesn't work, even when we stop the dispatcher, events and close the MMC.