ORA-01775: looping chain of synonyms

 

[ERROR] [com.xinaomdt.hmpsnew.common.HmpsService] -- 执行SQL时错误.

运行时参数:sql= select t.* ,a.fullname as lifecyclelabel ,b.fullname as studycl

asscodelabel ,c.fullname as studyitemcodelabel from t_hr_examresult t ,t_hr_c_li

fecycle a ,t_ch_examcategory b ,t_ch_examitem c where t.lifecycle = a.code(+) an

d t.studyclasscode = b.code(+) and t.studyitemcode = c.code(+) and t.mrid='0A087

E8A-D3DA-4B00-87B0-B077F6639A9B' and t.status = 'Active'

异常信息：ORA-01775: looping chain of synonyms

[ERROR] [com.xinaomdt.hmpsnew.common.HmpsService] -- 执行SQL时错误.

运行时参数:sql= select t.* ,a.fullname as lifecyclelabel ,b.fullname as studycl

asscodelabel ,c.fullname as studyitemcodelabel from t_hr_examresult t ,t_hr_c_li

fecycle a ,t_ch_examcategory b ,t_ch_examitem c where t.lifecycle = a.code(+) an

d t.studyclasscode = b.code(+) and t.studyitemcode = c.code(+) and t.mrid='0A087

E8A-D3DA-4B00-87B0-B077F6639A9B' and t.status = 'Active'

异常信息：ORA-01775: looping chain of synonyms

Actions:

查看SQL语句中的连接的同义词的基表,如果基表不存在需重新建立,上例是因为T_CH_EXAMITEM的同义词所连接基表不存在引起的.