Link to home
Create AccountLog in
Avatar of chappymcgee
chappymcgee

asked on

ASP.NET 2.0.50727.0 Event code: 3005

Every day at 12:00AM I get these error messages and they continue every minute until I restart IIS.  The asp code that this error message is complaining about runs perfectly all day, until midnight, then bam I'm getting spammed with these errors.

Event Type:      Warning
Event Source:      ASP.NET 2.0.50727.0
Event Category:      Web Event
Event ID:      1309
Date:            3/7/2008
Time:            12:01:05 AM
User:            N/A
Computer:      W
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 3/7/2008 12:01:05 AM
Event time (UTC): 3/7/2008 5:01:05 AM
Event ID: 792f3cdeed404061aea648d7d188e050
Event sequence: 17800
Event occurrence: 13
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1/Root/DundasReport-2-128493297932102944
    Trust level: Full
    Application Virtual Path: /DundasReport
    Application Path: D:\Dundas Projects\DUNDAS_RealTime_WebApp\
    Machine name: W
 
Process information:
    Process ID: 7920
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: InvalidCastException
    Exception message: Conversion from type 'DBNull' to type 'Double' is not valid.
 
Request information:
    Request URL: http://ecrpt/dundasreport/SHOPPING_frequency2.aspx 
    Request path: /dundasreport/SHOPPING_frequency2.aspx
    User host address: 10.181.107.171
    User:  
    Is authenticated: False
    Authentication Type:  
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 9
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value, NumberFormatInfo NumberFormat)
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(Object Value)
   at WebApplication7.WebForm1.Page_Load(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
 
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Avatar of Carl Tawn
Carl Tawn
Flag of United Kingdom of Great Britain and Northern Ireland image

What does the page "SHOPPING_frequency2.aspx" actually do? Some sort of database work judging from the error, perhaps something to do with the change in date at midnight.

Theres not really much more help we can give without having an idea what the page triggering the error is actually doing.
Avatar of chappymcgee
chappymcgee

ASKER

Ok, so this page and the others that are complaining are reports in the form of a gauge.  All they really do is go to the database pull a number and create the guage image with the appropriate number.


Imports System
Imports System.Collections
Imports System.ComponentModel
Imports System.Data
Imports System.Data.OleDb
Imports System.Drawing
Imports System.Web
Imports System.Web.SessionState
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.HtmlControls
Imports Dundas.Gauges.WebControl


Namespace WebApplication7
    Partial Class WebForm1
        Inherits System.Web.UI.Page


#Region " Web Form Designer Generated Code "

        'This call is required by the Web Form Designer.
        Private Sub InitializeComponent()

        End Sub
        '  Protected WithEvents SqlConnection1 As System.Data.SqlClient.SqlConnection
        ' Protected WithEvents SqlCommand1 As System.Data.SqlClient.SqlCommand


        Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
            'CODEGEN: This method call is required by the Web Form Designer
            'Do not modify it using the code editor.
            InitializeComponent()
        End Sub

#End Region

        Dim MyConn As SqlConnection = New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("connectionStringProd"))
        Dim strSQL As String
        Dim objCommand As SqlCommand
        Dim objDatareader As SqlDataReader


        Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            Dim todays_goal
            Dim goal_desc As String
            Dim max_scale
            Dim suite_str As String
            'Dim metric_str As String
            Dim report_type_str As String

            GaugeContainer1.Labels("Ttl_main").Text = "Shopping Frequency (Visits/UVs)"
            suite_str = "Shopping"
            report_type_str = "Frequency"

            goal_desc = ""

            db_Open_CONN()


            strSQL = "sp_omn_goals_Freq_Depth '" & suite_str & "','" & report_type_str & "'"
            run_sql()
            objDatareader.Read()

            todays_goal = IIf(IsDBNull(objDatareader.GetValue(0)), 10, objDatareader.GetValue(0))
            max_scale = (Math.Ceiling((todays_goal * 1.1) / 10)) * 10
            goal_desc = IIf(IsDBNull(objDatareader.GetValue(1)), "", objDatareader.GetValue(1))

            objDatareader.Close()

            strSQL = "sp_omn_metrics_Freq_Depth '" & suite_str & "','" & report_type_str & "'"


            GaugeContainer1.Labels("Ttl_sub").Text = goal_desc
            GaugeContainer1.CircularGauges("Default").Scales("Default").Maximum = max_scale
            GaugeContainer1.CircularGauges("Default").Ranges("LOW").StartValue = 0
            GaugeContainer1.CircularGauges("Default").Ranges("LOW").EndValue = todays_goal * 0.95

            GaugeContainer1.CircularGauges("Default").Ranges("MID").StartValue = todays_goal * 0.95
            GaugeContainer1.CircularGauges("Default").Ranges("MID").EndValue = todays_goal

            GaugeContainer1.CircularGauges("Default").Ranges("HIGH").StartValue = todays_goal
            GaugeContainer1.CircularGauges("Default").Ranges("HIGH").EndValue = max_scale

            ' Connect the pointer to the value source.
            GaugeContainer1.CircularGauges("Default").Pointers("Default").ValueSource = "Default"
            '            GaugeContainer1.StateIndicators(0).Text = "Data as of: " & Now


            ' Render the gauge as an image.
            GaugeContainer1.RenderType = RenderType.InputTag
            Dim actualval As Double
            run_sql()
            objDatareader.Read()
            actualval = IIf(IsDBNull(objDatareader.GetValue(0)), 0, objDatareader.GetValue(0))
            GaugeContainer1.StateIndicators(0).Text = "Data as of: " & IIf(IsDBNull(objDatareader.GetValue(1)), "No Data", objDatareader.GetValue(1))
            GaugeContainer1.NumericIndicators(0).Value = objDatareader.GetValue(0)
            GaugeContainer1.CircularGauges("Default").Pointers("Default").Value = objDatareader.GetValue(0)


            db_Close_CONN()

        End Sub
        Private Sub db_Open_CONN()
            MyConn.Open()
        End Sub
        Private Sub db_Close_CONN()
            MyConn.Close()
            MyConn = Nothing

        End Sub

        Private Sub run_sql()
            objCommand = New SqlCommand(strSQL, MyConn)
            objDatareader = objCommand.ExecuteReader()
        End Sub

    End Class


