Wednesday, May 18, 2005 1:18 PM
Crystal Reports .NET Error: "Load Report Failed"
Days like today make me glad I have a commute long enough to consume copious quantities of caffeine before I walk in the door at work. Today I was greeted with the news our reporting site was down. The error being thrown was “Load Report Failed” on any page that tried to access a Crystal Report.
There are a number of reasons you'll get this error, as a searching the Business Objects KB will show. The first most likely suspect was a permissions issue, since the application runs in the context of a network user, and the AD is being upgraded. Permissions in the report file were set to inherit from tha parent directory, the directory permissions were correct (adding the user explicitly had no effect either), and the user was still valid since I could log on to a workstation with that account.
The application worked fine in my dev environment, so I next checked that the DLLS were in the GAC, and they were. OK. Rebuild and XCopy the project to the server. Nope, that didn't work either. Now I'm grasphing at straws. Double-check that the correct report files are being called (they are read from a database based on user input), and they were. Last thing to try was manually recycling the IIS process. Bingo! The application now worked. Unfortunately, I have no solution yet, which I hate having to explain that I made the error go away but can't guarantee it won't happen again, so this will be kind of a developing issue.