This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 12%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Hello,
I am getting an error while processing a Tabular model : Failed to save modifications to the server. Error returned: '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.
I am not able to find this setting in Tabular model. I have :
Compatibility Level : SQL Server 2016 (1200)
Version : 14.0.249.3
Any suggestions.
Thanks in Advance.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Hi,
This error happens because of the string data size over 4 gb. It is not about the 1200 compatibility level you see.
The best way to resolve this error is to increase string storage capacity.
This is a multi-step process that starts with having the database at certain compatibility level (1100 or higher), setting the StringStoresCompatibilityLevel property on the object, and concludes with reprocessing the object.
You could see more and follow the steps in this article.
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November
I see this property is available in Multi dimensional model. All the blogs also show it in multi dimensional model. However, I don't find it in tabular model and I am getting error in Tabular. Any idea how to resolve this in Tabular model.
This should be a MD Olap property. Did you have other MD OLAP cube on this machine that may cause the issue ?
What change have you done before this error that may cause this ?
Have you check that this is cause from you tabular model ? Could you identify that if your column in table contains large string that is over 4 gigabyte? If not, I think this is false error message that the true problem is not revealed .
Hi Lukas,
When we checked log, it gave the real error, which was the Memory issue. We have since made changes to the Cube reducing the number of columns and calculated tables.
However, the error (StringStoresCompatibilityLevel) that came while processing is actually misleading, since there is no such property in Tabular model. We wasted lot of time trying to find this property in tabular model before asking for the SSAS logs from our DBA's.
Thank you for your reply and follow up on the same.