Visual Studio 弄乱了 SSAS 项目中的 .partitions 文件,如何修复?

发布于 2024-09-13 04:57:56 字数 182 浏览 8 评论 0原文

突然我无法再处理 S​​SAS 项目了。我收到的错误是“x.partitions”无效且无法打开。检查“x.partitions”文件

我记得的最后一件事是将项目签入 TFS。如果有一个解决这个问题的好主意,我们将不胜感激。

导致问题的多维数据集是其中包含 2 个链接多维数据集的多维数据集。 (我认为这应该与此无关)

Suddenly I can't process a SSAS project anymore. The error I get is 'x.partitions' is not valid and cannot be opened. Check the 'x.partitions' file

Last thing I remember was a checkin of the project into TFS. A good idea to fix this would be very much appreciated.

The Cube that is causing the problem is a cube with 2 linked cubes in it. (I assume it shouldn't have anything to do with it)

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(3

幸福%小乖 2024-09-20 04:57:56

你看过实际的分区文件吗?我认为除非您显示所有文件,否则您将无法在投标中看到。您可能需要查看磁盘。您对分区的查询怎么样?您可以在 BIDS 中访问您的分区吗?

have you looked at the actual partitions file? you wont be able to see in BIDS i think unless you show all files. You might have to look on disk. What about your queries for your partitions? can you get to your partitions in BIDS?

留一抹残留的笑 2024-09-20 04:57:56

重命名多维数据集后,我们遇到了分区消失的问题(默认分区,这里没有什么花哨的东西)。结果是我们仍然可以部署和处理,但是数据库只包含维度数据,没有事实数据。

我们注意到 .cube 文件丢失了分区节点,该节点应该位于代码底部的某个位置:

  </Dimensions>
  <Partitions />
</MeasureGroup>

我们尝试添加一个新分区,但没有成功。 .partitions 文件(隐藏在 Visual Studio 中)最终几乎为空。在另一台机器上,我们进行了回滚,这在本地解决了问题。但在 TFS 中检查它并在原始计算机上获取最新版本并没有携带此信息。我们必须手动将 .partitions 文件复制到重命名所在的原始计算机(或复制内容)。

因此,我怀疑您可以通过在开始干预新分区之前再次添加分区节点来解决问题。干预后,您需要重建两个文件的内容。
[2012 年春夏,2012 年VS]

We had a problem with a disappearing partition (the default one, no fancy stuff here) after renaming the cube. The result was that we could still deploy and process, but the database contained only dimension data, no fact data.

We noticed the .cube file had lost the Partitions node, which should be somewhere at the bottom of the code:

  </Dimensions>
  <Partitions />
</MeasureGroup>

We tried to add a new partition, which did not succeed. The .partitions file (hidden in Visual Studio) ended up almost empty. On a different machine we did a roll back, which solved the issue locally. But checking it in in TFS and getting latest version on the original machine did not carry this. We had to copy the .partitions file manually to the original machine where the rename had originated (or copy the content).

So I suspect you can solve the problem by adding the Partitions node again, BEFORE you start meddling with new partitions. After meddling you need to reconstruct the content of both files.
[SS2012, VS2012]

╰沐子 2024-09-20 04:57:56

我也遇到了类似的问题,尽管我创建它是因为我想重命名分区 ID。
重命名后,Visual Studio 向我显示分区文件错误,但当我查看多维数据集时仍然显示“分区”选项卡,其中包含过时的信息。

发生的情况是 Visual Studio 在 *.cube 文件中创建了一个空的“”标记。因此,“分区”当然无法加载!

结果我只需要从 *.cube 文件中删除那个空标签,瞧,就可以再次加载我的分区文件了!

编辑:我正在使用 VS 2010,但我很确定这同样适用于 VS 2008。

I had a similar problem, although I created it because I wanted to rename the Partition ID.
After renaming, Visual Studio showed me an error with the partition file but still showed the "partitions" tab when I viewed the cube, with outdated information.

What had happened was that Visual Studio created an empty "" tag in the *.cube file. Due to this the "partition" could not be loaded of course!

Turns out I only had to remove that empty tag from the *.cube file and voilá was able to load my partitions file again!

EDIT: I am using VS 2010 but I am pretty sure the same applies to VS 2008.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文