javax.servlet.ServletException: 报表服务请求失败

li52618451

2013-09-09 14:32:05 开始编译Window: /UI/DBRS/politicalAdvice/process/anyanalyse/mainActivity.w
org.dom4j.DocumentException: Error on line 180 of document  : The content of elements must consist of well-formed character data or markup. Nested exception: The content of elements must consist of well-formed character data or markup.
at org.dom4j.io.SAXReader.read(SAXReader.java:482)
at org.dom4j.io.SAXReader.read(SAXReader.java:365)
at com.justep.xbl.report.Report.fileToDOM(Report.java:278)
at com.justep.xbl.report.Report.generateCacheChartReport(Report.java:205)
at com.justep.xbl.report.Report.execute(Report.java:81)
at com.justep.xbl.runtime.TemplateEngine.computeJavaTemplate(Unknown Source)
at com.justep.xbl.runtime.TemplateEngine.exeucte(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.parserBinding(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.excute(Unknown Source)
at com.justep.ui.util.UIUtils.xbl(Unknown Source)
at com.justep.ui.WindowCompiler.compile(Unknown Source)
at com.justep.ui.WindowServer.getWindow(Unknown Source)
at com.justep.ui.WindowServer.service(Unknown Source)
at com.justep.ui.servlet.MainServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
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:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
Nested exception:
org.xml.sax.SAXParseException: The content of elements must consist of well-formed character data or markup.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:236)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:215)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:386)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:316)
at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1441)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1723)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1242)
at org.dom4j.io.SAXReader.read(SAXReader.java:465)
at org.dom4j.io.SAXReader.read(SAXReader.java:365)
at com.justep.xbl.report.Report.fileToDOM(Report.java:278)
at com.justep.xbl.report.Report.generateCacheChartReport(Report.java:205)
at com.justep.xbl.report.Report.execute(Report.java:81)
at com.justep.xbl.runtime.TemplateEngine.computeJavaTemplate(Unknown Source)
at com.justep.xbl.runtime.TemplateEngine.exeucte(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.parserBinding(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.excute(Unknown Source)
at com.justep.ui.util.UIUtils.xbl(Unknown Source)
at com.justep.ui.WindowCompiler.compile(Unknown Source)
at com.justep.ui.WindowServer.getWindow(Unknown Source)
at com.justep.ui.WindowServer.service(Unknown Source)
at com.justep.ui.servlet.MainServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
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:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
Nested exception: org.xml.sax.SAXParseException: The content of elements must consist of well-formed character data or markup.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:236)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:215)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:386)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:316)
at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1441)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1723)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1242)
at org.dom4j.io.SAXReader.read(SAXReader.java:465)
at org.dom4j.io.SAXReader.read(SAXReader.java:365)
at com.justep.xbl.report.Report.fileToDOM(Report.java:278)
at com.justep.xbl.report.Report.generateCacheChartReport(Report.java:205)
at com.justep.xbl.report.Report.execute(Report.java:81)
at com.justep.xbl.runtime.TemplateEngine.computeJavaTemplate(Unknown Source)
at com.justep.xbl.runtime.TemplateEngine.exeucte(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.parserBinding(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
at com.justep.xbl.runtime.XBLEngine.excute(Unknown Source)
at com.justep.ui.util.UIUtils.xbl(Unknown Source)
at com.justep.ui.WindowCompiler.compile(Unknown Source)
at com.justep.ui.WindowServer.getWindow(Unknown Source)
at com.justep.ui.WindowServer.service(Unknown Source)
at com.justep.ui.servlet.MainServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
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:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
2013-09-09 14:32:05 结束编译Window: /UI/DBRS/politicalAdvice/process/anyanalyse/mainActivity.w

li52618451

求解决。。。。。。

li52618451

java代码如下
public static Table anyadivcequery(){
                String sql = "SELECT w2.*,qs.score AS score FROM (SELECT w1.adviceNo,w1.adviceTitle as title,w1.adviceTypeName as type,w1.cbcsname as cbcs,db.sName as tjname,(select TIMESTAMPDIFF(YEAR,db.sBirthday,SYSDATE()) FROM DUAL) as age,db.fReligionName as Religion,db.fTeamName as Team,db.fPartisanName as Partisan,db.sDegree as Degree,(select DATE_FORMAT(w1.submitTime,"%Y-%m-%d") from DUAL) as datas from (select rz.adviceNo,rz.adviceTypeName,rz.adviceTitle,rz.sLock,ry.cbcsname,ry.submitTime from rs_yzjy rz  LEFT JOIN rs_yjjb ry  on  rz.adviceNo=ry.adviceNo) w1 LEFT JOIN rs_dbrsxx db on w1.sLock=db.sLock) w2 LEFT JOIN rs_qscoresbase qs on qs.adviceNo=w2.adviceNo ";
                Map<String, String> sqlMap = new HashMap<String, String>();
                sqlMap.put("MYSQL", sql);
               
                return SQL.select(sqlMap, null, "/DBRS/politicalAdvice/data");
               
        }

zhaixin

把xls文件发过来

li52618451

是这个.w文件么？

zhaixin

发reports/mainActivity_groupReport.xls

li52618451

刚清理了下缓存下载错误是这样的。：

1 错误

devDebug true
2013-09-09 14:42:23 invokeActions error！
com.justep.model.exception.ModelException: java.lang.RuntimeException: compile error :
D:\ydcms\file\X5.2.4\model\BIZ\DBRS\politicalAdvice\logic\code\dsrc\PoliticalAdvice.java:158: 非法的表达式开始
                String sql = "SELECT w2.*,qs.score AS score FROM (SELECT w1.adviceNo,w1.adviceTitle as title,w1.adviceTypeName as type,w1.cbcsname as cbcs,db.sName as tjname,(select TIMESTAMPDIFF(YEAR,db.sBirthday,SYSDATE()) FROM DUAL) as age,db.fReligionName as Religion,db.fTeamName as Team,db.fPartisanName as Partisan,db.sDegree as Degree,(select DATE_FORMAT(w1.submitTime,"%Y-%m-%d") from DUAL) as datas from (select rz.adviceNo,rz.adviceTypeName,rz.adviceTitle,rz.sLock,ry.cbcsname,ry.submitTime from rs_yzjy rz  LEFT JOIN rs_yjjb ry  on  rz.adviceNo=ry.adviceNo) w1 LEFT JOIN rs_dbrsxx db on w1.sLock=db.sLock) w2 LEFT JOIN rs_qscoresbase qs on qs.adviceNo=w2.adviceNo ";
                                                                                                                                                                                                                                                                                                                                                                                             ^
1 错误

        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.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.RuntimeException: compile error :
D:\ydcms\file\X5.2.4\model\BIZ\DBRS\politicalAdvice\logic\code\dsrc\PoliticalAdvice.java:158: 非法的表达式开始
                String sql = "SELECT w2.*,qs.score AS score FROM (SELECT w1.adviceNo,w1.adviceTitle as title,w1.adviceTypeName as type,w1.cbcsname as cbcs,db.sName as tjname,(select TIMESTAMPDIFF(YEAR,db.sBirthday,SYSDATE()) FROM DUAL) as age,db.fReligionName as Religion,db.fTeamName as Team,db.fPartisanName as Partisan,db.sDegree as Degree,(select DATE_FORMAT(w1.submitTime,"%Y-%m-%d") from DUAL) as datas from (select rz.adviceNo,rz.adviceTypeName,rz.adviceTitle,rz.sLock,ry.cbcsname,ry.submitTime from rs_yzjy rz  LEFT JOIN rs_yjjb ry  on  rz.adviceNo=ry.adviceNo) w1 LEFT JOIN rs_dbrsxx db on w1.sLock=db.sLock) w2 LEFT JOIN rs_qscoresbase qs on qs.adviceNo=w2.adviceNo ";
                                                                                                                                                                                                                                                                                                                                                                                             ^
1 错误

        at com.justep.model.impl.ModelImpl$DynamicClassManager.compile(Unknown Source)
        at com.justep.model.impl.ModelImpl$DynamicClassManager.getDynamicClass(Unknown Source)
        at com.justep.model.impl.ModelImpl$DynamicClassManager.getDynamicMethod(Unknown Source)
        at com.justep.model.impl.ModelImpl.getModelMethod(Unknown Source)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        ... 21 more
2013-09-09 14:42:23 excute Action error:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="true" process="/DBRS/politicalAdvice/process/anyanalyse/anyanalyseProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="anyadivcequeryAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"></parameters></action>
com.justep.model.exception.ModelException: java.lang.RuntimeException: compile error :
D:\ydcms\file\X5.2.4\model\BIZ\DBRS\politicalAdvice\logic\code\dsrc\PoliticalAdvice.java:158: 非法的表达式开始
                String sql = "SELECT w2.*,qs.score AS score FROM (SELECT w1.adviceNo,w1.adviceTitle as title,w1.adviceTypeName as type,w1.cbcsname as cbcs,db.sName as tjname,(select TIMESTAMPDIFF(YEAR,db.sBirthday,SYSDATE()) FROM DUAL) as age,db.fReligionName as Religion,db.fTeamName as Team,db.fPartisanName as Partisan,db.sDegree as Degree,(select DATE_FORMAT(w1.submitTime,"%Y-%m-%d") from DUAL) as datas from (select rz.adviceNo,rz.adviceTypeName,rz.adviceTitle,rz.sLock,ry.cbcsname,ry.submitTime from rs_yzjy rz  LEFT JOIN rs_yjjb ry  on  rz.adviceNo=ry.adviceNo) w1 LEFT JOIN rs_dbrsxx db on w1.sLock=db.sLock) w2 LEFT JOIN rs_qscoresbase qs on qs.adviceNo=w2.adviceNo ";
                                                                                                                                                                                                                                                                                                                                                                                             ^
1 错误

li52618451

这个SQL语句我是直接复制的 Navicat 里面的
在navicat 里面没有错误

zhaixin

java文件编译错误，在D:\ydcms\file\X5.2.4\model\BIZ\DBRS\politicalAdvice\logic\code\dsrc\PoliticalAdvice.java上点右键，选择设置src dsrc目录为源码路径，看看是什么问题

li52618451

恩恩 找出来错误了。。。谢谢。。