List of Contributions

Adam McIlravey

Contact Details

My Content

1 to 20 of 50+ total

RE: Post CA 12.0.1 Upgrade Testing

Posted By Adam McIlravey Fri March 01, 2024 08:44 AM
Found In Egroup: Cognos Analytics \ view thread
Patrick... Thanks, this was indeed the issue! ------------------------------ Adam McIlravey ------------------------------

Post CA 12.0.1 Upgrade Testing

Posted By Adam McIlravey Thu February 29, 2024 09:30 AM
Found In Egroup: Cognos Analytics \ view thread
We have just upgraded our lower environment to CA 12.0.1, one of the things I am noticing is that I am not seeing either "Event Agent" or "Other Applications" under the +New/Other prompt - Only Job is showing. The Data, Explore, and Present options seem correct. My permissions appear to be correct ...

Actions Menu following CA 12.0.1 Upgrade

Posted By Adam McIlravey Tue February 13, 2024 01:06 PM
Found In Egroup: Cognos Analytics \ view thread
We have just upgraded one of lower environments to CA 12.0.1 and are beginning to test. The first problem/issue that we are noticing is that upon signing on the first time you can click on the on Actions Menu next to a report and go in and edit as needed. However, when trying to edit a second time ...

RE: Save to file system suddenly failing

Posted By Adam McIlravey Tue January 16, 2024 05:33 PM
Found In Egroup: Cognos Analytics \ view thread
Thanks for everyone's help and suggestions. This was resolved with the help of IBM. There is a known bug in CA 11.1.7 (resolved in one fix pack ahead of us - FP7) where saving to the file system fails after so many files due to a higher Windows Version on the file share (Windows 19 - just upgraded ...

RE: Save to file system suddenly failing

Posted By Adam McIlravey Tue January 16, 2024 08:50 AM
Found In Egroup: Cognos Analytics \ view thread
It seems that all save to file system reports are now failing again with the same messages. CNC-DS-0026 Error while processing the report outputs : CNC-DS-0022 Cannot retrieve the canonical path for '\\ \ \ \ \ \ \<Report Name-en-us' RSV-DST-0014 Unable to deliver the output of the report. See ...

RE: Save to file system suddenly failing

Posted By Adam McIlravey Mon January 15, 2024 02:28 PM
Found In Egroup: Cognos Analytics \ view thread
Functionality to save to file system must take a while after Cognos restart to become fully active. We can now run some reports as needed. However, and I don't know why, some bursted reports with long file names are still failing. The long file names are created by the burst criteria . ...

Save to file system suddenly failing

Posted By Adam McIlravey Mon January 15, 2024 01:25 PM
Found In Egroup: Cognos Analytics \ view thread
All of a sudden all our reports (bursted & non-bursted) are not saving to the file system. We are getting the following messages: CNC-DS-0026 Error while processing the report outputs : CNC-DS-0022 Cannot retrieve the canonical path for '\\ \ \ \ \ \ \<Report Name-en-us' RSV-DST-0014 Unable to ...

RE: Top X for Stacked Bar/Column Chart

Posted By Adam McIlravey Wed November 15, 2023 08:43 AM
Found In Egroup: Cognos Analytics \ view thread
This is now resolved Thank you for the further help. Thanks also to @HENK CAZEMIER for taking the time to have a one-on-one with me to work thru the problem yesterday afternoon. This really was a "moment" on my end - What I missed was imputing in the "By" Field when setting the Top X filter ...

RE: Top X for Stacked Bar/Column Chart

Posted By Adam McIlravey Tue November 14, 2023 09:40 AM
Found In Egroup: Cognos Analytics \ view thread
Henk... Thanks for the suggestion I have previously tried this (putting a Top X filter on Practice Name - Bars) and it appears to do nothing. Or it is potentially taking way too long to do anything to the point where use in a dashboard would be meaningless. Another indication that it is doing ...

Top X for Stacked Bar/Column Chart

Posted By Adam McIlravey Mon November 13, 2023 01:34 PM
Found In Egroup: Cognos Analytics \ view thread
CA 11.1.7 In a Dashboard or Exploration, I have a Stacked Bar chart defined as follows: Bars - Practices Colors - Service Types Length - Amount The list contains far too many practices to be useful, so I want to reduce to a Top 10/20 etc. What I want to get is the Top X Practices ...

Report with "Manage External Data" Package Failing Intermittently

