MinistryPlatform reports are delivered via SQL Server Reporting Services (SSRS). Each report is made up of three things:
- The .RDL file (the report) stored on the SSRS server.
- The metadata record in MinistryPlatform's Setup Area. This indicates the RDL file name, location and pages to which the report is deployed, and Security Roles authorized to run the report.
- One or more stored procedures in the MinistryPlatform database per data set needed in the report.
Report errors that are limited to a single report can result from many things including:
- Setup and Configuration issues
- Authentication issues
- Performance Issues
- Stored Procedure issues related to changes in underlying data objects
Here are a few things which can be tried when having trouble running a report:
- Clear your selections.
- Reboot your machine daily.
- Clear your cache before running any reports.
Note: Many reports require a date field. Ensure that the date and/or time is formatted appropriately and that the start date/time is before the end date/time.
The remainder of this KB article is primarily for the use of support personnel at ACS Technologies. It is shared publicly to help customers troubleshoot their own reporting issues.
When a customer reports an error running all reports.
Ensure that the Web Server has permissions to the ReportServer Database.
When a customer reports an error running a report, that error may or may not be descriptive. Initial troubleshooting should determine that the error is specific to one report. ACS Technologies will only troubleshoot reports that were created by our personnel.
Customer should send a screen shot which illustrates the parameters they passed to the report (if that was possible) as well as the error message they saw on their screen. ACS Technologies or a member of the customer's support team may follow the steps below to troubleshoot a specific report issue.
Run the report from MinistryPlatform Demo to ensure the issue is isolated to a single customer.
Run the report from the customer's system using your browser and the same parameters as the customer. Copy the URL to your clipboard. The URL contains the following:
- The exact name of the RDL file (can be different from the report name in MP).
- The parameters passed to the RDL file.
Work through the following questions while logged onto the report server from its internal web address on the SSRS server.
- Does the RDL file exist on customer's server?
- Is the RDL file connected to DataSources/Datasource01?
- Can you run the RDL file from the report server with the parameters you copied when running it from MP? You may have to go to "manage" the report then find and add parameters.
- What error do you get? If it is an error with a data set, then the problem may be with a stored procedure or underlying database objects. The error visible on screen when on the reporting server's internal address is likely to be more descriptive than the original error.
Working through data set issues from customer's SQL Server:
- What SP does the data set call upon? If unsure/unclear, download the RDL file from the report server and do a search for that data set name in the RDL file opened in notepad.
- Go to the MinistryPlatform database and confirm the SP exists and look at properties of the SP to be sure MPReports has rights to execute it.
- Attempt to manually run the SP. You will need the parameters copied from the URL and you may need to pass some additional parameters. You'd likely get the real error at this point.
Correcting the issue with the SP will generally resolve the issue. Once this is done, go back to the report server and attempt to run the report from SSRS (not MP) and see if the error resolves. If it does, go back to the report run from MP and make sure it can be run from there as well.
At any point during this process when you have a real, actionable error message you may submit this error to the report authoring personnel at ACS Technologies to assist with a final resolution.
