Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS Reports IE8 ScriptResource.axd compression/decompression error

Following on from this question:

SSRS IE8 JavaScript Error Invalid Character ScriptResource.axd

This is an issue that I really need a resolution for. I have more information now regarding this and therefore have decided to log a new question.

I have a suite of SSRS reports located on a SQL Server running SQL Server 2008 R2. I have had no issue whatsoever accessing these reports using Internet Explorer for over 6 months.

Last week someone logged a helpdesk call stating that she could not see the reports as the page loads forever and a small icon with an explanation mark appears in the bottom left corner after a few seconds with the text 'Done' next to it.

As I was already aware that this issue was probably an IE problem, I advised the user to download Firefox and just use that instead. Upon doing this the user could see the reports.

The next day I went to access the reports as normal using IE, and the problem the user had encountered, was happening to me. I was stuck in an infinite loop with the small ‘Done’ with errors image in the corner. The error message upon clicking was:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; .NET4.0E)
Timestamp: Tue, 11 Sep 2012 09:58:13 UTC


Message: Invalid character
Line: 1
Char: 1
Code: 0
URI: http://xxxxx/xxxxxxx/ScriptResource.axd?d=iYyn-VGIBSAJxmoeImLsTtesAMP1500Akt1KNGOHN_b-PEkCEZq1v-qs_SbiV610TRrm-8ISgq4xWAV6lxRrv1NaHOGFuUUOfusDmQgdb8FPNvi0YU9Sc8hp24nzIzpdQXiEtHcT-lcQIUkU_kcJg-EM61o1&t=ffffffffb868b5f4


Message: Sys.ScriptLoadFailedException: The script '/Reports/ScriptResource.axd?d=iYyn-VGIBSAJxmoeImLsTtesAMP1500Akt1KNGOHN_b-PEkCEZq1v-qs_SbiV610TRrm-8ISgq4xWAV6lxRrv1NaHOGFuUUOfusDmQgdb8FPNvi0YU9Sc8hp24nzIzpdQXiEtHcT-lcQIUkU_kcJg-EM61o1&t=ffffffffb868b5f4' could not be loaded.
Line: 5
Char: 25340
Code: 0
URI: http://xxxxx/xxxxxxx/ScriptResource.axd?d=IcCsSJUAEsxazITdzqHjDt1BesfkTp6Mm3HS3LIMBVF2Lxr_e3gi3u2PvZQRuLbGfe0MhIoDqlxXvrXTRXhpV2wfNhWcJK0iLFPtfDZzuej4KzvCBV1ggWWCaLYj6iG0RpVkSYBY-IrbRMKNOCn9Qc8W77bR9CrIphFmFbR2zKerE3DA0&t=ffffffffb868b5f4

I checked the IE version number that I was using was version 8.0.6001.18702. I tried getting a colleague to attempt to access the report who was also using version 8.0.6001.18702 IE, and hers went through no problems.

The thing I find strange about this is that for 6 months plus I have no issues, then all of a sudden I cannot use IE to access the reports, and you can’t even say it’s an internet explorer version issue because as I said, my colleague is using the same version as me.

As it works using Firefox it still points towards an IE issue however possibly something Server side?

Can anyone suggest anything here as if it’s a problem for me, this could become a problem for many users over night.

See attached screen shot with what I see when I try to access the report:

enter image description here

UPDATE: Research suggests this should fix, have done this and monitored using fiddler however it is still using GZIP compression, and not working for me.

<system.web.extensions>
    <scripting>
      <scriptResourceHandler enableCompression="false" enableCaching="true"/>
    </scripting>
  </system.web.extensions>  
like image 270
JsonStatham Avatar asked Sep 11 '12 10:09

JsonStatham


1 Answers

As crazy as this sounds, the solution to my problem was simple.

Go to Control Panel > Internet Options > Advanced

Turn off HTTP 1.1 Settings and then back on again.

The SSRS Reports now render correctly, however my version of ie8 still does not want to support gzip encoding wheras my collegues does.

UPDATE After 10 minutes - 30 minutes the error comes back however, I have now turned off HTTP 1.1 all together and although not ideal, I can view the reports.

like image 178
JsonStatham Avatar answered Nov 06 '22 11:11

JsonStatham