Oracle Session State Provider - PK violation

Oracle Session State Provider - PK violation

Postby cglock » Wed 25 May 2011 21:44

Any help would be appreciated. We are running into an issue in our production environment where the session state provider is trying to do multiple inserts for the same session/applicationname combo.

(Message #1)
ORA-00001: unique constraint (ASPNET_SESSIONS_SESSIONID_PK) violated

(StackTrace #1)
at Devart.Common.Web.Providers.DbSessionStateStore.CreateUninitializedItem(HttpContext context, String id, Int32 timeout)
at System.Web.SessionState.SessionStateModule.GetSessionStateItem()
at System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData)
at System.Web.HttpApplication.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Posts: 4
Joined: Sat 01 Sep 2007 19:01

Postby Shalex » Thu 26 May 2011 14:44

Please give us the following information:
1) the exact version ( of your dotConnect for Oracle;
2) your configuration of Session State provider. Is it the same as the one mentioned in our documentation?
3) the exact steps we should follow to reproduce the problem. A small test project will be appreciated (contact form).
Devart Team
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for Oracle