执行EAS某项操作时，提示排序规则冲突
王秀珩
749次浏览
编辑于2018年07月23日 17:34:49
适用版本EAS7.0.x
问题描述客户正在操作结账，突然提示报错，client.log及apusic日志中均提示排序规则冲突。Caused by:com.kingdee.bos.BOSExceptioncom.kingdee.bos.BOSException: Sql1execute exception : insert intot_gl_assistmeasurebalance(forgunitid, fperiodid, fbaltype, fcurrencyid,faccountid, fperiodyear, fperiodnumber, fassistgrpid , fmeasureunitid ) select distinct t.orgunitid, t.periodid,t.baltype, tc.FID, t.accountid, tp.fperiodyear, tp.fperiodnumber, t.assistgrpid, t.measureunitid fromVTU6R80VZVSN6M985O3C6Z1TF4LJKMXDYVJ t inner join t_bd_currency tc on tc.fid in (t.currencyid,'11111111-1111-1111-1111-111111111111DEB58FDC') inner join t_bd_period tp ontp.fid=t.periodid where t.balancetype =3 and not exists ( select 1 fromt_gl_assistmeasurebalance b whereb.forgunitid = t.orgunitid andb.fperiodid = t.periodid and b.fbaltype= t.baltype and b.fcurrencyid = tc.FID and b.faccountid = t.accountid and b.fassistgrpid = t.assistgrpid and b.fmeasureunitid = t.measureunitid )Caused exception message is: 无法解决 equalto 操作中 "Chinese_PRC_CS_AS" 和"Chinese_PRC_CI_AS" 之间的排序规则冲突。
问题描述客户正在操作结账，突然提示报错，client.log及apusic日志中均提示排序规则冲突。Caused by:com.kingdee.bos.BOSExceptioncom.kingdee.bos.BOSException: Sql1execute exception : insert intot_gl_assistmeasurebalance(forgunitid, fperiodid, fbaltype, fcurrencyid,faccountid, fperiodyear, fperiodnumber, fassistgrpid , fmeasureunitid ) select distinct t.orgunitid, t.periodid,t.baltype, tc.FID, t.accountid, tp.fperiodyear, tp.fperiodnumber, t.assistgrpid, t.measureunitid fromVTU6R80VZVSN6M985O3C6Z1TF4LJKMXDYVJ t inner join t_bd_currency tc on tc.fid in (t.currencyid,'11111111-1111-1111-1111-111111111111DEB58FDC') inner join t_bd_period tp ontp.fid=t.periodid where t.balancetype =3 and not exists ( select 1 fromt_gl_assistmeasurebalance b whereb.forgunitid = t.orgunitid andb.fperiodid = t.periodid and b.fbaltype= t.baltype and b.fcurrencyid = tc.FID and b.faccountid = t.accountid and b.fassistgrpid = t.assistgrpid and b.fmeasureunitid = t.measureunitid )Caused exception message is: 无法解决 equalto 操作中 "Chinese_PRC_CS_AS" 和"Chinese_PRC_CI_AS" 之间的排序规则冲突。
推荐阅读