无法保存对服务器的修改.返回错误:列表中的项目数太大 [英] Failed to save modifications to the server. Error returned: The number of items in the list is too large

问题描述

我正在尝试处理Analysis Service表中的大量数据(61.3 GB).数据具有3亿条记录和21列.每当我尝试使用SQL Server Analysis Service处理数据时，都会出现以下错误:

无法将修改保存到服务器.返回错误:列表中的项目数太大.缓冲列表最多可支持2147483647个项目，流列表最多可支持2147483647个项目 到4503599627370496项.IDbCommand接口引发了异常.

我需要处理此数据量.将这些数据量推送到Analysis Service表中的过程是什么?请帮忙.

解决方案

是否可以尝试使用较少数量的记录/列数据并更新结果?

此外，我建议您检查 Analysis Services资源和对象限制.

I am trying to Process large volume of data (61.3 GB) in an Analysis Service Table. The data has 300 millions of records and 21 columns. Whenever , I try to process the data using SQL server Analysis service , I am getting the following error :

Failed to save modifications to the server. Error returned: 'The number of items in the list is too large.  Buffered lists can support up to 2147483647 items and streamed lists can support up to 4503599627370496 items.. The exception was raised by the IDbCommand interface.

I need to process this volume of data. What are the processes to push this amount of data into an Analysis Service table. Please help. 

解决方案

Could you try with less number of records/columns data and update the result? 

Also, I suggest you to check the Analysis Services resource and object limits.

这篇关于无法保存对服务器的修改.返回错误:列表中的项目数太大的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！