load report failed error - with formatted crystal reports, iis6 and asp.net.net

Error: load report failed

This error troubled us a lot in reports deployment on 64bit server with IIS 6 and took at least 5 hours continuous focus to fix.

We tried to troubleshoot by giving all permissions to the iis user to application folder, application pool recycled, server reboot and even compared all deployment files in the problem environment with the one in application working environment. But we are failed to fix.

Still, with some hope in mind we tried executing other reports, then we found they are giving the error :_ Request timed out._

We fixed this by increasing the execution timeout. In web.config, please set the executionTimeout:

But then we found that these reports also giving the same error: load report failed.

Then finally, we tried assigning full rights to IIS user to following directories on portal server.

C:\WINDOWS\Temp

C:\Temp

It Worked!!

Originally posted on Things on Tech.