Migrating to SAP BI4 4.2 SP5 or Crystal Server 2016 SP5? STOP! UPDATE.

It looks like there’s a definite problem.I’ve had an odd reply from SAP that talks about moving files from DEV to TEST to Production – presumably they’re talking about Promotion Management rather than Upgrade Management. After migrating, every recurring Crystal Report schedule will fail with the following error: File ~xyz123.wid not found on the File Repository Server. These… Read More »

Intel’s Meltdown and database performance

Unless you’ve been on an extended Christmas break with no TV or Internet, you’ll have heard of Intel’s recent troubles. While it’s true that most computers will not be noticeably affected, servers that read and write large amounts of data to disk will be impacted. In my world, that affects two things – databases and reports. Large queries… Read More »

Still have a single CPU licence for reports?

This is the first in a series of posts about licence compliance. It’s always difficult to get independent advice on licensing, so I’m attempting to highlight some potential pitfalls. Given the complexities and potential liabilities, you should always refer to your own licences. I’ve been trying to source some useful guidelines from SAP without success. First of all,… Read More »

Report performance tuning

Customer: Aviation Software House Our customer had an important report that was taking over 10 minutes to run for just a month’s worth of data. New requirements mean that the report needed to be run for a year’s worth of data. Obviously a problem! As is so often the case, the main performance problem was due to subreports.… Read More »