shr-云之家同步问题
赵文雅
806次浏览
编辑于2020年02月13日 08:41:06
错误信息：null
Caused exception message is: Sql222 execute exception : update T_BD_Hrxuntusersynchrec set (FPersonId, FName, FEmail, FOrgName, FJobTitle) = (select hum.FPersonId, hum.FName, hum.FEmail, hum.FOrgName, hum.FJobTitle from t_bd_hrxuntusermapping hum where T_BD_Hrxuntusersynchrec.fopenid = hum.fopenid) where T_BD_Hrxuntusersynchrec.fopenid = ? and T_BD_Hrxuntusersynchrec.FBatchNumber = 1259 and exists (select 1 from t_bd_hrxuntusermapping hum where T_BD_Hrxuntusersynchrec.fopenid = hum.fopenid )
Caused exception message is: ORA-01427: 单行子查询返回多个行
Caused exception message is: Sql222 execute exception : update T_BD_Hrxuntusersynchrec set (FPersonId, FName, FEmail, FOrgName, FJobTitle) = (select hum.FPersonId, hum.FName, hum.FEmail, hum.FOrgName, hum.FJobTitle from t_bd_hrxuntusermapping hum where T_BD_Hrxuntusersynchrec.fopenid = hum.fopenid) where T_BD_Hrxuntusersynchrec.fopenid = ? and T_BD_Hrxuntusersynchrec.FBatchNumber = 1259 and exists (select 1 from t_bd_hrxuntusermapping hum where T_BD_Hrxuntusersynchrec.fopenid = hum.fopenid )
Caused exception message is: ORA-01427: 单行子查询返回多个行
推荐阅读