Issues after upgrading from Cognos 8.3 to 8.4

This is my experience on upgrading a windows environment from cognos 8.3 to cognos 8.4. I din't use Upgrade Manger or other tools available from cognos to see how the reports or packages behave after the upgrade as i did the full content store export and import due to lack of resources and considering that 8.3 and 8.4 are not very different. I did this on a sandbox first where all developers tested reports and confirmed they saw no difference.
After the upgrade there were issues with the way jobs were running as most of them were failing with socket/pogo errors and the ones that ran fine were sending emails from a different email than whats configured under notification. The fix was available on one of the forums where we edit a file and that fixed it.
This was a distributed install with individual cognos components on each machine, after the upgrade over the weekend it ran fine and then on monday it suddenly crashed and nothing worked so i had to install a stand alone install on one of the boxes and reroute IIS from the gateway.
Later I started installing the components(CM+APP+IIS) on all the boxes and integrated all the machines as a single distributed environment by selective disabling of components/services.
Environment was up and running but a wiered issue came up where people above Authour security level can open and do analysis on Analysis Studio reports where as AS users can open the report fine in the studio but cannot see the blue  member icons beside the levels in the dimension and they were getting timeout errors after a while. Cognos had no clue on this issue so no luck there, but in the mean while i found a workaround by adding Analysis Users to Authours and denying report Studio from capabilities that way they still can access AS without an issue and they are restricted on RS access.
Over the course of time there was a patch from cognos admitting it as a bug specific to customers who carryover CS from 8.3 to 8.4
Here is the list of patches that I have been putting on since then:
Aggregation Issue:


PK94433
multi-fact query with both conformed and non-conformed dimension includes keys from all levels of conformed dimension
** requires Fix_CQ206368 transformation listed below
PM04267
Incorrect aggregation on rollup summary values for a calculation
** requires PushFooterRollupsDown transformation listed below


Analysis Studio Issue:


PM03241
Analysis Studio not showing members in tree for users


POGO Errors:
Socket Errors:
Jobs Logging Issue:


PK99429
No entries are being written to COGIPF_RUNJOB tab when scheduling a Job; you do get entries in the cogipf_runjobstep table.


Parameterized URL Issue:


PM04991
Slow processing and JAVA coring (sometimes heaping) intermittently in 8.4FP1 with Series7 Namespace
PM15324
Cognos 8 does not read parameterized URL properly

Comments

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_...
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