IDM 7.20 Timeout during adding new Identity Store

[HuseyinBilgen]

Hi,

According to the SAP NetWeaver Identity Management Identity Management for SAP System Landscapes Configuration Guide, I'm trying to add a new Identity Store named as SAP_Master. But following timeout error occurs.

Method: mnuNewldStore

Source: Microsoft OLE DB Provider For SQL Server

Error: 80040E31h (-2147217871)

Description: Timeout expired

Im using SQL 2008 as Database and tried to apply all timeout parameters on SQL side.

helps appreciated

[ChrisPS]

Hello Huseyin,

                      you will need to ask your db admins to check if there is any long running sql query in the IdM db that may cause the timeout e.g there maybe some deadlock occuring. To date there are no

reported errors in the IdM application therefore it points to some issue at database level.

You can check the db activity monitor or the below query

SELECT database_id,

st.text, r.session_id,

r.status, r.command, r.cpu_tim

FROM sys.dm_exec_requests r

CROSS APPLY sys.dm_exec_sql_text(sql_handle)

when attempting to add an identity store. Also try a restart of the db to see if this eliminates the issue.

Regards,

Chris

SAP Active Global Support

[Former Member]

Hi Huseyin,

Have you solved this issue , if you have solved would it be possible ( remember ) and share it with me?

Kind Regards.