While researching an issue we were having, I really started studying the COGIPF_RUNREPORT table and found the COGIPF_LOCALTIMESTAMP column has the start time of the report while the report is running and the end time once the report completes. Note the COGIPF_RUNTIME will be 0 while the report is running. Thus I’ve [...]
LAE Import Failed – Locked out of Access Manager
I received an error while importing an LAE file to access manager and I was completely locked out. I had created a LAE file from production and was moving it to development. Before I imported anything into development, I did export the [...]
Cognos Model Issues
We’ve had a few problems with our scheduled cube builds. The process will begin to create the cubes and will hang until I manually go in and stop the scheduled task. Then I have to end the transformer.exe process in task manager. The funny thing is that when I go [...]
I got this in my email today – kind of good to get another person's perspective on Cognos performance. I'll write up my notes and publish what I learn.
I would like to bring ******* in to take a look at the Cognos environment and get his thoughts how to improve performance. He will be [...]
When accessing Framework Manager today, in our development environment, we were getting an error when trying to open an existing project or create a new one:
BME-EX-0047 Unable to read preferences for the requested interface..: “BME-EX-0047 Unable to read preferences for the requested interface. Please use another repository and/or ProjectAccess Interface.”
I found the knowledge base article [...]
My cube builds tonight hit an error and wouldn’t failed when trying to be built. I opened up the model in transformer and went to manually build the cubes. About 30 seconds into it, I got an error about 2nd item number is supposed to be unique and an item number already existed.
The [...]
I had an issue yesterday where a report ran fine. A new package wasthen published and the report stopped working. When I published thepackage, the model versioning option was set to save two copies of themodel. Since the model broke the reports, I then rolled back thechanges. When the user ran [...]
Creating a RSS Channel to Inform Users When Cubes are Refreshed: Supportlink: “Creating a RSS Channel to Inform Users When Cubes are Refreshed”
I had to publish cubes this weekend, for the first time in our Cognos 8 environment. Here’s what I had to learn on the fly.
The path of a published cube is per server, not based on the dispatcher.
Data sources for cubes are referenced in the IQD files (which stands for Impromptu Query Definition), and [...]
Cognos 8 Performance Tuning
Cognos 8 Services Level:
Adjusting for peak vs. off-peak usage may benefit from changing the properties for:
• ReportService – used for interactive usage (user driven, on-demand)
• [...]