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。