all groups > sql server reporting services > june 2005 >
You're in the

sql server reporting services

group:

Very Large PDF Report Problem


Very Large PDF Report Problem Chuck
6/17/2005 10:01:02 AM
sql server reporting services:
Hi,

We use subscription to generate more than 1500 PDF page reports. They were
fine for the past few days, but it starts failing to generate PDF report that
has 2000 pages every day. Does anybody know why? Does it reach max PDF size
or there is a rendering issue? Thanks.


Re: Very Large PDF Report Problem Wayne Snyder
6/19/2005 2:41:57 PM
Take a look at the log in the RS log subdirectory... Reporting services can
hit a memory limit which will prevent the PDF from rendering....(The log
would probably show an 'Out of Memory' Exception... While rendering to PDF,
run Taskmanager and watch the memory for the W3WP.EXE process... This is the
IIS process.... if the process disappears and re-appears, the report is
killing IIS and the log should show the reason... (We generally do not get
these messages for smaller reports like you are talking about however.)


--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

[quoted text, click to view]

Re: Very Large PDF Report Problem Chuck
6/20/2005 7:58:02 AM
Thanks for your reply.

I did see W3WP.EXE holding lots of memory in TaskManeger while it was trying
to generate a big PDF report with more than 2,000 pages, but it does NOT
release the memory if I killed the long-run process. Do you know what the
W3WP is doing for Reporting Services? How do I optimize the max memory limit
and prevent it from throwing OutOfMemory exeception?

I see an article as the link below from Microsoft. It said RS would still
throw OutOfMemory exeception for frequent big report generations.

http://support.microsoft.com/?kbid=840709

Thanks,

Charles

[quoted text, click to view]
AddThis Social Bookmark Button