You’re offline. This is a read only version of the page.
636
I have a user the reports GP is not responding when creating a detailed trial balance. It happens when other tasks in GP are done as well. I have two other users that seem to be working fine most of the time but the user that is having trouble may be performing more resource intensive tasks.
I suspected the issue may be with server resources. I have tried the following so far.
Doubled the SQL VM CPUs from two to four
disabled AV
Made sure power saving features of all NICs were disabled
Confirmed max concurrent connections was set to 0.
In SQL Server Management Studio, right-click on the SQL instance name in the left margin and choose PROPERTIES. In the Server Properties window, click on the CONNECTIONS page. Verify the 'Maximum number of concurrent connections' is set to 0 (zero) which is for unlimited connections. This is the default setting for SQL Serve
performed ping test. Connection looks fine.
All of this seems to have improved the issue. It only happened once today instead of several times. I am also going to increase the RAM on the server next week. I am also wondering if the server HDD could be a bottle neck but I'm not sure how to confirm. The SQL database is hosted on a VM which resides on Hyper-V server 2012 R2.
I searched the log on the SQL server and found this at the time the user reported the latest issue.
Reader returned fewer objects for processing (0) than expected (5).
--- Exception Dump ---
Caught Exception: [Microsoft.Dynamics.Integration.Service.Tasks.IncompleteResultException] Reader returned fewer objects for processing (0) than expected (5).
Stack trace:
at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.ProcessRecordsImplementation(OperationType operationType)
User: GS\GenAccount
Machine: SQL2008
I found this below log too. I'm not sure if this matches the time of any issues the user had but I've seen this log several times in the log.
System.ArgumentNullException: Value cannot be null.
Parameter name: fileOrServerOrConnection
at System.Data.Linq.DataContext..ctor(String fileOrServerOrConnection, MappingSource mapping)
at Microsoft.Dynamics.Performance.Reporting.Security.SecurityAccess.GetDataContext()
at Microsoft.Dynamics.Performance.Reporting.Security.SecurityAccess.GetPrincipal(String securityIdentifier)
at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.SecureExecuteInternal[TResult](Func`1 hasPermission, Func`1 executor)
at Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceBase.BaseExecute[TResult](Func`1 executor)
Component: Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.CompanyService
User: GIRLSCOUTS\dbuser
Any help is appreciated. I suspect I may be moving in the right directly since the user says the issue has improved since I made the above changes. I'm wondering if there is anything else I can do to improve performance.
Thank you
*This post is locked for comments
I have the same question (0)
Share
Report
All responses (
Answers (
