T6升级错误提示【自定义项为约束的表特殊处理 ‘JustInVouchs‘,‘IA_Subsidiary‘】

最新推荐文章于 2023-06-08 17:22:25 发布

jack8674

最新推荐文章于 2023-06-08 17:22:25 发布

阅读量551

点赞数

分类专栏：用友T6 文章标签：数据库运维

本文链接：https://blog.csdn.net/jack8674/article/details/127962031

版权

用友T6 专栏收录该内容

6 篇文章 1 订阅

订阅专栏

数据库名: UFDATA_003_2007

DATA_STR_BP_61_T3ToT6, DATA_STR_BP_61_T3ToT6

错误信息:

-2147217900

'DF__ia_subsid__cDefi__11165497' 不是约束。

执行如下语句时出错:

----自定义项为约束的表特殊处理 'JustInVouchs','IA_Subsidiary'

ALTER TABLE [dbo].[IA_Subsidiary] DROP CONSTRAINT [DF__ia_subsid__cDefi__11165497]

ALTER TABLE [dbo].[IA_Subsidiary] DROP CONSTRAINT [DF__ia_subsid__cDefi__120A78D0]

ALTER TABLE [dbo].[IA_Subsidiary] DROP CONSTRAINT [DF__ia_subsid__cDefi__12FE9D09]

ALTER TABLE [dbo].[IA_Subsidiary] DROP CONSTRAINT [DF__ia_subsid__cDefi__13F2C142]
解决方法：

从升级ok的帐套复制表过来,

drop table ia_subsidiary
GO
select * into ia_subsidiary
from UFDATA_663_2010..ia_subsidiary where 1=2
GO
drop table JustInVouchs
GO
select * into JustInVouchs
from UFDATA_663_2010..JustInVouchs where 1=2
GO
ALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__11165497] DEFAULT (null) FOR [cDefine22]
GO
ALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__120A78D0] DEFAULT (null) FOR [cDefine23]
GO
ALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__12FE9D09] DEFAULT (null) FOR [cDefine24]
GO
ALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__13F2C142] DEFAULT (null) FOR [cDefine25]
GO
ALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__16CF2DED] DEFAULT (null) FOR [cDefine22]
GO
ALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__17C35226] DEFAULT (null) FOR [cDefine23]
GO
ALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__18B7765F] DEFAULT (null) FOR [cDefine24]
GO
ALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__19AB9A98] DEFAULT (null) FOR [cDefine25]
GO
GO