Hello Jen -
I don't have any advice, only places for you to look for more information on why it's taking so long.
- Is this a new report that has never produced a PDF successfully, or a long-running report that is now taking much longer?
- How many pages are expected in the PDF? If 150,000 or more I wouldn't be surprised if it takes a long time.
- If you put a filter on the report to return, say, 1,000 rows, does that PDF get produced? How long does it take?
- If it doesn't complete, keep cutting down the number of rows until it does. That will give you a time benchmark.
- If you produce the report interactively in HTML and go to the bottom of the report, how long does that take?
- Have you had your DBA and Network Server Admin look at system performance/resources while the PDF is being generated?
- They should be looking for temp space utilization, CPU/MEMORY constraints, etc.
I think these investigations will turn up enough information to identify the cause and point to possible solutions.
Good luck,
Opher
------------------------------
Opher Banarie
------------------------------
Original Message:
Sent: Wed August 19, 2020 09:29 AM
From: Jenifer Broughton
Subject: C11.11 Export to PDF is running HOURS
All,
Does anyone have advice on speeding up a pdf report export?
Thanks,
Jen
------------------------------
Jenifer Broughton
------------------------------
#CognosAnalyticswithWatson