Application errors might be related to SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Application errors might be related to SQL

Application errors might be related to SQL

Rate Topic

Display Mode

Topic Options

Author

Message

beejug1983

Posted Thursday, March 10, 2011 8:01 AM

SSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 2:18 AM
Points: 264, Visits: 1,288

Hi,

One of client facing this error in his application, they are using SQL Server 2000 as a back end. I am pasting the error log of application. Please have a look and provide the solutions.

Thanks in advance.

--------------------------------------------------------------------------------------------------
08.03.2011 12:16:41 ASP.NET 2.0.50727.0 Warning Web Event 1309 N/A Servername "Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 08.03.2011 12:16:41
Event time (UTC): 08.03.2011 11:16:41
Event ID: ce3af9383114408bb02f59361b330621
Event sequence: 76
Event occurrence: 2
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/37541031/ROOT/TPDREPORTS-1-129440558406204284
Trust level: Full
Application Virtual Path: /TPDREPORTS
Application Path: C:\Inetpub\TPDApp\TPDReports\
Machine name: Servername

Process information:
Process ID: 3088
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.

Request information:
Request URL: http://hub.posten.no/TPDReports/SearchReports.aspx?type=advanced
Request path: /TPDReports/SearchReports.aspx
User host address: IP ADdress
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 8
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at TPDReports.SearchReports.btnSearch_Click(Object sender, EventArgs e)
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)

Custom event details:
"
08.03.2011 12:10:42 ASP.NET 2.0.50727.0 Warning Web Event 1309 N/A Servername "Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 08.03.2011 12:10:42
Event time (UTC): 08.03.2011 11:10:42
Event ID: 41d0431a74f544029269ce82b3779688
Event sequence: 18
Event occurrence: 1
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/37541031/ROOT/TPDREPORTS-1-129440558406204284
Trust level: Full
Application Virtual Path: /TPDREPORTS
Application Path: C:\Inetpub\TPDApp\TPDReports\
Machine name: Servername

Process information:
Process ID: 3088
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.

Request information:
Request URL: http://hub.posten.no/TPDReports/SearchReports.aspx?type=advanced
Request path: /TPDReports/SearchReports.aspx
User host address: IP Address
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at TPDReports.SearchReports.btnSearch_Click(Object sender, EventArgs e)
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)

Custom event details:
"
08.03.2011 12:10:26 MsiInstaller Information None 11707 NT AUTHORITY\SYSTEM

--------------------------------------------------------------------------------------------------
08.03.2011 12:16:41 ASP.NET 2.0.50727.0 Warning Web Event 1309 N/A Servername "Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 08.03.2011 12:16:41
Event time (UTC): 08.03.2011 11:16:41
Event ID: ce3af9383114408bb02f59361b330621
Event sequence: 76
Event occurrence: 2
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/37541031/ROOT/TPDREPORTS-1-129440558406204284
Trust level: Full
Application Virtual Path: /TPDREPORTS
Application Path: C:\Inetpub\TPDApp\TPDReports\
Machine name: Servername

Process information:
Process ID: 3088
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.

Request information:
Request URL: http://hub.posten.no/TPDReports/SearchReports.aspx?type=advanced
Request path: /TPDReports/SearchReports.aspx
User host address: IP ADdress
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 8
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at TPDReports.SearchReports.btnSearch_Click(Object sender, EventArgs e)
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)

Custom event details:
"
08.03.2011 12:10:42 ASP.NET 2.0.50727.0 Warning Web Event 1309 N/A Servername "Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 08.03.2011 12:10:42
Event time (UTC): 08.03.2011 11:10:42
Event ID: 41d0431a74f544029269ce82b3779688
Event sequence: 18
Event occurrence: 1
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/37541031/ROOT/TPDREPORTS-1-129440558406204284
Trust level: Full
Application Virtual Path: /TPDREPORTS
Application Path: C:\Inetpub\TPDApp\TPDReports\
Machine name: Servername

Process information:
Process ID: 3088
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.

