重新部署该项目时,我会在SSA上遇到错误。错误是;
JSON DDL请求失败了以下错误:加载表数据时发生了错误。可能的原因是:损坏的字符串存储数据文件的一个表列。 segments.error加载表'',file'$ nestror(437294994)$ country(437295007).pos_to_id.0.idf'.database Encelamency checects(dbcc)在检查data seggments.error时发生了data seggments.error的失败。 table'',file'1245.h $ nestial(437294994)$ city ....
我检查了餐桌国家 /地区,但没有重复的数据。
有人可以帮忙吗?
I'm getting error on SSAS when redeploy the project. The error is;
The JSON DDL request failed with the following error: Error happened while loading table data. Possible cause is: corrupt string store data file for one of the table columns.Error happened while loading table data.A duplicate value has been detected in the Unique Value store associated with the dictionary.Database consistency checks (DBCC) failed while checking the data segments.Error happened while loading table '', file '1245.H$Countries (437294994)$Country (437295007).POS_TO_ID.0.idf'.Database consistency checks (DBCC) failed while checking the data segments.Error happened while loading table '', file '1245.H$Countries (437294994)$City ....
I checked the table Countries but there is no duplicated data.
Is there anybody who can help please?
发布评论
评论(1)
正如错误所暗示的那样,该模型具有一些损坏的数据(不要与重复的数据混淆)。
微软在这里有一些错误的解决方案: https://learn.microsoft.com/en-us/analysis-services/inalysis-services/instances/Instances/database-consistency-consistency-consistency-consistency-concectency-checker-dbcc-dbcc - 进行分析服务?view = asallproducts-allversions#common-resolutions-for-orror-conditions
tl:dr:dr:dr:dr:
As the error implies, the model has some corrupted data (not to be confused with duplicated data).
Microsoft has some resolutions for there kinds of errors here: https://learn.microsoft.com/en-us/analysis-services/instances/database-consistency-checker-dbcc-for-analysis-services?view=asallproducts-allversions#common-resolutions-for-error-conditions
TL:DR: