Payment report – loading…

Recently encountered a problem with the payment journal payment report. When the report was run the report loading screen would be displayed and nothing else would happen.

With some investigation it was evident that there was nothing wrong with the code or data. This had been concluded by checking SQL activity, for which there was none, and taking a copy of the system and running the report on the copy, for which it worked fine.

So the problem existed only in the production environment, which had more AOS’s and a multi-server installation, with reporting services being on a difference machine.

So why was the production payment report not working, when all other reports seem to be functioning correctly.

After reviewing all event logs, a log was found on the reporting server about an issue with the business connector.

As a result I completed a repair of the installation on the reporting server. This resolved the report issues.

While I have fixed the issue, this still leaves two questions:

  1. How did the installation get damaged?
  2. Why did it only seem to affect the one report?

The good news of course, is the report now works. If anyone has any insight into the open questions, that would be great.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s