ITA Cube Fails to process

Products

• IT Management Suite
• IT Analytics
• Client Management Suite

Issue/Introduction

Error message when processing an ITA Cube:

"File system error: A string store or binary store with a compatibility level of '1050' is at the maximum file size of 4 gigabytes."

 

Full Event log entry:

Step ID                  1

Server                   DBServer

Job Name                            Task Cube

Step Name                          Tasks

Duration                              00:00:00

Sql Severity        0

Sql Message ID  0

Operator Emailed            

Operator Net sent          

Operator Paged

Retries Attempted          0

 

Message

Executed as user: Domain\AppID. <return xmlns="urn:schemas-microsoft-com:xml-analysis"><results xmlns="http:schemas.microsoft.com/analysisservices/2003/xmla-multipleresults"><root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"><Exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception"><Error ErrorCode="3238133842" Description="File system error: A string store or binary store with a compatibility level of '1050' is at the maximum file size of 4 gigabytes. To store additional strings, you can change the StringStoresCompatibilityLevel property of the associated dimension or distinct count measure to '1100' and reprocess. This option is only available on databases with a compatibility level of '1100' or higher. Physical file: \\?\M:\OLAP\Data\IT Analytics.0.db\Parent Task.0.dim\86.Parent Task - Instance Guid.ksstore. Logical file: ." Source="Microsoft SQL Server 2014 Analysis Services" HelpFile="" /><Error ErrorCode="3240034317" Description="Errors in the OLAP storage engine: An error occurred while the 'Parent Task - Instance Guid' attribute of the 'Parent Task' dimension from the 'IT Analytics' database was being processed." Source="Microsoft SQL Server 2014 Analysis Services" HelpFile="" /><Error ErrorCode="3238002695" Description="Internal error: The operation terminated unsuccessfully." Source="Microsoft SQL Server 2014 Analysis Services" HelpFile="" /><Error ErrorCode="3239837702" Description="Server: The current operation was cancelled because another operation in the transaction failed." Source="Microsoft SQL Server 2014 Analysis Services" HelpFile="" /></Messages></root></results></return>

 

Environment

ITA 8.x

Cause

"Compatibility level of '1050' is at the maximum file size of 4 gigabytes" is from SQL 2008 or earlier.  Level 1100 is used today. 

Resolution

Uninstall the Cube that is causing this error message.  This causes the Cube to be deleted from Analysis Services.  
Then, reinstall the affected Cube (it will recreate it), it should now be able to Process.