OLAP处理中常见问题解决

rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cv-payu%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"> rel="themeData" href="file:///C:%5CDOCUME%7E1%5Cv-payu%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"> rel="colorSchemeMapping" href="file:///C:%5CDOCUME%7E1%5Cv-payu%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml">

1、 Cube数据量过大，不能一次装载入内存

错误信息: Memory error: Allocation failure : Not enough storage is available to process this command.

解决方法：

在OLAP服务器属性中做如下设置：

·         MemoryLimitErrorEnabled = false

·         DatabaseConnectionPoolConnectTimeout = 60

·         DatabaseConnectionPoolMax = 50

·         DatabaseConnectionPoolTimeout = 120000

参考信息：

http://forums.microsoft.com/TechNet/ShowPost.aspx?PageIndex=0&SiteID=17&PageID=0&PostID=1120756

 

2、 源数据存在数据质量问题，类型转换错误

错误信息：Errors in the back-end database access module. OLE DB was unable to convert a value to the data type requested for column 2. Errors in the OLAP storage engine: An error occurred while processing the 'Diary Facts' partition of the 'Diary Facts' measure group for the 'Diary' cube from the QOS database.

解决方法：

根据错误信息找出出错数据表及字段，修复源数据

 

3、 cube数据容量超过操作系统允许单个文件上限，如32位为4G

错误信息：Memory error: An internal memory request exceeded the memory quota for the current processing action.

解决方法：

修改分区设计为多个分区，或者修改分区存储策略为ROLAP或HOLAP。