End Namespace
ASKER CERTIFIED SOLUTION
Avatar of Carl Tawn
Carl Tawn
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
We have a similar situaiton occuring on  Win2K3 Application srver. Can anyone help?

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 7/20/2010 10:52:31 AM
Event time (UTC): 7/20/2010 2:52:31 PM
Event ID: 37935827f3d74b3a835a2fd83d153172
Event sequence: 1314
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1/ROOT-1-129240633692004389
    Trust level: Full
    Application Virtual Path: /
    Application Path: c:\inetpub\wwwroot\
    Machine name: PT4APP-01
 
Process information:
    Process ID: 2916
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: Exception
    Exception message: Load report failed.
 
Request information:
    Request URL: http://pt4app-01/TransferBillPage.aspx?ID=MH568 
    Request path: /TransferBillPage.aspx
    User host address: 192.168.40.116
    User:  
    Is authenticated: False
    Authentication Type:  
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 5
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob)
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename)
   at Congoleum.TransferBillingPage.GenerateTransferBillReport(String tbid) in C:\Documents and Settings\rcarlson\My Documents\Visual Studio 2005\Projects\Congoleum\home\TransferBillPage.aspx.cs:line 574
   at Congoleum.TransferBillingPage.Page_Load(Object sender, EventArgs e) in C:\Documents and Settings\rcarlson\My Documents\Visual Studio 2005\Projects\Congoleum\home\TransferBillPage.aspx.cs:line 47
   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at Congoleum.CongoleumPage.OnLoad(EventArgs e) in C:\Documents and Settings\rcarlson\My Documents\Visual Studio 2005\Projects\Congoleum\home\Objects\CongoleumPage.cs:line 53
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
 
Custom event details:

For more information, see Help and Support Center at
still looking