我在使用用友T6企业管理软件的T6初始化模块中碰到了一个奇怪的问题:
T66.1升级T66.3报错,请问问一下
具体的情况如下:
T66.1升级T66.3报错,请问问一下如何解决,自己已经看过IA_subsidiry这张表的长度,改成了和正常账套一样,但是还是无法解决,请问一下还有什么原因
请问用友软件售后服务,应该如何解决呢?注意以下内容来自网友提供的尝试性解决方案,操作前请务必参考用友软件备份账套数据教程备份数据,如果未能解决您的问题,可以点击并添加用友软件工程师微信号进行咨询。
您好,请先把ufdata_902_2012替换为您环境中的演示账套数据库或新建账套的数据库,然执行以下语句:drop table ia_subsidiaryGOselect * into ia_subsidiary from UFDATA_901_2012..ia_subsidiary where 1=2GOdrop table JustInVouchsGOselect * into JustInVouchs from UFDATA_901_2012..JustInVouchs where 1=2GOALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__11165497] DEFAULT (null) FOR [cDefine22]GOALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__120A78D0] DEFAULT (null) FOR [cDefine23]GOALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__12FE9D09] DEFAULT (null) FOR [cDefine24]GOALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__13F2C142] DEFAULT (null) FOR [cDefine25]GOALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__16CF2DED] DEFAULT (null) FOR [cDefine22]GOALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__17C35226] DEFAULT (null) FOR [cDefine23]GOALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__18B7765F] DEFAULT (null) FOR [cDefine24]GOALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__19AB9A98] DEFAULT (null) FOR [cDefine25]GOGO
不行呀,命令是正确的,但是执行的时候提示图片当中的错误
您好,在问题账套库里执行以下语句:GOALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__11165497] DEFAULT (null) FOR [cDefine22]GOALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__120A78D0] DEFAULT (null) FOR [cDefine23]GOALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__12FE9D09] DEFAULT (null) FOR [cDefine24]GOALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__13F2C142] DEFAULT (null) FOR [cDefine25]GOALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__16CF2DED] DEFAULT (null) FOR [cDefine22]GOALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__17C35226] DEFAULT (null) FOR [cDefine23]GOALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__18B7765F] DEFAULT (null) FOR [cDefine24]GOALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__19AB9A98] DEFAULT (null) FOR [cDefine25]GO