forum.bitel.ru
http://forum.bitel.ru/

Не создается договор из шаблона
http://forum.bitel.ru/viewtopic.php?f=22&t=11441
Страница 1 из 1

Автор:  survivor [ 11 мар 2016, 14:58 ]
Заголовок сообщения:  Не создается договор из шаблона

Доброго дня.

Создал шаблон. При создании договора выбираю его и получаю ошибку:
Код:
Column 'title' cannot be null

Даже если отмечаю "Вручную" и пишу любое имя. Причем не важно что я указал в качестве "шаблона имени" в самом шаблоне.

Код:
Информация о версии:
  Сервер: вер. 6.2.1032 / 10.03.2016 15:09:06
    os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_73

  tv: вер. 6.2.208 / 10.03.2016 21:01:15


В server.error.log вывалилось:
Код:
server 03-11/12:47:08 ERROR [http-bio-0.0.0.0-8443-exec-8] CommonKernelEventProcessor - Column 'title' cannot be null [23000, 1048]
ru.bitel.bgbilling.common.BGException: Column 'title' cannot be null [23000, 1048]
        at ru.bitel.common.dao.AbstractDao.processException(AbstractDao.java:99)
        at ru.bitel.common.dao.AbstractDao.update(AbstractDao.java:587)
        at ru.bitel.common.dao.AbstractIdDao.getAndUpdate(AbstractIdDao.java:82)
        at ru.bitel.bgbilling.modules.tv.api.server.service.TvAccountServiceImpl.tvAccountUpdate(TvAccountServiceImpl.java:367)
        at ru.bitel.bgbilling.modules.tv.api.server.Module.contractCreate(Module.java:535)
        at ru.bitel.bgbilling.modules.tv.api.server.Module.moduleAction(Module.java:449)
        at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEventProcessor.java:166)
        at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEventProcessor.java:42)
        at ru.bitel.bgbilling.kernel.event.LocalEventProcessor.request(LocalEventProcessor.java:240)
        at ru.bitel.bgbilling.kernel.event.EventProcessor.request(EventProcessor.java:907)
        at ru.bitel.bgbilling.kernel.event.EventProcessor.request(EventProcessor.java:876)
        at bitel.billing.server.contract.bean.ContractManager.createFromPattern(ContractManager.java:403)
        at bitel.billing.server.contract.bean.ContractManager.createFromPattern(ContractManager.java:144)
        at bitel.billing.server.contract.bean.ContractManager.createFromPattern(ContractManager.java:122)
        at bitel.billing.server.contract.bean.ContractManager.createFromPattern(ContractManager.java:100)
        at bitel.billing.server.contract.action.ActionNewContract.doAction(ActionNewContract.java:78)
        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:50)
        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: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'title' cannot be null
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
        at com.mysql.jdbc.Util.getInstance(Util.java:384)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
        at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1363)
        at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:829)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at ru.bitel.bgbilling.modules.tv.api.server.bean.TvAccountDao.updateImpl(TvAccountDao.java:150)
        at ru.bitel.bgbilling.modules.tv.api.server.bean.TvAccountDao.updateImpl(TvAccountDao.java:20)
        at ru.bitel.common.dao.AbstractDao.update(AbstractDao.java:582)
        ... 41 more
server 03-11/12:47:08 ERROR [http-bio-0.0.0.0-8443-exec-8] ContractManager - ru.bitel.bgbilling.common.BGException: ru.bitel.bgbilling.common.BGException: Column 'title' cannot be null [23000, 1048]
ru.bitel.bgbilling.kernel.event.EventProcessorException: ru.bitel.bgbilling.common.BGException: ru.bitel.bgbilling.common.BGException: Column 'title' cannot be null [23000, 1048]
        at ru.bitel.bgbilling.kernel.event.LocalEventProcessor.request(LocalEventProcessor.java:245)
        at ru.bitel.bgbilling.kernel.event.EventProcessor.request(EventProcessor.java:907)
        at ru.bitel.bgbilling.kernel.event.EventProcessor.request(EventProcessor.java:876)
        at bitel.billing.server.contract.bean.ContractManager.createFromPattern(ContractManager.java:403)
        at bitel.billing.server.contract.bean.ContractManager.createFromPattern(ContractManager.java:144)
        at bitel.billing.server.contract.bean.ContractManager.createFromPattern(ContractManager.java:122)
        at bitel.billing.server.contract.bean.ContractManager.createFromPattern(ContractManager.java:100)
        at bitel.billing.server.contract.action.ActionNewContract.doAction(ActionNewContract.java:78)
        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:50)
        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: ru.bitel.bgbilling.common.BGException: ru.bitel.bgbilling.common.BGException: Column 'title' cannot be null [23000, 1048]
        at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEventProcessor.java:189)
        at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEventProcessor.java:42)
        at ru.bitel.bgbilling.kernel.event.LocalEventProcessor.request(LocalEventProcessor.java:240)
        ... 34 more
