Cognos 8.4 Chart Images Not Working (Red X)

[navissar]

2. How much space do you have on the Cognos hard drive?

[xplorerdev]

Hi Nimrod,

Sorry, forgot to answer your hard drive question.

There is ONLY one partition i.e. C drive.
> Total space shows as 126 GB in the operating system, so I guess the actual physical total size will be 140 GB.
> Free space is 35 GB.

Also, we have everything installed on this system i.e. Oracle, Cognos (Everything related to Cognos), IIS 7.0.


How to go about this space issue now ? What all can be deleted in Cognos i.e. there may be temp files or some other unnecessary files. Please let me know how can I clean Cognos?

We have informed the client oracle database team to clean the database and assign some free space.


Please suggest if you have some advice for the present situation.



Thanks n Regards
Dev

[Grim]

However, the DPR-ERR-2069 error while downloading excel is still there.

https://www-304.ibm.com/support/docview.wss?uid=swg21412276

[xplorerdev]

Thanks for the reply Grim,

I have already tried whats there in the above link. It did not help. In fact, I have tried all the IBM kb articles given for DPR ERR 2069. None of them helped.

One thing !! The DPR ERR 2069 error, while downloading reports into excel is ONLY coming for existing/old reports. If I now create a new report with chart/list/cross tab, I am able to download it into excel.

To summarize:
------------------
1) Excel download is working ONLY for newly created reports. Its not working for the old reports.

2) PDF download is not working for any reports, new or old. The download file is of 0 bytes.

3) For both, new and old reports, Chart shows Red X in Cognos viewer. But, downloading a Red X image of the chart in excel for new report displays the image. Its just not getting displayed in the Cognos viewer. However, by decreasing the size of the chart to a minimal size, the image gets displayed in Cognos viewer.

-> For New Reports: Blank chart of 219 px X 219 px is displaying. Any size greater than this is giving a Red X.

-> For Existing Reports: Anything greater that 100 px X 100 px is giving a Red X.



Thanks n Regards
Dev

[Grim]

Sounds like your report versions were deleted from the content store, yet the link to them remains.

[xplorerdev]

Hi All,

The issue remains a mystery !! Could not find the root cause.

Anyways. We restored our server back 2 months. Everything is working FINE now :) Charts, excel download, new reports, old reports. etc etc...ITS BACK TO NORMAL....

Thanks for all your support..Happy and sad..both...tk care guys..


***** CLOSING THIS THREAD NOW. *****


Regards
Dev

[Rahul Ganguli]

Hi All,

This may be too late, but I am curious to know the solution.
What steps were followed to resolve the issue?
Whether the issue got resolved from Scripts or it was a complete re-install?
What was the actual cause of the issue?

Regards,
Rahul

[xplorerdev]

Hi Rahul,

Even I myself have left Cognos behind now. But FYI, we got the issue resolved by patching the Cognos installation. Cognos 8.4 executable patches are available for download. The patch was of approx 300 MB.

Root cause still remains a mystery. I was the only person who was working on the charts when they stopped working and I was only creating a new chart.

Hope the information helps. :)

Thanks n Regards
Dev

[Grim]

Start here for your DPR error and open a new thread if you still can't find and answer.