You are viewing limited content. For full access, please sign in.

Question

Question

Getting Query TimeOut error when requesting a create a new report in LF Audit 9.0.3.798. Restarted services and rebooted SQL Server. Same results

Audit Trail
Updated January 28, 2014
asked on January 27, 2014

This started showing up.  When you try and request a create a new report, we are getting a sql query timeout expired with the sql native client.  The Audit trail SQL db has about 1 years 2 months of data in it about 140 GB at this time.

 

Here is the detailed message in event viewer

 

ERROR [HYT00] [Microsoft][SQL Native Client]Query timeout expired

Server stack trace:

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)

at AuditDBService.DataProfile.GetLoadedFiles(String repositoryName, String dateRangeId)

at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)

at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

Exception rethrown at [0]:

at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

at AuditRemoting.IImportStatus.GetLoadedFiles(String reposName, String dateRangeId)

at WebAuditReport.QueryableDataCtrl.QueryableDataCtrl.GetListOfQuerableItems(OverallReportParams param)

at WebAuditReport.QueryableDataCtrl.QueryableDataCtrl.Page_Load(Object sender, EventArgs e)

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 System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

ERROR [HYT00] [Microsoft][SQL Native Client]Query timeout expired

Server stack trace:

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)

at AuditDBService.DataProfile.GetLoadedFiles(String repositoryName, String dateRangeId)

at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)

at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

Exception rethrown at [0]:

at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

at AuditRemoting.IImportStatus.GetLoadedFiles(String reposName, String dateRangeId)

at WebAuditReport.QueryableDataCtrl.QueryableDataCtrl.GetListOfQuerableItems(OverallReportParams param)

at WebAuditReport.QueryableDataCtrl.QueryableDataCtrl.Page_Load(Object sender, EventArgs e)

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 System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 

 

0 0

Answer

APPROVED ANSWER
replied on January 28, 2014

Hi Don,

 

The best solution is probably going to be adding a date range or some other limiting condition to your report, so as to reduce the number of rows being returned by SQL.  You could also modify the query timeout settings in SQL, if you feel so inclined.  Typically, errors like this are just caused by SQL needing to work with a huge number of rows, and there's not much we can do on our end except limit the amount of data being worked with.  If my suggestions don't help at all, you can open a Support case to get to the bottom of the issue.

0 0

Replies

replied on January 28, 2014

I have been getting a similar timeout in the older version 8.2.1 so it isn't anything new.  Never have been able to resolve except by reducing the columns that are retrieved and shorten the search time span.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...