問題現(xiàn)象:用友暢捷通T+財(cái)務(wù)軟件升級(jí)報(bào)錯(cuò),具體提示如下:升級(jí)出錯(cuò),錯(cuò)誤信息:升級(jí)腳本出錯(cuò),錯(cuò)誤信息:SQL 腳本: 11.600.000.0000 DATA_DATA_RAP_NL 出錯(cuò):因?yàn)榘l(fā)現(xiàn)對(duì)象名稱 'dbo.EAP_BusOperation' 和索引名稱 'i_EAP_BusOperation_id' 有重復(fù)的鍵,所以 CREATE UNIQUE INDEX 語句終止。重復(fù)的鍵值為 (abaa7922-7529-4bdd-b153-24e72f493560)。
語句已終止。
解決辦法:
需要?jiǎng)h除重復(fù)的記錄,根據(jù)重復(fù)的鍵值查詢到是那一條記錄,然后刪除,(操作前請(qǐng)備份好您用友T+財(cái)務(wù)軟件中的數(shù)據(jù),可參考教程:http://bainianle.cn/jcufida/1389.html),示例語句如下:
delete from EAP_BusOperation where id='4D4DEBD6-970F-4C96-AF79-1DAEE720E861' and idfunctionauth='7445A7E8-2FC3-4622-AB5A-420407266418'
delete from EAP_BusOperation where id='ABAA7922-7529-4BDD-B153-24E72F493560' and idfunctionauth='7445A7E8-2FC3-4622-AB5A-420407266418'
delete from EAP_BusOperation where id='D64C7E15-A00F-4269-9BAB-31EA66C7B9CD' and idfunctionauth='447EB11F-4DA0-472A-AF78-3DE69BAE2D27'
delete from EAP_BusOperation where id='F67527FD-0B08-43C8-B794-490CE780E8CD' and idfunctionauth='447EB11F-4DA0-472A-AF78-3DE69BAE2D27'
delete from EAP_BusOperation where id='78D3DBDF-7387-4565-BFDA-4DE531BEA1D5' and idfunctionauth='786EA90A-CA50-4D6D-A5CE-8B3CA09F7C06'
delete from EAP_BusOperation where id='2AAEE2EB-54C7-4FFC-9C00-DCC9F06798BF' and idfunctionauth='7445A7E8-2FC3-4622-AB5A-420407266418'
delete from EAP_BusOperation where id='58526641-E80F-43A8-B347-6EFB4F45F20F' and idfunctionauth='786EA90A-CA50-4D6D-A5CE-8B3CA09F7C06'
delete from EAP_BusOperation where id='375BC5E1-1D29-4AE2-8FB8-585B3092CA66' and idfunctionauth='447EB11F-4DA0-472A-AF78-3DE69BAE2D27'
delete from EAP_BusOperation where id='2FEA68D2-7D47-48AB-B004-C4761EFC0E09' and idfunctionauth='447EB11F-4DA0-472A-AF78-3DE69BAE2D27'
delete from EAP_BusOperation where id='0171DA98-FD90-4A0B-8C0B-798735014A5B' and idfunctionauth='7445A7E8-2FC3-4622-AB5A-420407266418'