Caused by: ru.bitel.bgbilling.common.BGException: Column 'title' cannot be null [23000, 1048]
        at ru.bitel.common.dao.AbstractDao.processException(AbstractDao.java:99)
        at ru.bitel.common.dao.AbstractDao.update(AbstractDao.java:587)
        at ru.bitel.common.dao.AbstractIdDao.getAndUpdate(AbstractIdDao.java:82)
        at ru.bitel.bgbilling.modules.tv.api.server.service.TvAccountServiceImpl.tvAccountUpdate(TvAccountServiceImpl.java:367)
        at ru.bitel.bgbilling.modules.tv.api.server.Module.contractCreate(Module.java:535)
        at ru.bitel.bgbilling.modules.tv.api.server.Module.moduleAction(Module.java:449)
        at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEventProcessor.java:166)
        ... 36 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'title' cannot be null
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
        at com.mysql.jdbc.Util.getInstance(Util.java:384)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
        at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1363)
        at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:829)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at ru.bitel.bgbilling.modules.tv.api.server.bean.TvAccountDao.updateImpl(TvAccountDao.java:150)
        at ru.bitel.bgbilling.modules.tv.api.server.bean.TvAccountDao.updateImpl(TvAccountDao.java:20)
        at ru.bitel.common.dao.AbstractDao.update(AbstractDao.java:582)
        ... 41 more
server 03-11/12:47:08 ERROR [http-bio-0.0.0.0-8443-exec-8] CommonExecutor - ru.bitel.bgbilling.common.BGException: ru.bitel.bgbilling.common.BGException: Column 'title' cannot be null [23000, 1048]
ru.bitel.bgbilling.common.BGException: ru.bitel.bgbilling.common.BGException: ru.bitel.bgbilling.common.BGException: Column 'title' cannot be null [23000, 1048]
        at bitel.billing.server.contract.action.ActionNewContract.doAction(ActionNewContract.java:111)
        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:50)
        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)


Вложения:
Screenshot 2016-03-11 12.59.55.png
Screenshot 2016-03-11 12.59.55.png [ 14.79 КБ | Просмотров: 3191 ]

Автор:  dimOn [ 11 мар 2016, 19:28 ]
Заголовок сообщения:  Re: Не создается договор из шаблона

что-то помню исправляли недавно такое...

Автор:  Amir [ 11 мар 2016, 20:10 ]
Заголовок сообщения:  Re: Не создается договор из шаблона

Ошибка (вроде если поле login пустое). Исправим.

Автор:  survivor [ 16 мар 2016, 15:25 ]
Заголовок сообщения:  Re: Не создается договор из шаблона

Обновился до:

Цитата:
Информация о версии:

Клиент: вер. 6.2.806 / 11.03.2016 12:35:55
os: Mac OS X; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_66
Сервер: вер. 6.2.1033 / 11.03.2016 12:36:15
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_73

tv: вер. 6.2.208 / 10.03.2016 21:01:15

Окружение:

Клиент:
os: Mac OS X x86_64, 10.11.2
java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_66
jre home: /Library/Java/JavaVirtualMachines/jdk1.8.0_66.jdk/Contents/Home/jre
Сервер:
os: Linux amd64, 3.16.0-4-amd64
java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_73
jre home: /opt/java/jdk1.8.0_73/jre

но проблемка осталась :(
Без шаблонов очень плохо работать, почините плиииз

Автор:  Amir [ 16 мар 2016, 23:36 ]
Заголовок сообщения:  Re: Не создается договор из шаблона

Выложили обновление.

Автор:  survivor [ 17 мар 2016, 14:28 ]
Заголовок сообщения:  Re: Не создается договор из шаблона

все ok, спасибо!

Страница 1 из 1 Часовой пояс: UTC + 5 часов [ Летнее время ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/