当前位置:首页 > 用友知识堂 > 正文内容

用友T+升级报错对象名称EAP_BusOperation 和索引名称i_EAP_BusOperation_id有重复键?

7年前用友知识堂989

问题现象:用友畅捷通T+财务软件升级报错,具体提示如下:11.51升级到12.0标准版,报错,错误信息,sql脚本11.600.000.0000 DATA_RAP_NL出错对象名称EAP_BusOperation 和索引名称i_EAP_BusOperation_id有重复键,该怎么办?和索引有重复。

解决方案:

从重复的数据来看,应该是客户测试过二次开发,新增了报表,出现的重复数据,随意删除其中一条就可以了。(操作前请备份好您用友T+财务软件中的数据,可参考教程:https://www.zzerp.net/jcufida/1389.html)可以执行以下语句,然后再升级:

微信号:yyrjlls
扫码 有偿解决 用友软件技术问题!
复制微信号

delete from EAP_BusOperation where id='074CDADE-317A-4B8D-90D3-28FFE3112AE7'

and idfunctionauth='F2761F28-5F25-4854-8696-C57BA5236944'

delete from EAP_BusOperation where id='C122AFBA-3B44-485C-94AF-4A3BF729C0FA'

and idfunctionauth='F2761F28-5F25-4854-8696-C57BA5236944'

delete from EAP_BusOperation where id='2CFF808D-E5DB-48FD-AC6F-2EB66AAB15B1'

and idfunctionauth='F2761F28-5F25-4854-8696-C57BA5236944'

delete from EAP_BusOperation where id='16618F96-6978-44FC-89A4-4A4976F51DBD'

and idfunctionauth='974ADC83-54C5-4156-AAFD-6DE5ACEBE8EB'

delete from EAP_BusOperation where id='ED27F226-72A3-465F-BE2F-3B6837E5948F'

and idfunctionauth='F2761F28-5F25-4854-8696-C57BA5236944'

delete from EAP_BusOperation where id='44C15F1A-649E-4096-86AA-AC70CF297789'

and idfunctionauth='F2761F28-5F25-4854-8696-C57BA5236944'

delete from EAP_BusOperation where id='6AB4B84A-3600-43E5-A5F7-D87BB8B79E23'

and idfunctionauth='2206C509-22C9-42F7-8FBB-F26F4C1FED49'

delete from EAP_BusOperation where id='2B0CEA90-4944-4BA9-A65E-D6FE60D7C338'

and idfunctionauth='D56641EE-3D92-4A01-AC1E-4DAA65BBADEB'

delete from EAP_BusOperation where id='11EB424F-A706-4D0F-874C-FBD31BDF892D'

and idfunctionauth='D56641EE-3D92-4A01-AC1E-4DAA65BBADEB'

delete from EAP_BusOperation where id='D42F32F6-6297-40B7-9EB7-720EB68CC82E'

and idfunctionauth='702B5ACE-A4CB-4E0B-8551-3CAC99FDF605'

delete from EAP_BusOperation where id='92EDABBD-6AD2-4007-AAAC-31B1EFF96B48'

and idfunctionauth='F2761F28-5F25-4854-8696-C57BA5236944'

delete from EAP_BusOperation where id='1E9F36C4-5FDB-4583-ADA8-318F05C9B198'

and idfunctionauth='F2761F28-5F25-4854-8696-C57BA5236944'

delete from EAP_BusOperation where id='D4DB4A81-FC32-451E-9698-4C3A6F530501'

and idfunctionauth='2B693A26-9651-4838-BDEA-13DAC3181039'

delete from EAP_BusOperation where id='881559B7-3537-46F1-A193-D5B5946F70BB'

and idfunctionauth='2B693A26-9651-4838-BDEA-13DAC3181039'

delete from EAP_BusOperation where id='0AAD50BB-8D94-4465-90CE-CD9934F8E6A3'

and idfunctionauth='4A0854AB-4677-4701-857A-D3CB44B9CA1D'

delete from EAP_BusOperation where id='25E2C755-41D0-44DB-8C1D-772073528B8C'

and idfunctionauth='2B693A26-9651-4838-BDEA-13DAC3181039'

delete from EAP_BusOperation where id='576E5305-B49E-40FC-9232-C7E6053F2FBB'

and idfunctionauth='F2761F28-5F25-4854-8696-C57BA5236944'

delete from EAP_BusOperation where id='C27AE3D0-EAFE-4743-9ED4-775DB3E33096'

and idfunctionauth='D56641EE-3D92-4A01-AC1E-4DAA65BBADEB'

delete from EAP_BusOperation where id='497F5583-DAFA-4034-9E48-699D04124255'

and idfunctionauth='2B693A26-9651-4838-BDEA-13DAC3181039'

delete from EAP_BusOperation where id='B25AA9C5-985B-4740-8E9F-E482B59D63AA'

and idfunctionauth='D56641EE-3D92-4A01-AC1E-4DAA65BBADEB'

温馨提示:近期载地址失效频繁,如链接失效请点击此处查阅详情!

相关文章

(12.000.001.0007) DATA_DPRD_GL_Vou-34033 升级报错

问题现象:用友畅捷通T+财务软件升级报错,具体提示如下:(12.000.001.0007) DATA_DPRD_GL_Vou-34033 升级报错,以下用友T+版本升级时报错,解决办法相同,先降级再...

(12.000.001.0015) DATA_DATA_GL_Mix_NL-44001 出错

问题现象:用友畅捷通T+财务软件升级报错,具体提示如下:(12.000.001.0015) DATA_DATA_GL_Mix_NL-44001 出错,升级出错,错误信息:升级脚本出错,错误信息:sq...

用友T+升级报错:SQL 脚本: 11.600.000.0000 DATA_DPRD_FI_Search_CN.sql 出错

问题现象:用友畅捷通T+财务软件升级报错,具体提示如下:升级出错,错误信息:升级脚本出错,错误信息:SQL 脚本: 11.600.000.0000 DATA_DPRD_FI_Search_CN.sq...

(12.000.001.0044) DATA_DPRD_ST_Rpt_CN-33005 出错:子查询返回的值不止一个

问题现象:用友畅捷通T+财务软件升级报错,具体提示如下:错误信息:升级脚本出错,错误信息:SQL 脚本: 12.000.001.0044 DATA_DPRD_ST_Rpt_CN-33005 出错:子...

(12.000.001.0032) DATA_ DATA_AA_vou_cn-24002出错:不能将值null插入列‘idunit’

问题现象:用友畅捷通T+财务软件升级报错,具体提示如下:升级出错,错误信息:sql脚本:12.000.001.0032 DATA_ DATA_AA_vou_cn-24002出错:不能将值null插入...

用友畅捷通T+升级报错:对象名称和索引名称有重复的键?

问题现象:用友畅捷通T+财务软件升级报错,具体提示如下:升级出错,错误信息:升级脚本出错,错误信息:SQL 脚本: 11.600.000.0000 DATA_DATA_RAP_NL 出错:因为发现对...

发表评论

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。