cancel
Showing results for 
Search instead for 
Did you mean: 

Query time out error in SAP IdM 7.2

Former Member
0 Kudos

We are using SAP IdM 7.2 SP7. Suddenly i am seeing query time out error while opening the identity centre.

Also not able to login to IdM web console as it keeps loading forever.

What could be the reason ? Does any one face such issue before ?

I could able to connect to backend DB and able to browse through some of the standard views (idmv_entry_simple_all) but some keeps getting executed  (mxpv_job_tasklink) and results in timeout.

Is it problem with database or MMC console (ScopeItems_Expand) ?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

It looks like a database problem. Do idm database share other applications on it's server?

I would recomand you those checks :

- First stop your AS Java server.

- Check on your server side if there is consuming processes (like java) running and kill them, be sure that they are related to IDM.

- Check the job status and queue on mxp_provision, this can give you an idea if there is any errored/still running jobs and which ones.

Fadoua

Former Member
0 Kudos

Thanks Guys for the inputs.

It is a database issue. There was some blockage that DB team has manually removed it and looks good now.

(@P0 int,@P1 int,@P2 int,@P3 int,@P4 int,@P5 int,@P6 int,@P7 int)update MXI_ATTRIBUTES set DELTASK=@P0,MODTASK=@P1,INSTASK=@P2,SQLACCESSTASK=@P3,REFERENCEOBJECTCLASS=@P4,OWNER_ID=@P5,EXTERNALREPOSITORY=@P6 WHERE (ATTR_ID=@P7);                                                           

Looks some task or import has messed it up 🙂

Steffi_Warnecke
Active Contributor
0 Kudos

Hello ,

please close the thread by marking your post as the correct one (since it contains the solution). 

To learn why this is important, you can read the blog

Regards,

Steffi.

Former Member
0 Kudos

Yes did 🙂

Answers (1)

Answers (1)

Former Member
0 Kudos

You can try to download debugview (search in popular searchengine) to see what the MMC is doing, then attach it to a support ticket so we can look at it if we cant figure it out here. It could be that its stuck in a loop that its unabel to detect or a table is locked. The debugview log should help a bit.

Since the part of the settings (location in the tree for instance) is stored in the identity center.msc file you can also try to copy the original .msc file from the designtime setup. Make a copy of the current one first though just to be sure. You can find the original file in the design time install as "Setup\usr\sap\IdM\Identity Center\identity center.msc" and drop it into "/usr/sap/idm/identity center" or your alternative install path. This will reset the config of the console, but retain all your connection parameters etc.

Best regards,

Per Christian