Memory allocation failure. The paging size is too small for the operation to complete is the error returned by SSMS whenever the ssas cubes are refreshed through ssms sql server agent. The version of SSMS is v17 and SSAS (visual studio) is v17.

Shivani Keluskar 1 Reputation point
2021-09-24T06:24:01.547+00:00

Memory allocation failure. The paging size is too small for the operation to complete is the error returned by SSMS whenever the ssas cubes are refreshed through ssms sql server agent. The version of SSMS is v17 and SSAS (visual studio) is v17.

We have used the processing type as process full as well as process default but still same issues arises. There are no other parallel activities been performed on the server and server ram is 64GB. Also the system type is 64-Bit operation system.

134898-memory.jpg

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,677 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,243 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,929 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
0 comments No comments
{count} votes