|
楼主 |
发表于 2017-9-21 14:27:42
|
显示全部楼层
本帖最后由 忘了忘了 于 2017-9-21 14:31 编辑
如图
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.justep.system.action.Engine.invokeActions(Native Method)
at com.justep.system.action.Engine.invokeActions(Unknown Source)
at com.justep.business.server.BusinessServer.doAction(Unknown Source)
at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
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:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
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:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: select distinct A.fClassSign,count(*) as count1,A.fClassName,avg(A.fScore) as avgScore,A.fAcaScienceSub , concat(A.fAcaScienceSub,A.fCourse) as fCourse , A.fCourse as fCourse1 ,max(A.fScore) as maxScore,min(A.fScore) as minScore ,SUM(IF(A.fScore>=D.fFullMarks*0.6,1,0)) AS passAll ,cast(SUM(IF(A.fScore>=D.fFullMarks*0.6,1,0))/ COUNT(*)*100 as decimal(10,1)) AS passRate ,SUM(IF(A.fScore>=D.fFullMarks*0.8,1,0)) AS goodAll ,cast(SUM(IF(A.fScore>=D.fFullMarks*0.8,1,0))/ COUNT(*)*100 as decimal(10,1)) AS goodRate ,SUM(IF(A.fScore<=D.fFullMarks*0.3,1,0)) AS lowAll ,cast(SUM(IF(A.fScore<=D.fFullMarks*0.3,1,0))/ COUNT(*)*100 as decimal(10,1)) AS lowRate ,sum(if(A.fScore>=1 && A.fScore<D.fFullMarks*0.24 ,1,0)) as mini ,sum(if(A.fScore>=D.fFullMarks*0.24 && A.fScore<D.fFullMarks*0.5 ,1,0)) as verlow ,sum(if(A.fScore>=D.fFullMarks*0.5 && A.fScore<D.fFullMarks*0.7 ,1,0)) as passSc ,sum(if(A.fScore>=D.fFullMarks*0.7 && A.fScore<D.fFullMarks*0.84 ,1,0)) as passgood ,sum(if(A.fScore>=D.fFullMarks*0.84 && A.fScore<=D.fFullMarks ,1,0)) as moregood ,case when A.fTeacherName IS NULL then '' else A.fTeacherName end as fTeacherName from si_studentscore A left join kw01.kw_gradeexamsub D on D.fName = A.fCourse and A.fGrade = D.fGrade where A.fPlanID='4A5599C12D834BD7A0D4D22BA83EBB08' and A.fGrade='高三' and A.fScore<>-1 and A.fScore <> 0 group by A.fClassID,fCourse order by A.fCourseRecNo asc , binds: []出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.SQL.select(Unknown Source)
at com.justep.system.data.SQL.select(Unknown Source)
at GradeThree.mainScors(GradeThree.java:701)
at GradeThree.GEAllScore(GradeThree.java:332)
... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150204; 提示: 重复添加的列定义"fCourse"
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableMetaDataImpl.addColumnMetaData(Unknown Source)
at com.justep.system.data.impl.TableImpl.addColumns(Unknown Source)
at com.justep.system.data.impl.TableImpl.createTable(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.createTable(Unknown Source)
at com.justep.system.data.TableUtils.createTable(Unknown Source)
... 31 more
[ERROR] 2017-09-21 14:26:25,749 com.justep.report.controller.DataController - 报表数据获取失败
执行sql: select distinct A.fClassSign,count(*) as count1,A.fClassName,avg(A.fScore) as avgScore,A.fAcaScienceSub , concat(A.fAcaScienceSub,A.fCourse) as fCourse , A.fCourse as fCourse1 ,max(A.fScore) as maxScore,min(A.fScore) as minScore ,SUM(IF(A.fScore>=D.fFullMarks*0.6,1,0)) AS passAll ,cast(SUM(IF(A.fScore>=D.fFullMarks*0.6,1,0))/ COUNT(*)*100 as decimal(10,1)) AS passRate ,SUM(IF(A.fScore>=D.fFullMarks*0.8,1,0)) AS goodAll ,cast(SUM(IF(A.fScore>=D.fFullMarks*0.8,1,0))/ COUNT(*)*100 as decimal(10,1)) AS goodRate ,SUM(IF(A.fScore<=D.fFullMarks*0.3,1,0)) AS lowAll ,cast(SUM(IF(A.fScore<=D.fFullMarks*0.3,1,0))/ COUNT(*)*100 as decimal(10,1)) AS lowRate ,sum(if(A.fScore>=1 && A.fScore<D.fFullMarks*0.24 ,1,0)) as mini ,sum(if(A.fScore>=D.fFullMarks*0.24 && A.fScore<D.fFullMarks*0.5 ,1,0)) as verlow ,sum(if(A.fScore>=D.fFullMarks*0.5 && A.fScore<D.fFullMarks*0.7 ,1,0)) as passSc ,sum(if(A.fScore>=D.fFullMarks*0.7 && A.fScore<D.fFullMarks*0.84 ,1,0)) as passgood ,sum(if(A.fScore>=D.fFullMarks*0.84 && A.fScore<=D.fFullMarks ,1,0)) as moregood ,case when A.fTeacherName IS NULL then '' else A.fTeacherName end as fTeacherName from si_studentscore A left join kw01.kw_gradeexamsub D on D.fName = A.fCourse and A.fGrade = D.fGrade where A.fPlanID='4A5599C12D834BD7A0D4D22BA83EBB08' and A.fGrade='高三' and A.fScore<>-1 and A.fScore <> 0 group by A.fClassID,fCourse order by A.fCourseRecNo asc , binds: []出错
com.justep.report.exception.ReportServerException: 报表数据获取失败
at com.justep.report.controller.DataController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.controller.InitController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.Servlet.a(Unknown Source)
at com.justep.report.Servlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
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:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
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:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.report.exception.ReportServerException: 执行sql: select distinct A.fClassSign,count(*) as count1,A.fClassName,avg(A.fScore) as avgScore,A.fAcaScienceSub , concat(A.fAcaScienceSub,A.fCourse) as fCourse , A.fCourse as fCourse1 ,max(A.fScore) as maxScore,min(A.fScore) as minScore ,SUM(IF(A.fScore>=D.fFullMarks*0.6,1,0)) AS passAll ,cast(SUM(IF(A.fScore>=D.fFullMarks*0.6,1,0))/ COUNT(*)*100 as decimal(10,1)) AS passRate ,SUM(IF(A.fScore>=D.fFullMarks*0.8,1,0)) AS goodAll ,cast(SUM(IF(A.fScore>=D.fFullMarks*0.8,1,0))/ COUNT(*)*100 as decimal(10,1)) AS goodRate ,SUM(IF(A.fScore<=D.fFullMarks*0.3,1,0)) AS lowAll ,cast(SUM(IF(A.fScore<=D.fFullMarks*0.3,1,0))/ COUNT(*)*100 as decimal(10,1)) AS lowRate ,sum(if(A.fScore>=1 && A.fScore<D.fFullMarks*0.24 ,1,0)) as mini ,sum(if(A.fScore>=D.fFullMarks*0.24 && A.fScore<D.fFullMarks*0.5 ,1,0)) as verlow ,sum(if(A.fScore>=D.fFullMarks*0.5 && A.fScore<D.fFullMarks*0.7 ,1,0)) as passSc ,sum(if(A.fScore>=D.fFullMarks*0.7 && A.fScore<D.fFullMarks*0.84 ,1,0)) as passgood ,sum(if(A.fScore>=D.fFullMarks*0.84 && A.fScore<=D.fFullMarks ,1,0)) as moregood ,case when A.fTeacherName IS NULL then '' else A.fTeacherName end as fTeacherName from si_studentscore A left join kw01.kw_gradeexamsub D on D.fName = A.fCourse and A.fGrade = D.fGrade where A.fPlanID='4A5599C12D834BD7A0D4D22BA83EBB08' and A.fGrade='高三' and A.fScore<>-1 and A.fScore <> 0 group by A.fClassID,fCourse order by A.fCourseRecNo asc , binds: []出错
at com.justep.report.controller.DataController.a(Unknown Source)
at com.justep.report.controller.DataController.a(Unknown Source)
... 20 more
Caused by: java.lang.Exception
... 22 more
|
|