on 04-26-2011 1:50 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Huseyin,
Have you solved this issue , if you have solved would it be possible ( remember ) and share it with me?
Kind Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
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.