Posted By Adam McIlravey Tue July 11, 2023 12:06 PM
Found In Egroup: Cognos Analytics \ view thread
CA 11.1.7 FP4 We have a new report that contains a package created using the "Manage External Data" option. When it does fail, it is failing intermittently with the same error every time: CCL-BIT-0005 A socket reported a communication error. CAM_Send=0x82000098 -2113929064 CAM-CRP-0321 ...

RE: Export all Report XMLs - CA 11.1.7

Posted By Adam McIlravey Fri May 26, 2023 08:59 AM
Found In Egroup: Cognos Analytics \ view thread
We ended up solving this in the following manner: Create a Content Store export of the specific folders containing the reports we needed. Extract the Package.xml file from within the export.zip file that was created on the Content Manager server. Using a C# script, parse the package.xml ...

RE: Burst Report Runs then Fails on Subsequent Run w/ UDA-SQL-0107 and ORA-12801 Message

Posted By Adam McIlravey Wed May 24, 2023 04:44 PM
Found In Egroup: Cognos Analytics \ view thread
Thanks for the feedback Paul... We were able to finally resolve the issue and have come to the conclusion that this was likely Cognos caching rather than Oracle caching. Both the Report Query and Burst Query originated as User Defined SQL, but then contained Oracle functions within some of the ...

Burst Report Runs then Fails on Subsequent Run w/ UDA-SQL-0107 and ORA-12801 Message

Posted By Adam McIlravey Tue May 23, 2023 03:10 PM
Found In Egroup: Cognos Analytics \ view thread
CA 11.1.7 - Oracle We are experiencing an issue where a burst report runs successfully the first time, but then all subsequent runs fail (for some period of time). If we then go in and change the report query by adding a "garbage" not in condition (such that the explain plan is changed), the report ...

Export all Report XMLs - CA 11.1.7

Posted By Adam McIlravey Thu May 18, 2023 02:39 PM
Found In Egroup: Cognos Analytics \ view thread
I am looking to export all our report XML's from the Content Store and store in BitBucket so we can create a new repository of all our reports. This should enable us to have version control and a standard location for all our developers to pull the latest version of the report. We have an Oracle ...

RE: CA 11.1.7 - Log4j Addressed Release/Version

Posted By Adam McIlravey Fri May 05, 2023 08:41 AM
Found In Egroup: Cognos Analytics \ view thread
In lieu of performing an upgrade, I found the below on IBM Support - Is this still a way to become fully Log4j compliant? Link is: https://www.ibm.com/support/pages/node/6534624?mhsrc=ibmsearch_a&mhq=Cognos%20Analytics%20vulnerability%20%26lpar%3BCVE-2021-44228%26rpar%3B%20 Thanks again, Adam ...

CA 11.1.7 - Log4j Addressed Release/Version

Posted By Adam McIlravey Thu May 04, 2023 01:29 PM
Found In Egroup: Cognos Analytics \ view thread
We are on version=11.1.7-2112191704 and have been since around I believe December 2021/January 2022. I believe this is CA 11.1.7 FP4, but I am not 100% sure. At that time, we believed this version to be Log4j compliant, but our security team is suggesting a necessary upgrade to FP9. Obviously, ...

UDA-SQL-0219 The function "substr" is being used for local processing but is not available as a built-in function

Posted By Adam McIlravey Fri January 27, 2023 01:31 PM
Found In Egroup: Cognos Analytics \ view thread
I have modified a FM model and published a new package in our DEV environment. Subsequently, I have copied a report from Production (which runs without issue) down to the DEV environment. As a run a test of the report in DEV, it is failing with a "UDA-SQL-0219 The function "substr" is being used ...

CA 11.1.7 End of Support

Posted By Adam McIlravey Wed November 16, 2022 10:24 AM
Found In Egroup: Cognos Analytics \ view thread
Can someone please give me the official End of Support date for CA 11.1.7. I believe it is sometime in 2023, but I want to plan out our upgrades for the upcoming year. I know it is typically a 2 year + 1 year extension, but I am unsure of the official date. Thanks in advance, ------------- ...

RE: CA 11.1.7 - Options on Emailing Report run in background

Posted By Adam McIlravey Thu December 09, 2021 11:20 AM
Found In Egroup: Cognos Analytics \ view thread
Thank you Kizzy... We are going to see if we can go to FP4 at this time. Thanks again, Adam. ------------------------------ Adam McIlravey ------------------------------