1、问题描述

 insert into VTZBCQ4EVX6F30PYQGIW03XXSL select ab.faccountid accountid, ab.fassistgrpid assistgrpid, 

ab.fyeardebitlocal yeardebitlocal, ab.fyearcreditlocal yearcreditlocal, ab.fendbalancelocal endbalancelocal, 

ab.fyearpnllocal yearpnllocal, 

ab.fyeardebitqty yeardebitqty, ab.fyearcreditqty yearcreditqty, ab.fendqty endqty, 

ab.fyearpnlqty yearpnlqty 

from T_GL_AssistBalance_1L ab 

where forgunitid = ? 

and fperiod = ? 

Caused exception message is: Violate unique constraint on [VTZBCQ4EVX6F30PYQGIW03XXSL][IZBCQ4EVZ11YJNNS20]

at com.kingdee.eas.basedata.common.perf.app.CreateJobFacadeControllerBean._executeJob(CreateJobFacadeControllerBean.java:205)

at com.kingdee.eas.basedata.common.perf.app.AbstractCreateJobFacadeControllerBean.executeJob(AbstractCreateJobFacadeControllerBean.java:49)

at sun.reflect.GeneratedMethodAccessor2759.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

-----

2、原因分析

   存在重复的余额数据造成

3、操作步骤

  期末结账---快捷键ctrl + shift+F9--余额分析进行余额重算即可解决

 彻底解决需要删除重算余额数据加唯一性索引（具体脚本见附件）

4、注意

fi_gl_balance_index_adjust (4).zip