Request information:
Request URL: http://hub.posten.no/TPDReports/SearchReports.aspx?type=advanced
Request path: /TPDReports/SearchReports.aspx
User host address: IP Address
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at TPDReports.SearchReports.btnSearch_Click(Object sender, EventArgs e)
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)

Custom event details:
"
08.03.2011 12:10:26 MsiInstaller Information None 11707 NT AUTHORITY\SYSTEM servername Product: Unicenter Asset Management SW Metering Agent -- Installation operation completed successfully.
08.03.2011 11:43:11 ASP.NET 2.0.50727.0 Warning Web Event 1309 N/A Servername "Event code: 3001
Event message: The request has been aborted.
Event time: 08.03.2011 11:43:11
Event time (UTC): 08.03.2011 10:43:11
Event ID: 8d9952e0148f42a79422aa0e2e900f3a
Event sequence: 1973
Event occurrence: 4
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/37541031/ROOT/TPDREPORTS-1-129440368695026012
Trust level: Full
Application Virtual Path: /TPDREPORTS
Application Path: C:\Inetpub\TPDApp\TPDReports\
Machine name: Servername

Process information:
Process ID: 4860
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: HttpException
Exception message: Request timed out.

Thread information:
Thread ID: 13
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at TPDCommon.ordreDbComp.UpdateOrdreInfo(String stringToUpdate, String databaseField, Int32 ordreId, Int32 brukerId) in C:\Users\rust\Documents\Visual Studio 2008\Projects\.TPD.root\TPDCommon\ordreDbComp.cs:line 235
at TPDApp.UI.OrdreForm.SaveOrderInfo(String updateControlID)
at TPDApp.UI.OrdreForm.Some_TextChanged(Object sender, EventArgs e)
at System.Web.UI.WebControls.ListControl.OnSelectedIndexChanged(EventArgs e)
at System.Web.UI.WebControls.DropDownList.RaisePostDataChangedEvent()
at System.Web.UI.WebControls.DropDownList.System.Web.UI.IPostBackDataHandler.RaisePostDataChangedEvent()
at System.Web.UI.Page.RaiseChangedEvents()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

