12 Replies Latest reply: Mar 22, 2011 4:40 PM by 825850 RSS

    ODAC SessionState error ORA-00001: unique constraint ...violated

    622241
      Hi,

      We are using the 11g ODAC session state provider and running into the following issue from time to time when the user submits several requests in a row (i.e. clicking the submit button on a form too may times)
      This does not happen when we switch to SQL sever. Any ideas?

      [OracleException (0x80004005): ORA-00001: unique constraint (ODAC_PROV.SYS_C0013256) violated
      ORA-06512: at "ODAC_PROV.ORA_ASPNET_SESSN_INSSTATEITEM", line 15
      ORA-06512: at line 1]
      Oracle.Web.SessionState.OracleSessionStateStore.SetAndReleaseItemExclusive(HttpContext context, String id, SessionStateStoreData item, Object lockId, Boolean newItem) +3335
      System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs) +355
      System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
      System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

      Thank you!