Management Reporter SQL Timeout Error

(0) Share

Report

Posted on by Community Member

Hi,

WHen trying to run a report, in MR, the below error is logged in the event viewer. Is there a timeout setting that can be changed?

Event Type: Error
Event Source: Management Reporter Services
Event Category: None
Event ID: 0
Date:  5/4/2011
Time:  3:55:12 PM
User:  N/A
Description:

Timestamp: 5/4/2011 3:55:12 PM
Message: System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.AccountBalanceReader.Open()
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLBalanceResult.GetNextReader()
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLDataProcessor.ProcessOneBalanceResult(GLBalanceResult balanceResult, Int32 rowNumber)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLLinkAdapter.RetrieveGLDataBatch(Int32 rowNumber)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLLinkAdapter.GetData()
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportUnitProcessor.RetrieveLinkData()
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportUnitProcessor.RetrieveData()
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportProcessor.RunAllUnitProcessors()
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportGenerator.ProcessReport(Definition definition, Action`1 resultHandler)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.EngineController.GenerateReport(Action`1 resultHandler)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.EngineController.Run(NativeReport repositoryReport, Definition definition)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.QueueWatcher.WatchQueue()

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Thanks,

Sandeep.

*This post is locked for comments

I have the same question (0)

All responses (24)

Answers (1)

Community Member on at

Like (0)

Report

Sorry - We are on MR FP1. Version 2.0.1664.19 and using with GP2010 Sp1.

Both MR and GP are on the same Windows 2003 Server - 64bit.

Was this reply helpful? Yes No
April Olson on at

Like (0)

Report

Hello Sandeep,

Are you using Analytical Accounting, or just GP without AA? This is not common; it may be a good idea to run a SQL profile to help determine a more common cause to why you cannot connect. Are there any major processes being run in GP at the same time, or does this happen every time you generate a report? It may be a good idea to contact Support if the SQL Profile does not point to a more succinct cause as this seems like a rare occurrence.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi April,

no, we are not using AA. This is a stand alone test GP server, so there is no activity except for MR.

I will try the sql trace. This issue happes for any report that has multiple months in the column layout - e.g. 12 month Income Statement. If i make it a single month by deleting the other columns, the report generates fine.

Thanks,

Sandeep.

Was this reply helpful? Yes No
April Olson on at

Like (0)

Report

Hello Sandeep,

There was a timeout issue that was resolved in the latest update to Managment Reporter for GP. If you go to the Management Reporter Overview page you and download the latest provider and install it. That should hopefully resolve the issue. If it does not, it would be a great idea to work with support to help narrow down the cause.

Thanks,

April

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks April!

I am unable to find the hotfix file, unless it is the file called "DynamicsGPDataProvider4MR.zip" - which is the updated install for the data provider including the hotfix. I found this at the following location -

mbs.microsoft.com/.../MRInstall

Sandeep.

Was this reply helpful? Yes No
April Olson on at

Like (0)

Report

mbs2.microsoft.com/fileexchange

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks April. I installed it and still getting the timeout error on the larger reports. I will reach out to support on this one, but thanks a lot for your help.

Sandeep.

Was this reply helpful? Yes No
Tina Sarkar 595 on at

Like (0)

Report

Hi Sandeep,

Are you trying to retrieve YTD or periodic balance in report? If using YTD, can you try to generate a report by changing Period to 1: BASE and Periods Covered to PERIODIC

Tina

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Tina,

Thanks for the response and yes, that seems to make it work. Its funny that i am only trying with a 4 column layout and it should timeout if the columns are YTD. Infact, this time on, i was seeing deadlock errors as well. I also had applied the SP2 for MR yesterday hoping it would fix my issue.

Sandeep.

Was this reply helpful? Yes No
Ryan Sandness on at

Like (0)

Report

I'm not aware of any outstanding performance issues that would cause a timeout like this. Sandeep can you contact the support team and they can take a look at the difference between the two reports?

Make sure you installed the provider included with the SP2 updates.

Thanks

Ryan

Was this reply helpful? Yes No