27.12.2010 07:34:38 MsiInstaller Information None 11707 NT AUTHORITY\SYSTEM servername Product: Unicenter Asset Management SW Metering Agent -- Installation operation completed successfully.
27.12.2010 07:32:02 ITO Information None 5 N/A Servername The description for Event ID ( 5 ) in Source ( ITO ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 139.116.188.8.
27.12.2010 07:32:02 ITO Information None 5 N/A Servername The description for Event ID ( 5 ) in Source ( ITO ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: IP address.
27.12.2010 07:24:37 AutoEnrollment Error None 13 N/A Servername "Automatic certificate enrollment for local system failed to enroll for one Client Authentication certificate (0x800706ba). The RPC server is unavailable.
"
27.12.2010 04:16:28 SceCli Information None 1704 N/A Servername Security policy in the Group policy objects has been applied successfully.
27.12.2010 01:05:58 DSM Error CAF 1000 N/A Servername Caf encountered an error: Failed to register with scalability server . The specified operation has expired. The timeout is usually a client supplied value.
26.12.2010 23:24:38 AutoEnrollment Error None 13 N/A Servername "Automatic certificate enrollment for local system failed to enroll for one Client Authentication certificate (0x800706ba). The RPC server is unavailable.
"
26.12.2010 21:14:09 Symantec AntiVirus Information None 2 N/A Servername "

Scan Complete: Risks: 0 Scanned: 472329 Files/Folders/Drives Omitted: 188"
26.12.2010 20:54:10 Symantec AntiVirus Warning None 6 N/A Servername "

Could not scan 43 files inside c:\temp\UNINSM_3.0_WIN (D)\ENU\NT\ARCFiles\Data.Cab due to extraction errors encountered by the Decomposer Engines.Application has encountered an error.
For more information, please go to: http://www.symantec.com/techsupp/servlet/ProductMessages?product=SAVCORP&version=11.0.4202.48&language=norwegian&module=1000&error=0014&build=symantec_ent
"
26.12.2010 20:53:57 Symantec AntiVirus Warning None 6 N/A Servername "

Could not scan 1 files inside c:\temp\UNINSM_3.0_WIN (D)\DOC\rp505enu.exe due to extraction errors encountered by the Decomposer Engines.Application has encountered an error.
For more information, please go to: http://www.symantec.com/techsupp/servlet/ProductMessages?product=SAVCORP&version=11.0.4202.48&language=norwegian&module=1000&error=0014&build=symantec_ent
"
26.12.2010 20:53:00 Symantec AntiVirus Warning None 6 N/A Servername "

Could not scan 2 files inside c:\temp\eTrust Antivirus 7.1 - installasjonssett\Bin\USD\NetApps\eAV.NetApps.Image\Data1.cab due to extraction errors encountered by the Decomposer Engines.Application has encountered an error.
For more information, please go to: http://www.symantec.com/techsupp/servlet/ProductMessages?product=SAVCORP&version=11.0.4202.48&language=norwegian&module=1000&error=0014&build=symantec_ent
"
26.12.2010 20:52:33 Symantec AntiVirus Warning None 6 N/A Servername "

Could not scan 4 files inside c:\temp\eTrust Antivirus 7.1 - installasjonssett\Bin\eAV.PPC\caavppc.exe due to extraction errors encountered by the Decomposer Engines.Application has encountered an error.
For more information, please go to: http://www.symantec.com/techsupp/servlet/ProductMessages?product=SAVCORP&version=11.0.4202.48&language=norwegian&module=1000&error=0014&build=symantec_ent
"
26.12.2010 20:52:33 Symantec AntiVirus Warning None 6 N/A Servername "

Product: Unicenter Asset Management SW Metering Agent -- Installation operation completed successfully.
08.03.2011 11:43:11 ASP.NET 2.0.50727.0 Warning Web Event 1309 N/A Servername "Event code: 3001
Event message: The request has been aborted.
Event time: 08.03.2011 11:43:11
Event time (UTC): 08.03.2011 10:43:11
Event ID: 8d9952e0148f42a79422aa0e2e900f3a
Event sequence: 1973
Event occurrence: 4
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/37541031/ROOT/TPDREPORTS-1-129440368695026012
Trust level: Full
Application Virtual Path: /TPDREPORTS
Application Path: C:\Inetpub\TPDApp\TPDReports\
Machine name: Servername

Process information:
Process ID: 4860
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: HttpException
Exception message: Request timed out.

Thread information:
Thread ID: 13
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at TPDCommon.ordreDbComp.UpdateOrdreInfo(String stringToUpdate, String databaseField, Int32 ordreId, Int32 brukerId) in C:\Users\rust\Documents\Visual Studio 2008\Projects\.TPD.root\TPDCommon\ordreDbComp.cs:line 235
at TPDApp.UI.OrdreForm.SaveOrderInfo(String updateControlID)
at TPDApp.UI.OrdreForm.Some_TextChanged(Object sender, EventArgs e)
at System.Web.UI.WebControls.ListControl.OnSelectedIndexChanged(EventArgs e)
at System.Web.UI.WebControls.DropDownList.RaisePostDataChangedEvent()
at System.Web.UI.WebControls.DropDownList.System.Web.UI.IPostBackDataHandler.RaisePostDataChangedEvent()
at System.Web.UI.Page.RaiseChangedEvents()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

27.12.2010 07:34:38 MsiInstaller Information None 11707 NT AUTHORITY\SYSTEM servername Product: Unicenter Asset Management SW Metering Agent -- Installation operation completed successfully.
27.12.2010 07:32:02 ITO Information None 5 N/A Servername The description for Event ID ( 5 ) in Source ( ITO ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: IP address.
27.12.2010 07:32:02 ITO Information None 5 N/A Servername The description for Event ID ( 5 ) in Source ( ITO ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 139.116.188.8.
27.12.2010 07:24:37 AutoEnrollment Error None 13 N/A Servername "Automatic certificate enrollment for local system failed to enroll for one Client Authentication certificate (0x800706ba). The RPC server is unavailable.
"
27.12.2010 04:16:28 SceCli Information None 1704 N/A Servername Security policy in the Group policy objects has been applied successfully.
27.12.2010 01:05:58 DSM Error CAF 1000 N/A Servername Caf encountered an error: Failed to register with scalability server P-112-286-031. The specified operation has expired. The timeout is usually a client supplied value.
26.12.2010 23:24:38 AutoEnrollment Error None 13 N/A Servername "Automatic certificate enrollment for local system failed to enroll for one Client Authentication certificate (0x800706ba). The RPC server is unavailable.
"
26.12.2010 21:14:09 Symantec AntiVirus Information None 2 N/A Servername "

Scan Complete: Risks: 0 Scanned: 472329 Files/Folders/Drives Omitted: 188"
26.12.2010 20:54:10 Symantec AntiVirus Warning None 6 N/A Servername "

Could not scan 43 files inside c:\temp\UNINSM_3.0_WIN (D)\ENU\NT\ARCFiles\Data.Cab due to extraction errors encountered by the Decomposer Engines.Application has encountered an error.
For more information, please go to: http://www.symantec.com/techsupp/servlet/ProductMessages?product=SAVCORP&version=11.0.4202.48&language=norwegian&module=1000&error=0014&build=symantec_ent
"
26.12.2010 20:53:57 Symantec AntiVirus Warning None 6 N/A Servername "

Could not scan 1 files inside c:\temp\UNINSM_3.0_WIN (D)\DOC\rp505enu.exe due to extraction errors encountered by the Decomposer Engines.Application has encountered an error.
For more information, please go to: http://www.symantec.com/techsupp/servlet/ProductMessages?product=SAVCORP&version=11.0.4202.48&language=norwegian&module=1000&error=0014&build=symantec_ent
"
26.12.2010 20:53:00 Symantec AntiVirus Warning None 6 N/A Servername "

Could not scan 2 files inside c:\temp\eTrust Antivirus 7.1 - installasjonssett\Bin\USD\NetApps\eAV.NetApps.Image\Data1.cab due to extraction errors encountered by the Decomposer Engines.Application has encountered an error.
For more information, please go to: http://www.symantec.com/techsupp/servlet/ProductMessages?product=SAVCORP&version=11.0.4202.48&language=norwegian&module=1000&error=0014&build=symantec_ent
"
26.12.2010 20:52:33 Symantec AntiVirus Warning None 6 N/A Servername "

Could not scan 4 files inside c:\temp\eTrust Antivirus 7.1 - installasjonssett\Bin\eAV.PPC\caavppc.exe due to extraction errors encountered by the Decomposer Engines.Application has encountered an error.
For more information, please go to: http://www.symantec.com/techsupp/servlet/ProductMessages?product=SAVCORP&version=11.0.4202.48&language=norwegian&module=1000&error=0014&build=symantec_ent
"
26.12.2010 20:52:33 Symantec AntiVirus Warning None 6 N/A Servername "

Post #1076264

Dwayne Dibley

Posted Thursday, March 10, 2011 8:14 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:41 AM
Points: 365, Visits: 2,900

OK, from what I can see, you have an unhandled exception in btn_Search_Click. Stick some error handling in there at least. You have a null reference exception, so an object is not being instantiated as it should. Your best bet is to put a breakpoint in btn_Search_Click and trace what happens. This will help narrow down the possible causes.

Post #1076276

beejug1983

Posted Thursday, March 10, 2011 9:01 AM

SSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 2:18 AM
Points: 264, Visits: 1,288

Hi Rjohal

Thanks for your reply I try to do the things you provided.

Thanks

Post #1076327

« Prev Topic | Next Topic »

Permissions