用友T+升级报错对象名称EAP_BusOperation 和索引名称i_EAP_BusOperation_id有重复键?
问题现象:用友畅捷通T+财务软件升级报错,具体提示如下:11.51升级到12.0标准版,报错,错误信息,sql脚本11.600.000.0000 DATA_RAP_NL出错对象名称EAP_BusOperation 和索引名称i_EAP_BusOperation_id有重复键,该怎么办?和索引有重复。
解决方案:
从重复的数据来看,应该是客户测试过二次开发,新增了报表,出现的重复数据,随意删除其中一条就可以了。(操作前请备份好您用友T+财务软件中的数据,可参考教程:https://www.ufidaft.com/jcufida/1389.html)可以执行以下语句,然后再升级:
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'
- 95%的用户还阅读了
- 跨账套查询可否查询总账跨年度的查询?比如查询001账套2008、2009两个年度的数据?
- 资产负债表修改了报表公式,但是计算还是以以前的公式来计算,公式没有保存?
- 销售发货单表体上怎么没有价税合计一列?
- Pos外部配置设置,进行设置后不起作用?
- 用友T6ERP中各个基础档案对照表之间的作用
- 畅捷通T+pc端的分类调整后,手机端还是原来的数据,没有同步过来?
- 畅捷通T+浏览器_用友T+浏览器下载_用友畅捷通T+浏览器免费下载地址
- 金蝶KIS商贸系列进销存软件免费版下载地址
- 用友畅捷通T+V12.2标准版财务软件免费试用官方正版下载地址-非破解版
- 用友T1商贸宝IT通讯版V11.0普及版免费试用官方正版下载地址-非破解版
相关文章
- 用友t3账套怎样变更会计制度 用友T3账套变更会计制度:业务场景应用与操作流程详解
- 自己做代理记账财务软件有哪些 自己做代理记账财务软件哪家好 深度解析需求必备神器助你快速上手
- 结转本月费用 会计分录 结转本月费用会计分录最新注意事项与案例解析避免错误快速掌握核心要点
- 购买财务软件计什么科目:解决办法与特殊情况考虑
- 畅捷通t3财务通普及版 畅捷通T3财务通普及版:满足企业日常财务管理需求的应用价值
- 物流企业财务制度:专为中小企业设计的管理方案,细节决定成败!
- 红字发票可以做报销凭证吗 红字发票能否作为报销凭证?全面解析与常见误区规避
- 物流运输用什么财务软件最好最权威高效的解决方案推荐
- 用友u8 结转 折旧 用友U8结转折旧:简单高效,中小企业必备的财务解决方案!
- 用友t3备份账套要多久完成 用友T3备份账套要多久完成 快速高效让数据更安全不等待!