forum.bitel.ru http://forum.bitel.ru/ |
|
Не работают стандартные отчеты http://forum.bitel.ru/viewtopic.php?f=12&t=11920 |
Страница 1 из 1 |
Автор: | Che [ 10 сен 2016, 19:29 ] |
Заголовок сообщения: | Не работают стандартные отчеты |
Здравствуйте. Код: Информация о версии: Клиент: вер. 7.0.834 / 09.09.2016 13:06:09 os: Windows XP; java: Java HotSpot(TM) Client VM, v.1.8.0_31 Сервер: вер. 7.0.1103 / 09.09.2016 13:07:53 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_101 card: вер. 7.0.40 / 22.08.2016 16:40:03 inet: вер. 7.0.677 / 06.09.2016 19:06:54 mps: вер. 7.0.198 / 09.09.2016 13:08:12 npay: вер. 7.0.198 / 19.07.2016 18:37:21 reports: вер. 7.0.215 / 06.09.2016 17:39:00 ru.bitel.bgbilling.plugins.cashcheck: вер. 7.0.112 / 17.08.2016 16:36:28 Окружение: Клиент: os: Windows XP x86, 5.1 java: Java HotSpot(TM) Client VM, v.1.8.0_31 jre home: C:\Program Files\Java\jre1.8.0_31 default tz: 10.09.2016 16:28 MSK +0300 (Europe/Moscow) user tz: 10.09.2016 15:28 EET +0200 (Europe/Kaliningrad) locale: ru_RU Сервер: os: Linux amd64, 3.10.0-327.28.3.el7.x86_64 java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_101 jre home: /usr/java/jdk1.8.0_101/jre default tz: 10.09.2016 16:36 MSK +0300 (Europe/Moscow) db time: master: 10.09.2016 16:36 MSK db charset: connection: utf8(utf8_unicode_ci), database: utf8(utf8_unicode_ci) locale: ru_RU uptime: Started: 10.09.2016 01:06:10 Uptime: 0 d 15:30:46 Собственно говоря проблем с отчетами две. Первая. В клиенте не отображаются отчеты ядра, причем если сохранить в xls то все видно. В логах по этому поводу только Код: 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBandFactory - The 'isSplitAllowed' attribute is deprecated. Use the 'splitType' attribute instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'topBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'topBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'leftBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'leftBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'bottomBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'bottomBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'rightBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'rightBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRTextElementFactory - The 'lineSpacing' attribute is deprecated. Use the <paragraph> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'topBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'topBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'leftBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'leftBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'bottomBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'bottomBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'rightBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'rightBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRTextElementFactory - The 'lineSpacing' attribute is deprecated. Use the <paragraph> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'topBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'topBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'leftBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'leftBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'bottomBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'bottomBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'rightBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'rightBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRTextElementFactory - The 'lineSpacing' attribute is deprecated. Use the <paragraph> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBandFactory - The 'isSplitAllowed' attribute is deprecated. Use the 'splitType' attribute instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'topBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'topBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'leftBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'leftBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'bottomBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'bottomBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'rightBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'rightBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRTextElementFactory - The 'lineSpacing' attribute is deprecated. Use the <paragraph> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'topBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'topBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'leftBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'leftBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'bottomBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'bottomBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'rightBorder' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBoxFactory - The 'rightBorderColor' attribute is deprecated. Use the <pen> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRTextElementFactory - The 'lineSpacing' attribute is deprecated. Use the <paragraph> tag instead. 09-10/16:15:00 WARN [http-bio-0.0.0.0-8080-exec-7] JRBandFactory - The 'isSplitAllowed' attribute is deprecated. Use the 'splitType' attribute instead. вторая проблема с отчетами по модулю inet, при попытке сгенерировать отчет Код: java.lang.RuntimeException: Typed variable declaration : Attempt to resolve method: convertCalendarToSqlDate()
on undefined variable or class name: TimeUtils : at Line: 50 : in file: inline evaluation of: ``import java.sql.*; import java.util.*; import java.util.regex.*; import java.n . . . '' : TimeUtils .convertCalendarToSqlDate ( date ) Called from method: fillReport : at Line: -1 : in file: <Called from Java Code> : <Compiled Java Code> at bitel.billing.server.reports.BGCSVReport.getResult(BGCSVReport.java:181) at bitel.billing.server.reports.BGCSVReport.fillReportToStream(BGCSVReport.java:68) at bitel.billing.server.reports.action.ActionReport.doAction(ActionReport.java:59) at bitel.billing.server.Executer.doModule(SourceFile:600) at bitel.billing.server.Executer$1.run(SourceFile:199) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at bitel.billing.server.Executer.doPost(SourceFile:193) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at ru.bitel.common.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: Typed variable declaration : Attempt to resolve method: convertCalendarToSqlDate() on undefined variable or class name: TimeUtils : at Line: 50 : in file: inline evaluation of: ``import java.sql.*; import java.util.*; import java.util.regex.*; import java.n . . . '' : TimeUtils .convertCalendarToSqlDate ( date ) Called from method: fillReport : at Line: -1 : in file: <Called from Java Code> : <Compiled Java Code> at bsh.UtilEvalError.toEvalError(UtilEvalError.java:85) at bsh.UtilEvalError.toEvalError(UtilEvalError.java:90) at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:99) at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:102) at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47) at bsh.BSHArguments.getArguments(BSHArguments.java:65) at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:69) at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:102) at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47) at bsh.BSHVariableDeclarator.eval(BSHVariableDeclarator.java:86) at bsh.BSHTypedVariableDeclaration.eval(BSHTypedVariableDeclaration.java:84) at bsh.BSHBlock.evalBlock(BSHBlock.java:131) at bsh.BSHBlock.eval(BSHBlock.java:81) at bsh.BshMethod.invokeImpl(BshMethod.java:362) at bsh.BshMethod.invoke(BshMethod.java:258) at bsh.BshMethod.invoke(BshMethod.java:186) at bsh.This.invokeMethod(This.java:255) at bsh.This.invokeMethod(This.java:174) at bsh.XThis$Handler.invokeImpl(XThis.java:194) at bsh.XThis$Handler.invoke(XThis.java:131) at com.sun.proxy.$Proxy98.fillReport(Unknown Source) at bitel.billing.server.reports.BGCSVReport.getResult(BGCSVReport.java:175) ... 29 more |
Автор: | stark [ 13 сен 2016, 17:45 ] |
Заголовок сообщения: | Re: Не работают стандартные отчеты |
Исправлено, в следующем обновлении будет. |
Автор: | Brodayga [ 14 сен 2016, 14:40 ] |
Заголовок сообщения: | Re: Не работают стандартные отчеты |
Если не отображаются скорее всего необходимо установить mscorefonts. для centos например отсюда https://sourceforge.net/projects/mscorefonts2/files/?source=directory |
Автор: | Che [ 14 сен 2016, 19:53 ] |
Заголовок сообщения: | Re: Не работают стандартные отчеты |
Спасибо |
Автор: | Cobra57 [ 26 сен 2016, 16:56 ] |
Заголовок сообщения: | Re: Не работают стандартные отчеты |
Есть тоже проблема со стандартными отчетами. Проблемы появились при переходе на версию 7.0 Конкретно: Основной модуль -> Отчет по должникам Выдает ошибку: Код: Attempt to resolve method: convertCalendarToSqlDate() on undefined variable or class name: TimeUtils : at Line: 32 : in file: inline evaluation of: ``import java.sql.*; import java.util.*; import java.util.regex.*; import java.sql . . . '' : TimeUtils .convertCalendarToSqlDate ( month ) Called from method: fillReport : at Line: -1 : in file: <Called from Java Code> : <Compiled Java Code> at bsh.UtilEvalError.toEvalError(UtilEvalError.java:85) at bsh.UtilEvalError.toEvalError(UtilEvalError.java:90) at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:99) at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:102) at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47) at bsh.BSHAssignment.eval(BSHAssignment.java:77) at bsh.BSHBlock.evalBlock(BSHBlock.java:131) at bsh.BSHBlock.eval(BSHBlock.java:81) at bsh.BshMethod.invokeImpl(BshMethod.java:362) at bsh.BshMethod.invoke(BshMethod.java:258) at bsh.BshMethod.invoke(BshMethod.java:186) at bsh.This.invokeMethod(This.java:255) at bsh.This.invokeMethod(This.java:174) at bitel.billing.server.admin.reports.BGReportTemplate.processQuery(BGReportTemplate.java:443) at bitel.billing.server.admin.reports.BGReportTemplate.processReport(BGReportTemplate.java:418) at bitel.billing.server.admin.reports.BGReportTemplate.fillReportToStream(BGReportTemplate.java:315) at bitel.billing.server.admin.reports.BGReportTemplate.fillReportToStream(BGReportTemplate.java:402) at bitel.billing.server.reports.Report_Default.fillReportToStream(Report_Default.java:30) at bitel.billing.server.reports.action.ActionReport.doAction(ActionReport.java:59) at bitel.billing.server.Executer.doModule(SourceFile:600) at bitel.billing.server.Executer$1.run(SourceFile:199) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at bitel.billing.server.Executer.doPost(SourceFile:193) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at ru.bitel.common.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Версия биллинга: Код: Информация о версии:
Клиент: вер. 7.0.836 / 15.09.2016 16:44:58 os: Windows 7; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_51 Сервер: вер. 7.0.1109 / 16.09.2016 17:35:27 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_102 bill: вер. 7.0.93 / 15.09.2016 16:47:16 card: вер. 7.0.40 / 22.08.2016 16:40:03 dba: вер. 7.0.167 / 08.04.2016 17:40:39 dialup: вер. 7.0.319 / 29.08.2016 16:38:40 email: вер. 7.0.180 / 25.05.2016 13:53:19 inet: вер. 7.0.679 / 15.09.2016 16:46:50 ipn: вер. 7.0.258 / 01.09.2016 18:14:39 mps: вер. 7.0.199 / 13.09.2016 16:58:16 npay: вер. 7.0.198 / 19.07.2016 18:37:21 phone: вер. 7.0.276 / 13.09.2016 12:44:51 reports: вер. 7.0.216 / 13.09.2016 16:58:32 rscm: вер. 7.0.180 / 10.06.2016 17:00:08 ru.bitel.bgbilling.plugins.crm: вер. 7.0.194 / 31.05.2016 15:00:38 ru.bitel.bgbilling.plugins.documents: вер. 7.0.174 / 13.07.2016 16:19:37 ru.bitel.bgbilling.plugins.helpdesk: вер. 7.0.190 / 29.08.2016 16:32:16 rurupay: вер. 7.0.34 / 16.09.2016 16:50:40 voiceip: вер. 7.0.189 / 08.04.2016 17:40:15 Окружение: Клиент: os: Windows 7 amd64, 6.1 java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_51 jre home: C:\Program Files\Java\jre1.8.0_51 default tz: 26.09.2016 13:56 MSK +0300 (Europe/Moscow) user tz: 26.09.2016 12:56 EET +0200 (Europe/Kaliningrad) locale: ru_RU Сервер: os: Linux amd64, 3.2.0-4-amd64 java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_102 jre home: /opt/java/jdk1.8.0_102/jre default tz: 26.09.2016 13:55 MSK +0300 (Europe/Moscow) db time: master: 26.09.2016 13:55 MSK db charset: connection: cp1251(cp1251_general_ci), database: cp1251(cp1251_general_ci) locale: ru_RU uptime: Started: 16.09.2016 19:34:25 Uptime: 9 d 18:21:04 |
Автор: | dimOn [ 26 сен 2016, 17:14 ] |
Заголовок сообщения: | Re: Не работают стандартные отчеты |
исправлено, обновление будет вскоре |
Страница 1 из 1 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |