IT Analytics Cube for NS are Not Processing
Article ID: 171927
Updated On:
Products
IT Analytics
Issue/Introduction
After working for a certain period of time, the automatic processing job configured on the SMP stopped working. When manually processing the cubes on the SQL Analysis server, it was noticed that some dimensions for the Tasks cube were not processing.
Dimension [Task] cannot be saved
Environment
7.6 ITA
Cause
The data set used to generate the Task dimension had grown to be larger than 4GB.
Resolution
The workaround for this is to remove the Task cube from Processing.
To resolve the issue, the SQL server version must be a Enterprise Version, or a Data Center version, and the dimension must have its StringStorecompatibilityLevel property set to 1100. See https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/configure-string-storage-for-dimensions-and-partitions?view=sql-server-2014 for instructions on how to do this.
This cannot be changed on a SQL Server Standard version.
To resolve the issue, the SQL server version must be a Enterprise Version, or a Data Center version, and the dimension must have its StringStorecompatibilityLevel property set to 1100. See https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/configure-string-storage-for-dimensions-and-partitions?view=sql-server-2014 for instructions on how to do this.
This cannot be changed on a SQL Server Standard version.
Feedback
Yes
No
Powered by
