Oracle Session State Provider - PK violation

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 4
Joined: Sat 01 Sep 2007 19:01

Oracle Session State Provider - PK violation

Post by 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)

Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by 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).

Post Reply