SSRS Interactive Sort fails in Production only
I have a curious case of interactive sort failing to work. I'm using straight forward sort expressions of the field values. All reports work properly in all environments except in production. Even more curious is that sorting responds once a long while. This happens in IE6/7/8 and Firefox. There are no javascript errors or security warnings. The problem persists without the load balancer. The report simply refreshes with the same content. When debugging with Fiddler, some of the HTTP requests that are supposed to retrieve html and images go to urs.microsoft.com. It could be that the browser does not recognize the domain name from local cache, but that's also not always the case. I'd be really appreciated if someone can share some insights. Thanks.
June 3rd, 2009 12:31am

Hi gw2a54, From your description, the issue is the interactive sort can work fine in all environments except in the production environment. The clients do not have any JavaScript errors or security warnings. The production server is deployed without the load balance, and some of the HTTP requests that are supposed to retrieve HTML and images go to urs.microsoft.com. If I have misunderstood, please do not hesitate to let me know. The SQL Server Reporting Service uses JavaScript to do a callback from the Report Server. While viewing the source of the report body, we can find JavaScript such as: onclick="ClientReport<GUID>.ActionHandler('Sort','14_D');return false;". The script will generate an URL with the action type. The Reporting Service uses the URL to call the web service rendering report. The operation is identical to Find, PageNavigate in the Report Viewer page. However, the Reporting Service uses the same way to render the report while loading. From your descriptions, we can determine that the report renders properly, so the URL with the server name is correct. The possible issue should be that the clientscript cant work properly in the client. Could you please help to collect the following information for future research? 1. Does the Find function work properly? We can also try other similar functions such as DrillThrough, Jump to URL, and Page Navigate and so on. Generally, if the Find function works, the Interactive Sort should work properly also. If the Interactive Sort doesnt work in this case, we could try to clear the DNS cache of the production server. Please use the command ipconfig /flushdns to flush the DNS cache. 2. Does the report work properly in other clients? If so, the issue should be that the client we used now has some JavaScript problems. 3. Do other reports work fine? If so, please post the report in this thread. 4. Please post the logs from Fiddler to help us do future research. 5. Please check if there is any other error in the SQL Server Reporting Services logs. We can get the logs from <Install Driver>:\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\LogFiles If there are any other questions, please feel free to ask. Best Regards, Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
June 5th, 2009 9:02am

Hi Jin, Thanks for your reply. Here are the responses for your questions: 1. "Sort" seems to be the only action that fails. Other JavaScript related functions such as "Find" and "Page Navigate" are working properly. DNS flush did not make any difference. 2. We tried IE6/7/8, Safari, Opera, and FireFox. All browsers yield the same issue. 3. We observe the same behavior in all reports on simple sort expressions like: "=Fields!UserType.Value" and "=Fields!RegionCode.Value". 4. Is there an email address that I can forward Fiddler logs to you? 5. There are no errors in the SSRS logs. The server receives the same request (i.e. SortAction(20, Ascending, True)) every time. The browser receives the same html every time as well. I appreciate any further insights that you may have. Thanks. Greg
June 12th, 2009 11:33pm

I am having the exact same problem on a dev server, the Model Office and Production SSRS servers work fine. I have the exact same results. When you click the double arrow, the screen clears and returns the same data as before, without sorting, and the double arrow does not change to a single arrow. Did you resolve this issue?
Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2011 3:02pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics