question

GauthamKamath-9893 avatar image
0 Votes"
GauthamKamath-9893 asked CarrinWu-MSFT commented

Cannot Change Compatability Level on SSAS 2019 (Multidimensional Model) to 1100

Hi

A few days ago we hit the following error

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: \\?\E:\MSSQL\Data\OLAP\Data\MySSAS.0.db\MyDim.0.dim\39637.Dimension Name.asstore.

I have a SSAS Multidimensional database that was created on an old SSDT for SSAS 2015. We are currently on SSAS 2019 and a requirement has come up to change the CurrentStringStoreCompatabilityLevel to 1100. All dimension objects are on 1050 currently and I am unable to change it as this is a read-only property on SSDT.

SSAS server properties says that supported Default Compatibility Level is 1100

119854-ssas2019-compatabilitylevel.jpg

The CurrentStringStoreCompatabilityLevel for any new dimension I create(on SSDT) still gets set to 1050. I have tried creating a new database also with a new DSV and new dimension. It still does NOT reflect the required 1100 compatibility level.

Since on SSDT, CurrentStringStoreCompatabilityLevel is a read-only property, I tried cheating it by updating the XMLA of dimension to 1100. But when I deploy it still gets set as 1050.

Any help is appreciated.

Thanks









sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT commented

Hi @GauthamKamath-9893,

Welcome to Microsoft Q&A!

Have you reprocess the objects after you reconfigure string storage to accommodate very large strings? Please refer to this link to get steps of reconfigure string storage.


Best regards,
Carrin


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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


Many thanks @CarrinWu-MSFT that link helped me to figure out what I was missing. The change to StringStoresCompatibilityLevel worked.

0 Votes 0 ·

Hi @GauthamKamath-9893, good to know that! Could you please do "Accept Answer" for this thread ? By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·