Business Analyzer giving an error "Could not connect to configuration report" in GP2010 and GP2013.
It was working fine in GP10.
SSRS is working fine in GP2010 and GP2013.
Business Analyzer is working fine within GP2013 Home Page.
Did you try resetting business analyzer ?
Sanjay Kumar Rajarao. ACA, MCPhttp://www.sanjaykumar.us | firstname.lastname@example.org
Yes I did, even I re-installed but still the same error.
What part of the Business Analyzer is giving you this error? (Is this during the install or later?)
With the same machine and user, can you access the URL that is being used for the Business Analyzer?
Rob Bernhardt [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
It's giving the error every time I start Business Anaylzer. The installation is working fine without any problem.
Once I get the error I have just to click on "Yes". After that I'm getting another error "Error loading roles", I click on "Yes" then the system is working fine. I'm able to select and run the Reports as normal.
This is happening on the server and the client for GP2010 and GP2013.
I believe the Business Analyzer is looking for the configuration report. Please check the root of your report server path and see if it exists. Another thing you could do is check the report server log and see what is being requested when the Business Analyzer gives the error.
Could you please tell me the name of the configuration report. I have rsreportserver.config.
I checked the report server log file and found the following error:-
"library!ReportServer_0-18!440!11/03/2013-08:13:13:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item "/" is not allowed for this item type., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item "/" is not allowed for this item type.
library!ReportServer_0-18!440!11/03/2013-08:13:20:: Call to ListChildrenAction(/, False).
library!ReportServer_0-18!440!11/03/2013-08:13:20:: Call to ListChildrenAction(/, True).
library!ReportServer_0-18!440!11/03/2013-08:13:26:: i INFO: RenderForNewSession('/COIL/Sales/Charts And KPIs/Receivables Summary')
library!ReportServer_0-18!6bc!11/03/2013-08:13:26:: i INFO: RenderForNewSession('/COIL/Sales/Charts And KPIs/Receivables Summary')"
I would like again to mention that the reports are working fine winthin Business Analyzer after clicking Ok on the two error messages. They are also working winthin GP Home page and IE.
Thanks a lot.
I've seen Business Analyzer throw this error when the SRS connections are set to use SQL security, as opposed to Windows integrated security. Verify your report connections and switch them to use Windows Integrated Security.
MG.-Mariano Gomez, MIS, MVP, MCP, PMP IntellPartners, LLC Blog: http://dynamicsgpblogster.blogspot.com
The error messages are displayed even if there is not yet any selected reports.
I changed SQL security to windows for ReportServer database, I'm still getting the same errors.
As I said the reports are working fine after getting the errors.
It's simply named ConfigurationReport. It should be located at the root of your report server url. Another related question: Does your role dropdown fill and provide role selections in the configuration area?
The second message "error loading roles" is displayed. I'm unable to access the role field.
You can notice on the attached snapshot Connecting to Server, it does not change. This note does not happen on GP2013.
You mentioned that it's simply named Configuration Report, would you please give me the file name that the system is looking for?
The name of the report is "Configuration Report". It is deployed by Dynamics GP, and it provides a list of roles, role/report assignments, etc. You should find it at the root of your report server URL. If it's not there, that would explain the two error messages you mention.
I could not find this report file. I uninstalled Business Analyzer and GP 2010 on the server then reinstalled them. Still this file does not exist on the server.
Business Analyzer was not giving this error on the previous release!!
Is there a way to create it?
What version of GP 2010? In GP 2010 R2 and greater, this report is deployed from Dynamics GP. Earlier releases required the srs deployment wizard.
Tools > Setup > System > Reporting Tools Setup will deploy the reports.
This issue is happening on GP2010 R2 (SP3) and GP2013 SP2.
As I said the reports are deployed and working fine from IE , GP and Business Analyzer.
Business Analyzer is only giving these messages at the satrt-up or when going to change the selected reports.
Based on what you've described, I'm guessing it's an issue with the configuration report. "ConfigurationReport.rdl" should exist at the root of your report server url. It provides the roles, which you described as being unavailable. If re-deploying the reports doesn't fix the problem, I'd suggest talking to support to resolve your issue.