如果tomcat-eams1/logs文件夹中有catalina.out日志文件,则可以在系统页面操作,使得页面报错,
然后打开文件位置:
.....tomcat-eams1/logs
运行命令:
$ tail -500 catalina.out
查找报错约束:
Caused by: java.sql.BatchUpdateException: ORA-02292: integrity constraint (EAMS.FK5E3EECFEDD198277) violated - child record found
查找关联表:
select * from user_constraints where constraint_name like '%FK5E3EECFEDD198277%'
删除关联表中垃圾数据:
delete from JXZL_PJ_WZ_T where JXRWID in (21692,21691)
或者在系统页面删除。