on 12-18-2013 10:54 AM
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) ?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 🙂
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.