Hi Rajesh,
This isn't specific to FixPack 5, it's long been an issue but we have a good dozen or two Events, Jobs and Reports fail every day with "java.lang.NullPointerException".
Our ticket is nearly 4 months old and IBM is still "working on it". They did log it as an APAR (software defect) but so far no answers.
Other failures we get:
CNC-SDS-0403 Unable to add history details in service [monitorService]
QE-DEF-0285 The logon failed.
CNC-ASV-0025 Agent Condition invalid: CNC-MON-0035 Invalid request.
Unavailable in a job step that is a legitimate job/report (one was every single step in the job)
Zombie processes that persist even after a reboot
Whether these are specifically due to FixPack 5 I can't say for certain, but IBM requires a separate ticket for each, so for now we're working on the java.lang.NullPointerException since it's the most frequent.
I mentioned we've been stuck on 11.1.5 IF1004 because starting with 11.1.6 and up until 11.1.7 FixPack 5, our schedules and events would stop running after about 8-12 hrs unless someone logged into the Cognos portal. It took IBM and year and a half to fix it - that fix being in FP5. Well, they never actually fixed the error but added code that looks for a failure and then does a retry - the retry keeps the schedule going but things can run 3, 6, 9, 12, etc minutes later than scheduled.
We had looked at 11.2.1 but the issue was there as well.
We may be forever on 11.1.5 until we are forced to scrap Cognos. All these fancy whistles and bells they're adding are no good if the core product doesn't work. And I've seen in the community we're not the only ones having these issues.
Regards,
Wayne
------------------------------
Wayne Westlake
------------------------------
Original Message:
Sent: Fri October 21, 2022 11:52 AM
From: Rajesh Kumar Vanam
Subject: Use SQL to Create Data Module
Hi Wayne,
Can you share the open issue you see on 11.1.7 FP5. We are planning for FP1-> FP5 upgrade want to make sure these wont impact our migration.
Rajesh
------------------------------
Rajesh Kumar Vanam
Original Message:
Sent: Tue October 18, 2022 12:20 PM
From: Wayne Westlake
Subject: Use SQL to Create Data Module
Hi Brian,
I'm curious why your company went with 11.0.13 and not the 11.1 or 11.2 branches.
While 11.2 is tagged as the "unstable, fast-changing" branch, 11.1.7 is tagged as the stable, long-term release for 11.1.x. "Stable" kind of being a misnomer as we've been stuck on 11.1.5 for 2 years now because of show-stopper (for us) bugs first in 11.1.6 and carried over into 11.1.7. Even on FixPack 5 I've had 1 support ticket open for over 2 months now and have 5 more tickets yet to open. Which is why we're not even considering the 11.2.x branch with it known as being even less stable.
Again, I'm just interested to know why you went 11.0.x
Regards,
Wayne
------------------------------
Wayne Westlake
Original Message:
Sent: Mon October 17, 2022 07:03 AM
From: Brian Hobbs
Subject: Use SQL to Create Data Module
We just got Cognos 11.0.13 and I am trying to make some data modules for the group to use. Is the drag n drop the only way to do this or is there a way to create it with SQL? We have 513 fields in a table and I just want a DM with about 30, so it appears I will need to click and delete 483 fields to do this. If not SQL is there another method? I will need to do something similar in other tables as well.
Brian
------------------------------
Brian Hobbs
------------------------------
#CognosAnalyticswithWatson