Dump files(.phd) using cognos go-excel

I have this issue with my environment where a Go!Excel report used multiple times by users at the same time causes the gateway/dispatcher running this report to max out and eventually create .phd dump files. The portal is unsuable during the time of this dump file creation. I'm working with cognos on finding a solution.

Comments

  1. Santosh KanthetyFebruary 23, 2011 at 1:45 PM

    Finally got an answer from Cognos and I din't like but they say it's a restriction on the Excel API.

    "The design intent of the product is to allow users to consume BI content for use in briefing books, business reviews, presentations etc and not as a mass data dump into MS Excel, PPT or Word. This particular use case shows an attempted import of 6000-10000 rows x 130 to 200 columns of datarows of data which is too large (over 500,000 cells) and the product was generally not designed to handle that quantity of data import. We are often limited by the underlying MS Office API's and machine resources when performing an import which makes it difficult to provide an exact number of cells that we can viably import."

    ReplyDelete
  2. UnknownMarch 10, 2014 at 5:49 AM

    Hi Santosh,

    quick question : do you have an update regarding above issue ?

    I'm having the exact same behavior on a load balanced/failovered environment.

    Olivier

    ReplyDelete
    Replies
    1. Santosh KanthetyMarch 24, 2014 at 12:03 PM

      No we had to disable the report and I scheduled the report and saved it on a network share as excel output.

      Delete

Post a Comment

Popular posts from this blog

Query Cognos 8/10 Content Store

I came across these queries that can give you good insight on the data and maintenance of Content Store in Cognos 8/10. You can also leverage the CMTools utility that comes with cognos install. ..\Cognos\bin\utilities\cm\CMTools\CMTools.exe select count(*) as "total number of objects" from CMOBJECTS; select c.NAME as "class name", count(*) as "number of objects" from CMOBJECTS o, CMCLASSES cgroup by o.CLASSID, c.CLASSID, C.NAME having c.CLASSID=o.CLASSID order by c.NAME ; select c.NAME as "class name", count(*) as "number of secured objects" from CMOBJECTS o, CMCLASSES c, CMPOLICIES pwhere o.CMID=p.CMID and p.POLICIES is not null group by o.CLASSID, c.CLASSID, C.NAME having c.CLASSID=o.CLASSID order by c.NAME ; select count(*) as "Total number of outputs", SUM(cast(coalesce(DATALENGTH(DATAPROP),0) as bigint)) as "Total size of outputs" from CMDATA where DATAPROP is not NULL; select
Read more

Cognos 8/10 CAMID-User ID/LDAP ID report

I came across this slick KB article on how to get the list of active sessions/users currently on any cognos environment and implemented it. https://www-304.ibm.com/support/docview.wss?uid=swg21385278 After I got this to work the servlet that runs only retrieves the CAMID and the session start time. I started looking around in the content store tables and was able to successfully  retrieve the CAMID and the associated  LDAP ID/User ID. I made this a query subject in the Audit model and joined it to the security groups table and created a report that will give me User ID, CAMID, AD Group, Name , Email. Query : SELECT  distinct ldap_id,     last_name,     first_name,     email,     objid as CAMID     FROM            (SELECT c33.cmid user_id, UPPER (c33.NAME) ldap_id,                   c1.surname last_name, c1.givenname first_name,                   c1.email email, c1.objid              FROM cmobjprops1 c1 LEFT OUTER JOIN cmobjprops33 c33                   ON c33.cmid = c1.cmid          
Read more

How about an Online help forum?

After i started blogging it came to my mind that initially when I was learning or exploring cognos/BI there was no place to go and ask people one on one and get the issue or question addressed. I know there are lot of forums where you can post questions, but the issue is some might be afraid to ask simple questions and some questions might not get answered right away or might even be lost. This gave me an idea for a simple forum where you can get online help from experts.The Professional Network.
Read more