SSRS Report does NOT Build or RUN

Question

SSRS Report does NOT Build or RUN

y_shinde

SSC Enthusiast

Points: 103
More actions
March 9, 2018 at 12:05 am

#410304

Hi All,
I have created NEW SSRS report having code of 40000 lines. It is having 25 Line charts(and still needs to add 10+ charts).
When I try to Build or Run the report it fails.
Error During BUILD as follows -
***********************************************************************************
Failed to build item 'ReportName.rdl'.
Build complete -- 0 errors, 101 warnings
========== Build: 0 succeeded or up-to-date, 1 failed, 0 skipped ==========
***********************************************************************************
Error During RUN as follows -
When I remove few charts and then both (Build or Run) work.
RAM is 12 GB and only 4GB is occupied.
Anyone knows how to resolve this ?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99126 More actions · Answer 1

Are you trying to run the report, or preview it (you state "RUN", however, the dialogue says preview, which is confusing)? Generally, with SSRS, you use Preview on a report; you don't run a SSRS project. The Preview button can be seen next to the Design button at the top of the report:

(Image from SSDT 2012)

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

sgmunson SSC Guru Points: 110639 More actions · Answer 2

y_shinde - Friday, March 9, 2018 12:05 AM
Hi All,
I have created NEW SSRS report having code of 40000 lines. It is having 25 Line charts(and still needs to add 10+ charts).
When I try to Build or Run the report it fails.
Error During BUILD as follows -
***********************************************************************************
Failed to build item 'ReportName.rdl'.
Build complete -- 0 errors, 101 warnings
========== Build: 0 succeeded or up-to-date, 1 failed, 0 skipped ==========
***********************************************************************************
Error During RUN as follows -
When I remove few charts and then both (Build or Run) work.
RAM is 12 GB and only 4GB is occupied.
Anyone knows how to resolve this ?

I'm guessing you just don't have enough RAM. It's not as if 12 GB is very much. You probably need a good deal more than that. While consumers are typically getting 8 GB of RAM in commercially available machines, running SQL Server and/or Reporting Services should probably be considered a RAM hungry beast, and fed appropriately. Given your experience as stated, in that removing a few things allows it to work, I'd guess getting to 16 GB would be the minimum necessary to get by, if you're going to make your reports that complex. Ideally, 32 GB would be a huge improvement, and likely allay most capacity constraints for some time...

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)