Error 'Unable to upload, exceeded limit at line 1000'

今天使用Cognos倒入外部数据的时候出现错误“'Unable to upload, exceeded limit at line 1000'”,使用下面的步骤可以解决：

 

Steps:
1 Open the model for the package in Cognos 10 Framework Manager
2 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
3 Save the model
4 Re-publish the package

中的可以在FM 项目--〉〉编辑控制规则  菜单中设置。

 

原因是Cognos会控制最大外部数据行数以及外部数据文件的大小，如果超过这个限制则无法倒入。 我将自己的数据行数修改为100000