Troubleshooting
Problem
By default, Cognos Analytics allows external data files with up to 20,000 rows and a total file size of up to 2.5M, but some packages will not allow external data files with more than 1000 rows.
Cause
The limits on the rows and file size are controlled by two governors in Framework Manager, Maximum external data row count and Maximum external data file size (KB). If a package has been imported from an older release of Cognos that didn't have these governors the package it will limit external data to only 1000 rows.
Resolving The Problem
The issue can be corrected by opening the affected package in Framework Manager and updating the governor settings.
Step:
- Open the model for the package in Cognos 10 Framework Manager
- Update/confirm the governor settings are as desired. (Even you have don't need to change the settings in here, confirming them is required to update the package.
-Save the model.
- Re-publish the package.
Related Information
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"ARM Category":[{"code":"a8m0z000000bo47AAA","label":"Reporting->External Data"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.2;and future releases"}]
Was this topic helpful?
Document Information
Modified date:
25 February 2021
UID
swg21474174