Error occured in the web application.

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
abhibandil
Posts: 6
Joined: Wed 03 Dec 2014 07:37

Error occured in the web application.

Post by abhibandil » Wed 03 Dec 2014 07:44

System.Configuration.Provider.ProviderException
An exception occurred. Please contact your administrator.

System.Web.HttpException (0x80004005): Exception of type 'System.Web.HttpException' was thrown. ---> System.Configuration.Provider.ProviderException: An exception occurred. Please contact your administrator.
at Devart.Common.Web.Providers.DbSessionStateStore.a(Boolean A_0, HttpContext A_1, String A_2, Boolean& A_3, TimeSpan& A_4, Object& A_5, SessionStateActions& A_6)
at Devart.Common.Web.Providers.DbSessionStateStore.GetItemExclusive(HttpContext context, String id, Boolean& locked, TimeSpan& lockAge, Object& lockId, SessionStateActions& actionFlags)
at System.Web.SessionState.SessionStateModule.GetSessionStateItem()
at System.Web.SessionState.SessionStateModule.PollLockedSessionCallback(Object state)
at System.Web.SessionState.SessionStateModule.EndAcquireState(IAsyncResult ar)
at System.Web.HttpApplication.AsyncEventExecutionStep.OnAsyncEventCompletion(IAsyncResult ar)

The above error occurred sometime while accessing the web application.
I am not able to reproduce this issue, Please help and let me know how can reproduce and resolve this issue.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Error occured in the web application.

Post by Pinturiccio » Wed 03 Dec 2014 16:14

There is not enough information for investigation and reproducing the issue. If possible, please create and send us a small test project with the corresponding DDL/DML scripts.

Please also send us the full message from EventLog.

Additionally you can attach Visual Studio to your application and catch the exception that occurs before the issue.

abhibandil
Posts: 6
Joined: Wed 03 Dec 2014 07:37

Re: Error occured in the web application.

Post by abhibandil » Thu 04 Dec 2014 05:01

The issue is sporadic and it is not possible to provide a demo project. But below are some more details related to it:
1. While access the application randomly it gives the exception stated is previous post.

2. There is another exception that we face, if user after logging into application does not access it for long time and then when clicks on any service that he wants to use then we get following exception:

System.Configuration.Provider.ProviderException
An exception occurred. Please contact your administrator.

System.Configuration.Provider.ProviderException: An exception occurred. Please contact your administrator.
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)

We are using following DLLs along with Entity framework(v4.1) in our application:

1. Devart.Data v5.0.272.0
2. Devart.Data.Oracle v6.30.172.0
3. Devart.Data.Oracle.Entity v6.30.172.0
4. Devart.Data.Oracle.Web v6.30.172.0

abhibandil
Posts: 6
Joined: Wed 03 Dec 2014 07:37

Re: Error occured in the web application.

Post by abhibandil » Mon 08 Dec 2014 05:20

I am waiting for your response, Please let me know if you need more information.

abhibandil
Posts: 6
Joined: Wed 03 Dec 2014 07:37

Re: Error occured in the web application.

Post by abhibandil » Tue 09 Dec 2014 07:37

Any Updates?
Please reply asap

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Error occured in the web application.

Post by Pinturiccio » Tue 09 Dec 2014 10:46

Sorry for the delay.

We can see only the external exception generated by our provider in the information you have provided. We need the inner exception that is caught by our provider in order to find out the reason of the issue. You can get the inner exception using one of the following two ways:

1. Specify the following attribute in the sessionState provider description 'writeExceptionsToEventLog="true"'. This attribute allows recording exceptions to event logs.

2. Debug your application with Visual Studio:
- Start your application;
- Run a Visual Studio instance;
- In the open Visual Studio instance on the Debug menu, click Attach to Process;
- In the displayed window, select the process of your application;
- On the Debug menu, click 'Options and Settings...';
- In the Options dialog box switch to the Debugging->General page, and clear the 'Enable Just My Code (Managed only)' check box, if it is selected;
- On the Debug menu, click Exceptions and select the 'Common Language Runtime Exceptions' check box;
- Then switch back to your application and reproduce the issue;
- The exception in your application will be caught in the Visual Studio instance, and you can get all the information about the exception including its internal exceptions.

abhibandil
Posts: 6
Joined: Wed 03 Dec 2014 07:37

Re: Error occured in the web application.

Post by abhibandil » Mon 24 Jul 2017 07:18

In the Event Viewer, we are getting below error.

"
communicating with the data source.

Action: CreateUninitializedItem

Exception: Devart.Data.Oracle.OracleException (0x80004005): ORA-00001: unique constraint (ASPNET_SESSIONS_SESSIONID_PK) violated
at Devart.Data.Oracle.bi.d(Int32 A_0)
at Devart.Data.Oracle.c1.a(Int32 A_0, co A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
at Devart.Common.Web.Providers.DbSessionStateStore.CreateUninitializedItem(HttpContext context, String id, Int32 timeout)
"

Even I had google for above issue and found there is an issue for regenerateExpiredSessionId
If I will use regenerateExpiredSessionId = false then issue would be resolve But hard luck.

Issue still persist, please let me know other ways so that I can resolve above issue.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Error occured in the web application.

Post by Pinturiccio » Wed 26 Jul 2017 14:43

Could you tell us which dotConnect version do you use? Is it still 6.30.172, or you use a newer version now?

Please also post here a snippet of code which causes the exception.

abhibandil
Posts: 6
Joined: Wed 03 Dec 2014 07:37

Re: Error occured in the web application.

Post by abhibandil » Fri 28 Jul 2017 06:03

dotConnect Version: 8.5.616.0


We are using Session State provider in the application and link below:

https://www.devart.com/dotconnect/oracl ... ssionstate

Please let me know if any other information needed

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Error occured in the web application.

Post by Pinturiccio » Tue 01 Aug 2017 10:32

We need to reproduce the problem in our environment to find out the true reason. Unfortunately, in case when an issue is sporadic, and cannot be reproduced on every run, we are unable to reproduce and study it.

If you are able to localize the issue in a sample project, send it to us.

Post Reply