hi all,
we have a report in cognos 10.2.1 made on a relational data which runs fine in html, but throws an error while trying to export it to excel.
i tried checking tabular data for every query which is coming fine, so i am a bit lost as where to check for the issue.
i am attaching the error in a screenshot. request you to guide me to where to check for the issue.
thanks in advance.
Regards
Quote from: Raghuvir on 08 Jan 2015 07:41:04 AM
hi all,
we have a report in cognos 10.2.1 made on a relational data which runs fine in html, but throws an error while trying to export it to excel.
i tried checking tabular data for every query which is coming fine, so i am a bit lost as where to check for the issue.
i am attaching the error in a screenshot. request you to guide me to where to check for the issue.
thanks in advance.
Regards
The only salient clue I can see in that error message is that there was an issue with the report service. When rendering a report as HTML, only the first page is rendered, but when rendering as PDF or Excel, all pages are rendered. I'm assuming you currently have your Report Service configured as 32-bit (to support CQM) so this means it can only use up to 2Gb memory. If your output is huge and is causing the Report Service to crash (which is what I assume) then it's probably because this 2Gb threshold is being breached. As I see it, your options are either to simplify your report or else to switch your instance to use DQM exclusively and enable 64-bit Report Service processing.
My guess is you are probably trying to use Cognos as a data-dump utility to stuff data into Excel? If so, don't. :) Use an ETL tool instead (SSIS or similar) - Cognos is designed to be a reporting tool not a data dump utility, so massive rendered outputs can be problematic.
Cheers!
MF.
I have had issues running a report to Excel also, even though I can run it to html without a problem. My error is not exactly the same, so we may have different issues - but for what it's worth, I found success when I schedule my report output to both Excel 2007 and Excel 2007 data. If I schedule to only one or the other, it fails. I really only want the Excel 2007 version, but as a very temporary workaround it at least gets me my data in Excel. My report also takes some heavy processing and needs to be delivered in another tool as a permanent solution.