forum.bitel.ru http://forum.bitel.ru/ |
|
Отчет Shturman_1. Ядро 3.75 http://forum.bitel.ru/viewtopic.php?f=12&t=67 |
Страница 1 из 1 |
Автор: | Shturman [ 26 янв 2007, 17:02 ] |
Заголовок сообщения: | Отчет Shturman_1. Ядро 3.75 |
отчет сообщает об ошибке, сообщение в server.out такое: SELECT contract.id, contract.title, contract.comment, account.sid, service.title, SUM(account.summa) FROM contract_account AS account LEFT JOIN contract ON account.cid=contract.id LEFT JOIN service ON account.sid=service.id WHERE contract.id IS NOT NULL AND account.yy=? AND account.mm=? AND account.sid IN (8:1048576:МБ;10:1048576:МБ;1:1048576:МБ;3:1048576:МБ;) AND (contract.gr&31)>0 GROUP BY account.cid, account.sid com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':1048576:??;10:1048576:??;1:1048576:??;3:1048576:??;) AND (contract.gr&31)>0 GR' at line 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3124) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205) at bitel.billing.server.reports.dialup.Report_Shturman_1.fillReportToStream(Report_Shturman_1.java:154) at bitel.billing.server.reports.action.ActionReport.doAction(ActionReport.java:56) at bitel.billing.server.Executer.doModule(Executer.java:542) at bitel.billing.server.Executer.doPost(Executer.java:120) at javax.servlet.http.HttpServlet.service(HttpServlet.java:615) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:822) at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:32) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:494) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569) at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at org.mortbay.http.HttpContext.handle(HttpContext.java:1434) at org.mortbay.http.HttpServer.service(HttpServer.java:896) at org.mortbay.http.HttpConnection.service(HttpConnection.java:814) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) конфигурация модуля: reports.shturman_1.sids=8:1048576:МБ;10:1048576:МБ;1:1048576:МБ;3:1048576:МБ; reports.shturman_1.addsids=8:1048576:МБ;10:1048576:МБ;1:1048576:МБ;3:1048576:МБ; |
Автор: | Amir [ 26 янв 2007, 17:40 ] |
Заголовок сообщения: | |
конфигурация модуля: reports.shturman_1.sids=8:1048576:МБ;10:1048576:МБ;1:1048576:МБ;3:1048576:МБ; reports.shturman_1.addsids= второй параметр это добавочные услуги для отбражения (например абон плата), т.е., например, =2,5,9. здесь (для параметра addsids) через запятую - в документации была опечатка. Если добавочных услуг для отображения нет, то оставьте этот параметр пустым. |
Автор: | Shturman [ 26 янв 2007, 17:58 ] |
Заголовок сообщения: | |
С тем разобрались. Бывает и в документации опечатка... теперь в логах такое: dori.jasper.engine.JRException: Errors were encountered when compiling report expressions class file: ---------- 1. WARNING in /usr/local/BGBillingServer/tmp/dialup_shturman_1.java (at line 25) private JRFillParameter parameter_REPORT_CONNECTION = null; ^^^^^^^^^^^^^^^^^^^^^^^^^^^ The field dialup_shturman_1.parameter_REPORT_CONNECTION is never read locally ---------- ---------- 2. WARNING in /usr/local/BGBillingServer/tmp/dialup_shturman_1.java (at line 26) private JRFillParameter parameter_REPORT_PARAMETERS_MAP = null; ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ The field dialup_shturman_1.parameter_REPORT_PARAMETERS_MAP is never read locally ---------- ---------- 3. WARNING in /usr/local/BGBillingServer/tmp/dialup_shturman_1.java (at line 28) private JRFillParameter parameter_REPORT_DATA_SOURCE = null; ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ The field dialup_shturman_1.parameter_REPORT_DATA_SOURCE is never read locally ---------- ---------- 4. WARNING in /usr/local/BGBillingServer/tmp/dialup_shturman_1.java (at line 30) private JRFillParameter parameter_REPORT_SCRIPTLET = null; ^^^^^^^^^^^^^^^^^^^^^^^^^^ The field dialup_shturman_1.parameter_REPORT_SCRIPTLET is never read locally ---------- ---------- 5. WARNING in /usr/local/BGBillingServer/tmp/dialup_shturman_1.java (at line 41) private JRFillVariable variable_COLUMN_NUMBER = null; ^^^^^^^^^^^^^^^^^^^^^^ The field dialup_shturman_1.variable_COLUMN_NUMBER is never read locally ---------- ---------- 6. WARNING in /usr/local/BGBillingServer/tmp/dialup_shturman_1.java (at line 42) private JRFillVariable variable_REPORT_COUNT = null; ^^^^^^^^^^^^^^^^^^^^^ The field dialup_shturman_1.variable_REPORT_COUNT is never read locally ---------- ---------- 7. WARNING in /usr/local/BGBillingServer/tmp/dialup_shturman_1.java (at line 43) private JRFillVariable variable_PAGE_COUNT = null; ^^^^^^^^^^^^^^^^^^^ The field dialup_shturman_1.variable_PAGE_COUNT is never read locally ---------- ---------- 8. WARNING in /usr/local/BGBillingServer/tmp/dialup_shturman_1.java (at line 46) private JRFillVariable variable_group_COUNT = null; ^^^^^^^^^^^^^^^^^^^^ The field dialup_shturman_1.variable_group_COUNT is never read locally ---------- ---------- 9. ERROR in /usr/local/BGBillingServer/tmp/dialup_shturman_1.java (at line 171) value = (java.lang.Integer)(0); ^^^^^^^^^^^^^^^^^^^^^^ Cannot cast from int to Integer ---------- 10. ERROR in /usr/local/BGBillingServer/tmp/dialup_shturman_1.java (at line 309) value = (java.lang.Integer)(0); ^^^^^^^^^^^^^^^^^^^^^^ Cannot cast from int to Integer ---------- 11. ERROR in /usr/local/BGBillingServer/tmp/dialup_shturman_1.java (at line 447) value = (java.lang.Integer)(0); ^^^^^^^^^^^^^^^^^^^^^^ Cannot cast from int to Integer ---------- 11 problems (3 errors, 8 warnings) at dori.jasper.engine.design.JRAbstractJavaCompiler.compileReport(JRAbstractJavaCompiler.java:155) at dori.jasper.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:137) at dori.jasper.engine.JasperCompileManager.compileReport(JasperCompileManager.java:199) at bitel.billing.server.reports.BGReport.getJasperReport(BGReport.java:52) at bitel.billing.server.reports.BGReport.fillReportToStream(BGReport.java:143) at bitel.billing.server.reports.dialup.Report_Shturman_1.fillReportToStream(Report_Shturman_1.java:246) at bitel.billing.server.reports.action.ActionReport.doAction(ActionReport.java:56) at bitel.billing.server.Executer.doModule(Executer.java:542) at bitel.billing.server.Executer.doPost(Executer.java:120) at javax.servlet.http.HttpServlet.service(HttpServlet.java:615) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:822) at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:32) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:494) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569) at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at org.mortbay.http.HttpContext.handle(HttpContext.java:1434) at org.mortbay.http.HttpServer.service(HttpServer.java:896) at org.mortbay.http.HttpConnection.service(HttpConnection.java:814) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) java.lang.NullPointerException at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:142) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:353) at dori.jasper.engine.JasperFillManager.fillReportToStream(JasperFillManager.java:323) at bitel.billing.server.reports.BGReport.fillReportToStream(BGReport.java:144) at bitel.billing.server.reports.dialup.Report_Shturman_1.fillReportToStream(Report_Shturman_1.java:246) at bitel.billing.server.reports.action.ActionReport.doAction(ActionReport.java:56) at bitel.billing.server.Executer.doModule(Executer.java:542) at bitel.billing.server.Executer.doPost(Executer.java:120) at javax.servlet.http.HttpServlet.service(HttpServlet.java:615) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:822) at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:32) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:494) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569) at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at org.mortbay.http.HttpContext.handle(HttpContext.java:1434) at org.mortbay.http.HttpServer.service(HttpServer.java:896) at org.mortbay.http.HttpConnection.service(HttpConnection.java:814) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) [root@gateway log]# cat server.out | less value = (java.lang.Integer)(0); ^^^^^^^^^^^^^^^^^^^^^^ Cannot cast from int to Integer ---------- 11. ERROR in /usr/local/BGBillingServer/tmp/dialup_shturman_1.java (at line 447) value = (java.lang.Integer)(0); ^^^^^^^^^^^^^^^^^^^^^^ Cannot cast from int to Integer ---------- 11 problems (3 errors, 8 warnings) at dori.jasper.engine.design.JRAbstractJavaCompiler.compileReport(JRAbstractJavaCompiler.java:155) at dori.jasper.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:137) at dori.jasper.engine.JasperCompileManager.compileReport(JasperCompileManager.java:199) at bitel.billing.server.reports.BGReport.getJasperReport(BGReport.java:52) at bitel.billing.server.reports.BGReport.fillReportToStream(BGReport.java:143) at bitel.billing.server.reports.dialup.Report_Shturman_1.fillReportToStream(Report_Shturman_1.java:246) at bitel.billing.server.reports.action.ActionReport.doAction(ActionReport.java:56) at bitel.billing.server.Executer.doModule(Executer.java:542) at bitel.billing.server.Executer.doPost(Executer.java:120) at javax.servlet.http.HttpServlet.service(HttpServlet.java:615) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:822) at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:32) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:494) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569) at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at org.mortbay.http.HttpContext.handle(HttpContext.java:1434) at org.mortbay.http.HttpServer.service(HttpServer.java:896) at org.mortbay.http.HttpConnection.service(HttpConnection.java:814) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) java.lang.NullPointerException at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:142) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:353) at dori.jasper.engine.JasperFillManager.fillReportToStream(JasperFillManager.java:323) at bitel.billing.server.reports.BGReport.fillReportToStream(BGReport.java:144) at bitel.billing.server.reports.dialup.Report_Shturman_1.fillReportToStream(Report_Shturman_1.java:246) at bitel.billing.server.reports.action.ActionReport.doAction(ActionReport.java:56) at bitel.billing.server.Executer.doModule(Executer.java:542) at bitel.billing.server.Executer.doPost(Executer.java:120) at javax.servlet.http.HttpServlet.service(HttpServlet.java:615) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:822) at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:32) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:494) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569) at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at org.mortbay.http.HttpContext.handle(HttpContext.java:1434) at org.mortbay.http.HttpServer.service(HttpServer.java:896) at org.mortbay.http.HttpConnection.service(HttpConnection.java:814) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) |
Автор: | Amir [ 26 янв 2007, 18:21 ] |
Заголовок сообщения: | |
Возможно у вас в переменных окружения прописан путь к старой версии Java. При компиляции отчета запускается javaс. javac -version должен выдавать javac 1.5... Похоже проблема именно в присутсвии старой версии - value = (java.lang.Integer)(0); ^^^^^^^^^^^^^^^^^^^^^^ Cannot cast from int to Integer с 1.5 Java научилась кастить с примитивных типов на объекты |
Страница 1 из 1 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |