Have an issue with scheduled reporting and wanted to see if others have seen the same.
We are using Service Manager 9.40. Our database is Oracle, with a primary instance for production and a replicated and synchronized database for Service Manager reporting. We have the appropriate entry in the sm.ini file for the replicated database parameter. We also have checked off the boxes for "Use Production Database when Replicated Database is disabled" and "Use Replicated Database by default when users create report" under Reporting > Administration.
We are using the built-in reporting tool to create a schedule and send reports via email in a PDF format to various recipients.
This has been very successful for us until this past weekend when UNIX work was performed which took the replicated database off line for a time. The DBAs and the logs confirm that it's back on-line and is functioning. But the reporting just hasn't been the same since.
As an example, one scheduled report that is sent out as a PDF is of a dashboard which includes two line charts, two bar charts, and one pivot table. The table supporting all this is the interaction table.
When we receive the email and open the PDF file, we see a report header and the title of each individual chart, but no chart is rendered by the report writer.
Now, if I were to go to SM via the web client, pull up that dashboard, export it to a PDF, and open it up there, it appears fine.
As a test, I removed all the reports from the dashboard, added one, generated the email, removed it, added a different one, generated an email, etc., just to see if any one report from that dashboard was causing an issue. What was curious was that of all the reports, only the pivot table would render correctly within the PDF file that was included in the email that was sent.
Just for grins, I changed one of the reports from Chart to List, generated the email, and checked the PDF. It rendered perfectly. I changed it back to Chart and the issue returned.
Again, all was fine until the maintenance work this past weekend. And this matter is affecting various scheduled reports that were previously working without issue.
Why would our charts not render correctly in the PDF files? Was it something do to with the reporting instance not being available? Is there some step that we needed to do during this database maintenance to ensure that it would be used correctly for Service Manager reporting once it became available again even though we had the system configured to flip to the production database when the replicated database is unavailable?