- Customization file export, import and publish
- System Jobs were running
- I was able to make entity changes and publish
- Created and saved new records
- Able to run workflows
Features not Working
- Knowledge Base full text search was not working
The was no event viewer error recorded for the Knowledge Base issue, just the friendly, ‘an error has occurred, see your system admin….’ error when I tried to search the Knowledge Base using full text search. All other search types worked fine (Subject, Article Number, etc.)
The report error did log an event and it was the one I don’t generally like to see: "Error: Client found response content type of ‘text/html; charset=utf-8’, but expected ‘text/xml’". When I see that error, I usually know there are issues related to folders, files, datasource used for the report or paths.
Fortunately, I was able to resolve the KB full search issue by following the instructions in this KB Article. The KB issue was fairly easy to address by starting the service, adding the user to the Group as explained and rebuilding the catalog. After I completed those steps, I was able to use the KB full text search.
The Report Server issue was a bit trickier. I followed the instruction in the KB Article above but that did not correct the issue for me so I did some additional research and found this great article with a significant amount of information for Troubleshooting Dynamics CRM reports. I previously tried installing the SRSS Data Connector but that didn’t fix the issue so I uninstalled it and configured the datasource to use Microsoft SQL Server rather than the connection type of Microsoft CRM Data Extension.
The next thing I tried was disabling the organization in the Deployment Manager because I noticed that the Report Server URL did not have the port number in the string (not sure how that happened). I disabled the Organization and edited the string for the report server to include the port number then selected the Next button. When I finished the wizard, CRM worked through the update process and in the end returned an error:
Event Type: Error
Event Source: MSCRMReporting
Event Category: None
Event ID: 19969
Time: 10:46:48 AM
Web service request SetItemDataSources to Report Server http://CRMSQLServerName:5555/reportserver/ReportService2005.asmx failed with SoapException. Error: The data source ‘MS Sql’ cannot be found.
I ignored the error above and enabled the Organization. As expected, the Reports still did not work, but there was a new Report Folder on the Report Server with the new set of reports created as a result of updating the URL string for the report server. My hope was that this change corrected any issues related to the previous report folder so I installed the SRSS Connector and did an iisreset and that fixed the issue.
I hope this information proves useful for someone. Correcting the reporting issue was challenging but I learned a lot through the process and found some really great online articles with a wealth of troubleshooting information.