用友NC V5.7考勤日报生成不了，提示表或视图不存在，求高手帮忙。急急急！！！！

最新推荐文章于 2022-08-22 22:32:14 发布

原创最新推荐文章于 2022-08-22 22:32:14 发布 · 517 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#java #mysql

在使用用友NC V5.7的考勤日报功能时遇到问题，当尝试生成考勤日报时，系统抛出异常java.lang.NullPointerException，并进一步显示ORA-00942错误，表明存在表或视图不存在的问题。异常发生在DaystatImpl.generateDaystat0方法中。寻求解决方案。

考勤日报
nc.ui.tbm.tbm_021.KQReportUI
java.lang.NullPointerException
at nc.ui.hr.global.Global.getWaYearPeriod(Global.java:670)
at nc.ui.hr.comp.formulaset.ParserFactory.createFuncParser(ParserFactory.java:9)
at nc.ui.tbm.tbm_021.KQReportUI.onbtnDataGen(KQReportUI.java:2212)
at nc.ui.tbm.tbm_021.KQReportUI.access$2000(KQReportUI.java:76)
at nc.ui.tbm.tbm_021.KQReportUI$3.run(KQReportUI.java:3033)
at java.lang.Thread.run(Unknown Source)
[Thread-101] ERROR - Error
nc.vo.pub.BusinessException: ORA-00942: 表或视图不存在

at nc.impl.tbm.tbm_020.DaystatImpl.generateDaystat0(DaystatImpl.java:1130)
at nc.impl.tbm.tbm_020.DaystatImpl.generateDaystat(DaystatImpl.java:775)
at nc.itf.hr.ta.TAEjbEjbBean.generateDaystat(TAEjbEjbBean.java:3109)
at nc.itf.hr.ta.EJSLocalStatelessnc_itf_hr_ta_TAEjb_cf79ead0.generateDaystat(Unknown Source)
at sun.reflect.GeneratedMethodAccessor3427.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at nc.bs.framework.ejb.AbstractEJBServiceHandler.invoke(AbstractEJBServiceHandler.java:56)
at nc.bs.framework.ejb.AbstractEJBServiceHandler.invoke(AbstractEJBServiceHandler.java:34)
at $Proxy47.generateDaystat(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at nc.bs.framework.comn.serv.ServiceDispatcher.invokeBeanMethod(ServiceDispatcher.java:351)
at nc.bs.framework.comn.serv.ServiceDispatcher.execCall(ServiceDispatcher.java:160)
at nc.bs.framework.comn.serv.CommonServletDispatcher.doGet(CommonServletDispatcher.java:75)
at nc.bs.framework.comn.serv.CommonServletDispatcher.doPost(CommonServletDispatcher.java:95)
Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在