Page 1 of 1

Oracle Session State Provider - PK violation

Posted: Wed 25 May 2011 21:44
by cglock
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)

Posted: Thu 26 May 2011 14:44
by Shalex
Please give us the following information:
1) the exact version (x.xx.xxx) 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).