August 24, 2016 at 3:23 am
Hi,
The application stopped working and I got the below error from logs. Is it related to BI or why the below error made application stopped. The DB is running on SQL 2014
==============[System Error Tracing]============== [System Name] : OSoftCPM [Message Type] : ErrorMessage [Job Name] : MetaData/GetAppSetInfo [DateTime] : 17/08/2016 04:00:14 [UserId] : [SqlException] Type : System.Data.SqlClient.SqlException Errors : System.Data.SqlClient.SqlErrorCollection Class : 11 LineNumber: 0 Message : {Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.} Number : -2 Procedure : Server : dbp1212.fgcorp.fgad.fg.local\CS,1633 State : 0 Source : .Net SqlClient Data Provider TargetSite: System.Data.ProviderBase.DbConnectionInternal GetConnection(System.Data.Common.DbConnection) HelpLink : ==============[System Error Tracing End ]==============
==============[System Error Tracing]============== [System Name] : OSoftCPM [Message Type] : ErrorMessage [Job Name] : MetaData/GetAppSetInfo [DateTime] : 17/08/2016 04:00:14 [UserId] : XXXXX [SqlException] Type : System.Data.SqlClient.SqlException Errors : System.Data.SqlClient.SqlErrorCollection Class : 11 LineNumber: 0 Message : {Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.} Number : -2 Procedure : Server : dbp1212\CS,1633 State : 0 Source : .Net SqlClient Data Provider TargetSite: System.Data.ProviderBase.DbConnectionInternal GetConnection(System.Data.Common.DbConnection) HelpLink : ==============[System Error Tracing End ]==============
==============[System Exception Tracing]============== [System Name] : DM [Message Type] : 14 [Job Name] : EvServerDataMgr.AppServerInfor.GetAppSetInfor [DateTime] : 17/08/2016 04:00:15 [UserId] : XXXXX [Exception] DetailMsg : {An error occurred while getting information from OSoftMetadata } ==============[System Exception Tracing End ]==============
==============[System Exception Tracing]============== [System Name] : DM [Message Type] : 14 [Job Name] : EvServerDataMgr.cEvServerDataMgr.GetInfo [DateTime] : 17/08/2016 04:00:15 [UserId] :XXXXX [Exception] DetailMsg : {An error occurred while getting server information } ==============[System Exception Tracing End ]==============
==============[System Exception Tracing]============== [System Name] : DM [Message Type] : 14 [Job Name] : EvServerDataMgr.cEvServerDataMgr.GetInfo [DateTime] : 17/08/2016 04:00:15 [UserId] :XXXXX [Exception] DetailMsg : {An error occurred while getting server information } ==============[System Exception Tracing End ]==============
==============[System Exception Tracing]============== [System Name] : DM [Message Type] : 14 [Job Name] : EvServerDataMgr.cEvServerDataMgr.GetInfo [DateTime] : 17/08/2016 04:00:15 [UserId] : XXXX [Exception] DetailMsg : {An error occurred while getting server information } ==============[System Exception Tracing End ]==============
[ERROR] System.Exception at OSoft.Services.Application.DataMgr.PackageExecute2008.ModifyScript.ExecuteModifyScript()
==============[System Error Tracing]============== [System Name] : OSoftCPM [Message Type] : ErrorMessage [Job Name] : MetaData/GetAppSetInfo [DateTime] : 17/08/2016 04:00:14 [UserId] :XXXXX [SqlException] Type : System.Data.SqlClient.SqlException Errors : System.Data.SqlClient.SqlErrorCollection Class : 11 LineNumber: 0 Message : {Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.} Number : -2 Procedure : Server : dbp1212l\CS,1633 State : 0 Source : .Net SqlClient Data Provider TargetSite: System.Data.ProviderBase.DbConnectionInternal GetConnection(System.Data.Common.DbConnection) HelpLink : ==============[System Error Tracing End
August 24, 2016 at 6:12 am
You have a timeout as it says in the error message: Timeout expired
Your server could be offline. You could simply have a very low client-side timeout setting. You could have a very long running query. It's hard to know more without a lot more detail.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply