.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSRS 2008 log file - maximum memory limit

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :Sql Server


In my SSRS 2008 log file, in few starting lines I see these lines;

INFO: Reporting Services starting SKU: Enterprise
resourceutilities!ReportServer_0-3!1874!10/05/2010-13:32:29:: i INFO: Maximum memory limit is 2097152Mb

What does it mean by maximum memory  limit is 2097152Mb?

I have set the maximum memory limit for SSRS to 5 GB.



View Complete Post

More Related Resource Links

The file reached the maximum download limit. Check that the full text of the document can be meaning



I'm facing an issue with the indexing.

I have 1 WFE+Index server+DB server.

Index server is not installed with MS FIlter pack 1.0

When crawling, the there will be document with warning in crawl log:
The file reached the maximum download limit. Check that the full text of the document can be meaningfully crawled.

Documents that with warning are such as doc, ppt, xls, docs, ppts and many others.
However, I view into the successful crawled document, there are doucments with ext doc and ppt.

For large file index, there are MaxGrowthFactor + MaxDownLoadSize required to be added into the index server.

As my understanding is, MS Filter Pack should installed into index server(already did, correct me if i'm wrong).

I looked into the Office SharePoint Seach(CA>Services in farm), if the server is appointed to "Use this server as indexing server", then MS Filter Pack is suppose to be installed into that particular server as well.

At the bottom, there also has another option is "Use all web front end for crawling".

The question here is, IF the option "Use all web front end for crawling" is selected.
Does the WED FRONT END Server required to installed the Ms Filte

How do you freeze the tablix header row in an Excel export file in SSRS 2008?

So this is totally killing me. I've found out how to make a tablix header row repeat on each page of a PDF export file in SSRS 2008 (which I won't even get started on because all I can say is that 2005 is way better), but I cannot figure out how to make a simple header row of a tablix freeze in an Excel export file.  The tablix is right at the top of the body and spans the entire width of the design area.  How in the world do you get it to freeze in the Excel export file?

Need to find File Share Excel Rendering time--SSRS 2008

we are using SSRS 2008 file share subscription to generate EXCEL reports,Requirement here is need to find the file rendering/completion time in order to send the excel file as attachement using xp_senddbmail. Your help is highly appreciated-- Sathish

Doubt on WorkingSetMinimum setting in SSRS 2008 configuration file


Hello All,

I have been reading about memory settings for SSRS 2008 for better performance in this link.                                                          http://msdn.microsoft.com/en-us/library/ms159206.aspx  WorkingSetMinimum definition here says that "Specifies a lower limit for resource consumption; the report server will not release memory if overall memory use is below this limit."

Now, I have set the WorkingSetMinimum value as 2.4GB and when I am executing a report with 300K records, I observed in Perfmon that it has consumed around 1GB of available memory during report run time but the report server has not acquired the designated memory of 2.4GB in WorkingSetMinimum as I can see more memory as available MB than the value supposed to be after dedicating minimum memory of 2.4 GB to report server.

  1. My first question, has report server not acquired the minimum memory configured in WorkingSetMinimum because it didn't required that much memory to construct the report? &nb

SSRS 2008 R2 After using SSL, In Report Manager new datasource link, upload file link, subscription



I have provided my setting and environment information below. My goal is to set Report Manager and Report Server URL with SSL connection so all URLs uses HTTPS (Secure connection) all the time. and remove HTTP access .

I applied following settings for this but I am getting errors. With Current Settings that I mensioned below, I am able to login into WebService URL successfully with all links working. For Report Manager URL  I logged in successfully but for some pages I am getting HTTP links instead HTTPS. It shows HTTP links for new datasource link, upload file link, subscription links so it shows blank page

I tried to look for solution and I applied but did not worked. I did some experiment with changing urls using application and manually from RSReportServer.config file but still not succedded.

Steps taken to solve problem:

  • To force to use HTTPS only, I tried to change SecureConnectionLevel = 0 to  1,2 or 3 but when accessing to Report Manager it gives 401 Authentication error.
  • If I remove http://+:80/ReportServer and tried to visit 2nd URL with HTTPS. The Web Service URL opens successfully. but Report Manager url gives me er

When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1

When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1,Sheet 2,Sheet 3) dynamically.So Please try to give me a solution.

When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1



When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1,Sheet 2,Sheet 3) dyanamically.Sp Please try to give me a solution.

How to check for file exists on remote server in ssrs 2008?

I have a report that needs to display images that are stored on a remote web server. The problem is that I also need to check if the file exists first otherwise I get those annoying image not found red X's.

I tried entering the code at the bottom in the custom code section of the report which works if I run it on my local machine however it doesn't work in SSRS 2008. After doing a little trial and error I found it seems to be failing on the first line in the function,

Dim request = System.Net.WebRequest.Create(New Uri (fileURL))

Is there some specific permissions or configuration change needed on the SSRS2008 server for this code to work? Or is there a better way to do this?


Public Function CheckRemoteURL(ByVal fileURL As String) As String
Dim request = System.Net.WebRequest.Create(New Uri (fileURL))
request.Method = "HEAD"

