唯一索引错误:引入了唯一索引。需要升级脚本

发布于 2024-10-20 10:21:21 字数 282 浏览 3 评论 0原文

我怎样才能让这个BP错误消失:唯一索引错误:引入了唯一索引。需要升级脚本。

http://msdn2.microsoft.com/en-gb/library/aa884122.aspx 告诉我实施 升级脚本。 如何实施升级脚本,这会让 BP 错误消失吗?

或者更好的是,我怎样才能在没有脚本的情况下摆脱这个错误,因为该项目还没有jet部署给客户?

How can I make this BP error go away: Unique index error: Unique index introduced. Upgrade script required.

http://msdn2.microsoft.com/en-gb/library/aa884122.aspx tells me to implement
an upgrade script.
How do I implement an upgrade script and will this make the BP error go away?

Or even better, how can I get rid of this error without the scripts, because the project has not jet deployed to customers?

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

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

发布评论

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

评论(3

硪扪都還晓 2024-10-27 10:21:21

如果您只是想在没有脚本的情况下消除错误,您可以相应地修改 \Classes\SysBPCheckTable\checkIndicesMoreUnique ,或者在 中注释掉 this.checkIndicesMoreUnique(); >\Classes\SysBPCheckTable\check

If you just want to get rid of the error without the scripts you can modify \Classes\SysBPCheckTable\checkIndicesMoreUnique accordingly or rather comment out this.checkIndicesMoreUnique(); in \Classes\SysBPCheckTable\check.

桃扇骨 2024-10-27 10:21:21

如果您选择忽略 BP 警告,请注意您在客户处的同步可能会因重复密钥而失败。如果 1. 客户表包含记录,2. 新索引也有新字段,则尤其如此。

您提供的链接中描述了制作更新脚本的方法。您会在 ReleaseUpdate 类中找到很多示例。

If you choose to ignore the BP warning, beware that your synchronization at your customers may fail due to duplicate keys. This is especially true if 1. customer table contains records, 2. the new index has a new field as well.

The way to make an update script is described in the link you provided. You will find lots of examples in the ReleaseUpdate classes.

只有影子陪我不离不弃 2024-10-27 10:21:21

在仅仅“消除”BP 错误之前,您必须首先调查该指数。索引由哪些字段组成?

如果不需要索引,并且索引位于可以删除的图层中,则删除索引。话虽如此,您之后还应该对 AOT 进行编译,以确保该索引不是代码中某处的引用(例如,使用索引提示完成选择的地方)。

但首先您需要确定创建索引的原因。

Before merely ‘getting rid of’ the BP error, you have to investigate the index first. Which fields make up the index?

If the index is not needed, and is in a layer you can delete from, then delete the index. Having said that, you should afterwards do a compile on the AOT as well to make sure that this index isn’t references somewhere in the code (for example where selects are done with index hint).

But first of all you need to establish why the index has been created.

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