10个回答
wut 发表于 2018-10-9 14:20
就这个报错提示的话,是数据长度和精度的问题。最近任务修改是否有这方面的改动呢。 ...
QueryObj ERROR:/irpt/ei/../ei/webreportservice.do?service=edituserdata&taskid=%7BE7C4AAEF-4768-475A-8C16-62EC135B795D%7D.3e197e2c99653d20433b5ef95749779a&ds=main&bbq=201807--&bbh=11003&btype=0&upid=&curbbh=11003&curbtype=0&submit=true&save=true
java.lang.Exception: 保存用户(11003,0)201807--期的B0表的数据出错:
ORA-01438: 值大于为此列指定的允许精度
NextException:
ORA-01438: 值大于为此列指定的允许精度
at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10768)
at com.esen.jdbc.pool.PooledStatement.executeBatch(PooledStatement.java:216)
at com.esen.jdbc.pool.PooledPreparedStatement.executeBatch(PooledPreparedStatement.java:110)
at com.esen.i.db.ReportDb2.post(ReportDb2.java:128)
at com.esen.i.db.ReportDb2.postBatch(ReportDb2.java:91)
at com.esen.i.op.uploaddata.UploadData.afterReadALine(UploadData.java:550)
at com.esen.i.op.uploaddata.ReadUserData.readOneReportData(ReadUserData.java:190)
at com.esen.i.op.uploaddata.ReadUserData.readData(ReadUserData.java:81)
at com.esen.i.op.uploaddata.ReadUserData.loadFromUserData(ReadUserData.java:57)
at com.esen.i.op.uploaddata.UploadData.loadPackage(UploadData.java:274)
at com.esen.i.op.uploaddata.UploadData.loadUserData(UploadData.java:216)
at com.esen.i.op.uploaddata.SubmitDataProcessor.doProcess(SubmitDataProcessor.java:186)
at com.esen.i.webreport.service.EditDataService.uploadData(EditDataService.java:380)
at com.esen.i.webreport.service.EditDataService.service(EditDataService.java:200)
at com.esen.i.action.webreport.ActionWebReportService.jsexecute(ActionWebReportService.java:59)
at com.esen.weblib.action.Action_Js.execute(Action_Js.java:73)
at com.esen.i.action.webreport.ActionWebReportService.execute(ActionWebReportService.java:38)
at com.esen.weblib.action.Action.handle(Action.java:66)
at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at com.esen.platform.web.ReleasabledServlet.service(ReleasabledServlet.java:93)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.esen.platform.action.FilterLoginCheck.doFilter(FilterLoginCheck.java:95)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.esen.platform.web.PlatformLocaleContextFilter.doFilter(PlatformLocaleContextFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.esen.i.action.EsmainActionFilter.doFilter(EsmainActionFilter.java:42)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.esen.platform.sso.SSODelegatingFilter.doFilter(SSODelegatingFilter.java:43)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:744)
JavaScript StackTrace:
function _after_query_(queryObj, opt) {
try {
isRequest = false;
WebTask.showOrHideWaitMsg(false, opt.msg);// 首先隐藏等待框
var onfinish = opt.onfinish;
if (onfinish) {
queryObj.checkResult();
var qtext = queryObj.getResponseText(), qmsg = queryObj.getMessage();
queryObj.dispose(); // 回调前进行销毁,释放HTTP对象
onfinish(qtext, opt.userData, qmsg);
}
} catch (e) {
showError(e);
}
if (!isRequest) {
if (requestQueue.length) {
WebTask.request.apply(null, requestQueue.shift());
}
}
}
function(){this._lastReadyState=this.hp.readyState;if(this.hp.readyState==4){this._clearTimeoutTimer();if(this.hp.status==undefined||this.hp.status==0||this.hp.status>12000){if(this._retry()){return;}}var onfinish=this.onfinish;if(typeof(onfinish)=="function"){onfinish(this,this.userdata);}else{eval(onfinish);}if(this.autodispose){this.dispose();}}}
function(){j._onreadystatechange();}
wut 发表于 2018-10-9 14:20
就这个报错提示的话,是数据长度和精度的问题。最近任务修改是否有这方面的改动呢。 ...
上面是报错的详细信息,那我应该怎么解决呢,我已经把长度尽量都改到很大了
wut 发表于 2018-10-9 14:20
就这个报错提示的话,是数据长度和精度的问题。最近任务修改是否有这方面的改动呢。 ...
上面是报错的详细信息,那我应该怎么解决呢,我已经把长度尽量都改到很大了
已经本地复现问题,在持续跟进中,有最新进展会第一时间反馈,请耐心等待。
