問(wèn)題現(xiàn)象:用友暢捷通T+財(cái)務(wù)軟件升級(jí)報(bào)錯(cuò),具體提示如下:2015-05-26 10:22:09.949`[錯(cuò)誤]`[SMR]`PID:1`PName:Ufida.T.Tool.YYTServices.exe`TID:487`升級(jí)出錯(cuò),錯(cuò)誤信息:SQL 腳本: 11.510.000.0031 DATA_DSTR_GL_Vou-34006 出錯(cuò):錯(cuò)誤: 新名稱(chēng) 'TEMP_1_SM_FC_TransactionDoc' 已用作 object 名稱(chēng),因此會(huì)導(dǎo)致重復(fù),這是不允許的。

錯(cuò)誤: 新名稱(chēng) 'TEMP_1_SM_FC_TransactionEntry' 已用作 object 名稱(chēng),因此會(huì)導(dǎo)致重復(fù),這是不允許的。

錯(cuò)誤: 新名稱(chēng) 'TEMP_1_SM_FC_TransactionAuxiliaryInfo' 已用作 object 名稱(chēng),因此會(huì)導(dǎo)致重復(fù),這是不允許的。

錯(cuò)誤: 新名稱(chēng) 'TEMP_1_SM_FC_TransactionDocSourceRelation' 已用作 object 名稱(chēng),因此會(huì)導(dǎo)致重復(fù),這是不允許的。

錯(cuò)誤: 新名稱(chēng) 'TEMP_1_SM_FC_TransactionEntrySourceRelation' 已用作 object 名稱(chēng),因此會(huì)導(dǎo)致重復(fù),這是不允許的。![具體出錯(cuò)信息請(qǐng)參見(jiàn):C:\Program Files (x86)\Chanjet\TPlus11600\Appserver\server\..\logs\UFTData463015_116002_Upgrade.log

類(lèi):Ufida.T.SM.Upgrade.Service.dll UpgradeService 方法:Void Upgrade(Ufida.T.SM.AccountInfo.DTO.UpgradeContext)

類(lèi):Ufida.T.EAP.AopBase.dll ShortServiceHandler 方法:Void OnReceiveBodyData(System.IAsyncResult);Ufida.T.SM.Upgrade.Service.UpgradeService.Upgrade

解決方案:根據(jù)提示的對(duì)象名,修改掉重復(fù)的名稱(chēng),然后可繼續(xù)升級(jí)(操作前請(qǐng)備份好您用友T+財(cái)務(wù)軟件中的數(shù)據(jù),可參考教程:http://bainianle.cn/jcufida/1389.html),示例語(yǔ)句如下:

----TEMP_1_模塊_XXXXXXX 只能清除數(shù)據(jù),物理表需要保留

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SM_FC_TransactionDoc]') AND type in (N'U'))

EXEC sp_rename 'SM_FC_TransactionDoc', 'TEMP_1_SM_FC_TransactionDoc111'

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SM_FC_TransactionEntry]') AND type in (N'U'))

EXEC sp_rename 'SM_FC_TransactionEntry', 'TEMP_1_SM_FC_TransactionEntry111'

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SM_FC_TransactionAuxiliaryInfo]') AND type in (N'U'))

EXEC sp_rename 'SM_FC_TransactionAuxiliaryInfo', 'TEMP_1_SM_FC_TransactionAuxiliaryInfo111'

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SM_FC_TransactionDocSourceRelation]') AND type in (N'U'))

EXEC sp_rename 'SM_FC_TransactionDocSourceRelation', 'TEMP_1_SM_FC_TransactionDocSourceRelation111'

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SM_FC_TransactionEntrySourceRelation]') AND type in (N'U'))

EXEC sp_rename 'SM_FC_TransactionEntrySourceRelation', 'TEMP_1_SM_FC_TransactionEntrySourceRelation111'