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

数据库名: 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 TA