Dim returnURL = ""

Dim response = request.GetResponse()
returnURL = fileURL
Catch ex As Exception
returnURL =""
End Try

Return returnURL
End Function

Sharepoint & SSRS 2008 "System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft


my environment as below:

1- SERVER A (SQL server DB 2008 sp1)
2- Server A (SSRS 2008 sp)
3- SERVER B MOSS 2007 sp1
I configured the SSRS to be sharepoint intergated mode but when i  hit the Web Service URL i got the error below:

Reporting Services Error

  • The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded. The error was: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.SharePoint, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper..ctor() at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelperFactory.get_ServiceHelper() WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. . (rsSharePointObjectModelNotInstalled)

    Unable to upload report file to SSRS 2008 R2 Express

    I'm attempting to upload a report file into an instance of SQL Server 2008 R2 Reporting Services (Express edition), and I'm having difficulty. While I can do things like create folders and manage security, I am unable to upload a report definition (.rdl) file from either the web console or via the ReportService2005.asmx web service. Both avenues eventually time out and generate a 401 error (though I am not sure that this 401 is legitimate, as it takes over a minute and a half to generate the error).

    This instance is running the web services on a non-standard port (8080) in HTTP (not HTTPS) mode, as it's on a Windows XP Pro machine with an existing website on IIS.

    I have looked at the report server access log, and this appears to happen when it errors out:

        rshost!rshost!380!10/13/2010-14:39:10:: e ERROR: ReadCallback(): failed to read in read callback.
        rshost!rshost!380!10/13/2010-14:39:10:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x016F8D48.
        rshost!rshost!244!10/13/2010-14:39:10:: e ERROR: HttpPipelineCallback::ReadEntityBody(): failed reading data.
        rshost!rshost!244!10/13/2010-14:39:10:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x016F8D48.

SSRS 2008 Change configuration file


Hi All,

We are having rdl files which were created on BIDS 2005 and delpoyed to SSRS 2005 now we have upgrade our Report Manager from 2005 and 2008, most of the report sends email subscriptions to our end-users with an attachment file to export version as "EXCEL".

Everything was working fine and perfectly as expected with SSRS 2005, but after our upgrade to 2008 we are receiving error as below under EXCEL Files:-


into the cell(s) of the Excel spreadsheet.

To resolve this issue we change on the format code of text boxes under our rdl files from "#0" to "N0", and everthing was resolved successfully with the export version of the EXCEL.


So my question is, we have more than 1000 of rdl files which sends an email subscriptions to our end-users so is their any way were we can change above mentioned format code to Reporting Services Configuration file instead of changing all the rdl files individually.

One change at the Configuration is much better than changing 1000 of rdl files!!! Isn't it?


Please help me out?




Importing a query from an .mdx file - Support (SSRS 2008)


I'm writing an MDX query which would be used as the main dataset. The issue that I'm facing is that the query is really big because of it's nature of members and requirement and Reporting Services doesn't support the number of characters that I'm using. So I saw this Import button and imported the MDX query. However I don't get the list of members in the fileds section which I can use in the Report Textbox. I was reading http://msdn.microsoft.com/en-us/library/dd239327.aspx and it says that "Importing a query from an .mdx file is not supported"....

My question is would it every be supported? Is there a workaround for what I'm trying above? I would appreicate any help on the same.

Thank you!

file upload in chunks or not buffering in memory before writing to disk?


What are the options for handling file uploads to reduce the memory footprint?  Is there a way to upload in chunks?  Is there a way to stream upload directly to disk instead of loading entire file in server memory?


Visual Studio 2008 Memory problems


My memory in task manager reaches about 900,000K  and I don't know why it does this. Definately slows everything down, especially when I rebuild my tableAdapters, takes about 30 seconds sometimes to rebuild the project.

Maximum memory for string ? . System.MemoryOutOfException Occurs when reading the Content of the fil



I have a C++ code which reads a file [vtk file - its similar to text file only]. and try to store it in string.

here's the code:

String^ ParallelProjectionRenderer::GetVolumeDataAsString(String^ FileName)

    vtkSmartPointer<vtkDataSetWriter> sWriter = vtkSmartPointer<vtkDataSetWriter>::New();

    String^ FileName = "D:\\Users\\...";

    char * sptName = static_cast<char *>(Marshal::StringToHGlobalAnsi(FileName).ToPointer());







    String^ result= File::ReadAllText(FileName);   [it breaks here with system.memoryoutofexception when the file size is huge]

    return result;


this code executes fine when the file size is less than 8mb.

I wanted to know whats the maximum memory allocated to the string.

As a workaround i skipped reading out in C++ code. and i tried to read the file contents in asp.net C# code and stor

FLV file in Visual Web Developer Express 2008


I'm trying to embed a flv in my web page and I don't have a clue how to do it.

I downloded and installed ASPNetFlashVideo and the tools do not appear in my toolbox.

So if anyone has a work around it would be greatly appreciated.

SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend