BiTel

отчет сообщает об ошибке, сообщение в 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:МБ;

конфигурация модуля:
reports.shturman_1.sids=8:1048576:МБ;10:1048576:МБ;1:1048576:МБ;3:1048576:МБ;
reports.shturman_1.addsids=

второй параметр это добавочные услуги для отбражения (например абон плата), т.е., например, =2,5,9. здесь (для параметра addsids) через запятую - в документации была опечатка.
Если добавочных услуг для отображения нет, то оставьте этот параметр пустым.

С тем разобрались. Бывает и в документации опечатка...
теперь в логах такое:
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)

Возможно у вас в переменных окружения прописан путь к старой версии Java. При компиляции отчета запускается javaс.
javac -version должен выдавать javac 1.5...

Похоже проблема именно в присутсвии старой версии -
value = (java.lang.Integer)(0);
^^^^^^^^^^^^^^^^^^^^^^
Cannot cast from int to Integer
с 1.5 Java научилась кастить с примитивных типов на объекты