Troubleshooting
Problem
Upload of a small 64kb excel file to Cognos Analytics takes longer than 2 minutes.
Cause
There are multiple potential reasons:
1. Network - A slow network can affect the transfer of the file data.
2. Disk - During the file import, the file import temporary data is placed on disk while performing scraping and analysis. If the disk is fragmented or slow (due to hardware or virus protection, or some other factors), or low on space, this can all contribute to the upload time.
3. Smarts analysis - The overall performance of the system can affect the smarts analysis process. A slow system will lead to a slower smarts analysis process.
Environment
Cognos Analytics 11.x.x
Resolving The Problem
Network: Improve the speed of the network
Disk: Ensure there is enough available disk space on the Content Manager server
Smarts Analysis: Improve the performance of the Cognos server.
Here are the specifications of a high performing Cognos server:
Windows Server 2019
Intel Xeon E5 (4 cores @ 2.3GHz)
64GB RAM
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl41AAC","label":"Administration->Performance"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
24 July 2020
UID
ibm16251985