Click here to Skip to main content
15,894,180 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
I am getting this error frequently when no of users are more in production server.
The issue is resolved after getting IIS Restart.Using enterprise library 4.0.can someone help me on this issue.I am not getting the error in local machine.If you restart the IIS than everything will work fine.Now every two hour I am restarting the IIS of production server.

error massage

Microsoft.Practices.EnterpriseLibrary.Data.Database.PrepareCommand(DbCommand command, DbConnection connection)
   at Microsoft.Practices.EnterpriseLibrary.Data.Database.PrepareCommand(DbCommand command, DbTransaction transaction)
   at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command, DbTransaction transaction)
   at Lera.Dal.DataService.ExecuteNonQueryByStoredProc(String storedProcedureName, Object[] parameterValues) in C:\Projects\ISCSA\PROD\ISCSA_Source Code_B\Shared\Lera.Dal\DataService.cs:line 128
   at Lera.IPCSA.DAO.DaoService`1.Save(T entity, String query) in C:\Projects\ISCSA\PROD\ISCSA_Source Code_B\IPCSA\Lera.IPCSA.DAO\DaoService.cs:line 58
   at Lera.IPCSA.DAO.AssessmentStatusTrackerDao.SaveAssessmentStatusTracker(AssessmentStatusTrackerInfo assessmentStatusTracker) in C:\Projects\ISCSA\PROD\ISCSA_Source Code_B\IPCSA\Lera.IPCSA.DAO\AssessmentStatusTrackerDao.cs:line 32
   at Lera.IPCSA.Business.AssessmentStatusTrackerBL.SaveAssessmentStatusTracker(AssessmentStatusTrackerInfo assessmentStatusTracker) in C:\Projects\ISCSA\PROD\ISCSA_Source Code_B\IPCSA\Lera.IPCSA.Business\AssessmentStatusTrackerBL.cs:line 21
   at Lera.IPCSA.UI.Web.Assessment.AssessmentLevelDetails.SaveAssessmentStatusTracker(String Status) in C:\Projects\ISCSA\PROD\ISCSA_Source Code_B\IPCSA\Lera.IPCSA.UI.Web\Assessment\AssessmentLevelDetails.aspx.cs:line 1228
   at Lera.IPCSA.UI.Web.Assessment.AssessmentLevelDetails.SaveAssessment(Boolean isConstructRequired, String Status) in C:\Projects\ISCSA\PROD\ISCSA_Source Code_B\IPCSA\Lera.IPCSA.UI.Web\Assessment\AssessmentLevelDetails.aspx.cs:line 1036
   at Lera.IPCSA.UI.Web.Assessment.AssessmentLevelDetails.NavigateSubDomain(Boolean navigateNextSubDomain, Boolean isFromButtons, Boolean isDomainChange) in C:\Projects\ISCSA\PROD\ISCSA_Source Code_B\IPCSA\Lera.IPCSA.UI.Web\Assessment\AssessmentLevelDetails.aspx.cs:line 813
   at Lera.IPCSA.UI.Web.Assessment.AssessmentLevelDetails.btnNext_Click(Object sender, EventArgs e) in C:\Projects\ISCSA\PROD\ISCSA_Source Code_B\IPCSA\Lera.IPCSA.UI.Web\Assessment\AssessmentLevelDetails.aspx.cs:line 786
   at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)




The code i was executing is
C#
public DataSet GetDataSetByStoredProc(string storedProcedureName, params object[] parameterValues)
        {
            DbCommand command = Database.GetStoredProcCommand(storedProcedureName);
           
            foreach (object parameterValue in parameterValues)
            {
                command.Parameters.Add(parameterValue);
            }

            return Database.ExecuteDataSet(command);
        }
Posted
Updated 25-Jul-13 12:17pm
v3
Comments
Sergey Alexandrovich Kryukov 25-Jul-13 18:38pm    
Your stack trace shows that it is not related to the code sample. None of the methods shown in the code are shown in the stack trace. It's is either incomplete; or your code sample is unrelated to the problem, or both...
—SA
Ron Beyer 25-Jul-13 20:23pm    
I was going to say the same thing, the method with the error is Lera.Dal.DataService.ExecuteNonQueryByStoredProc in the file C:\Projects\ISCSA\PROD\ISCSA_Source Code_B\Shared\Lera.Dal\DataService.cs
Sergey Alexandrovich Kryukov 25-Jul-13 21:16pm    
Well pin-pointed...
—SA

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900