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

[5.2] Column 'custom_value' cannot be null
http://forum.bitel.ru/viewtopic.php?f=22&t=6964		 Страница 1 из 1
Автор:  afedorov [ 12 июл 2012, 19:19 ]
Заголовок сообщения:  [5.2] Column 'custom_value' cannot be null
Цитата:
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'custom_value' cannot be null
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at com.mysql.jdbc.Util.getInstance(Util.java:386)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1339)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:825)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2345)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2330)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at bitel.billing.server.contract.bean.ContractParameterManager.updateListParam(ContractParameterManager.java:1227)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at bitel.billing.server.contract.action.ActionUpdateListParam.doAction(ActionUpdateListParam.java:46)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at bitel.billing.server.Executer.doModule(Unknown Source)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at bitel.billing.server.Executer$1.run(Unknown Source)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at java.security.AccessController.doPrivileged(Native Method)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at javax.security.auth.Subject.doAs(Subject.java:396)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at bitel.billing.server.Executer.doPost(Unknown Source)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:140)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
server 07-12/16:32:08 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - at java.lang.Thread.run(Thread.java:662)


Как пофиксить?
Автор:  Amir [ 12 июл 2012, 19:38 ]
Заголовок сообщения:  Re: [5.2] Column 'custom_value' cannot be null
Похоже что вызов действия был из старого клиента или еще откуда. Выложили обновление ядра, чтобы в этом случае нормально отрабатывало.
Перед обновлением сделайте бекап старых библиотек.
Автор:  dalfos [ 26 окт 2015, 22:01 ]
Заголовок сообщения:  Re: [5.2] Column 'custom_value' cannot be null
Добрый вечер.
Тестирую обновление с 5.2 на 6.0. При выполнении BGBS скрипта появилась ошибка.
Обновился дальше до 6.1, ошибка та же:

Цитата:
10-26/18:54:15 INFO [http-bio-0.0.0.0-8080-exec-5] ScriptEventListener - Caught event: ru.bitel.bgbilling.kernel.event.events.ContractParamBeforeChangeEvent
10-26/18:54:15 INFO [scrpt-evnt-lstnr-p-4-t-5] ScriptInstance - Invoke method Function [id:8; title:Тип тарифного плана] : onEvent
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'custom_value' cannot be null
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at com.mysql.jdbc.Util.getInstance(Util.java:384)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1363)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:829)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at ru.bitel.bgbilling.server.util.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:109)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at bitel.billing.server.contract.bean.ContractParameterManager.updateListParam(ContractParameterManager.java:1113)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at java.lang.reflect.Method.invoke(Method.java:601)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at bsh.Reflect.invokeMethod(Reflect.java:137)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at bsh.Reflect.invokeObjectMethod(Reflect.java:83)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at bsh.Name.invokeMethod(Name.java:858)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:75)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:102)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at bsh.BSHBlock.evalBlock(BSHBlock.java:131)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at bsh.BSHBlock.eval(BSHBlock.java:81)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at bsh.BshMethod.invokeImpl(BshMethod.java:362)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at bsh.BshMethod.invoke(BshMethod.java:258)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at bsh.BshMethod.invoke(BshMethod.java:186)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at bsh.This.invokeMethod(This.java:255)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at bsh.This.invokeMethod(This.java:174)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at ru.bitel.bgbilling.kernel.script.server.bean.ScriptInstance.invoke(ScriptInstance.java:390)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at ru.bitel.bgbilling.kernel.script.server.ScriptEventListener$Invoker.runScriptImpl(ScriptEventListener.java:116)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at ru.bitel.bgbilling.kernel.script.server.ScriptEventListener.runScript(ScriptEventListener.java:353)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at ru.bitel.bgbilling.kernel.script.server.ScriptEventListener$ThreadedScriptEventListener.access$0(ScriptEventListener.java:1)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at ru.bitel.bgbilling.kernel.script.server.ScriptEventListener$ThreadedScriptEventListener$1$1.run(ScriptEventListener.java:448)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at java.security.AccessController.doPrivileged(Native Method)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at javax.security.auth.Subject.doAs(Subject.java:415)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at ru.bitel.bgbilling.kernel.script.server.ScriptEventListener$ThreadedScriptEventListener$1.call(ScriptEventListener.java:442)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at java.util.concurrent.FutureTask.run(FutureTask.java:166)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at java.lang.Thread.run(Thread.java:722)
10-26/18:54:15 ERROR [scrpt-evnt-lstnr-p-4-t-5] LoggingPrintStream - at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:46)
10-26/18:54:15 INFO [http-bio-0.0.0.0-8080-exec-5] ScriptEventListener - Process time => 53
Автор:  Amir [ 26 окт 2015, 22:18 ]
Заголовок сообщения:  Re: [5.2] Column 'custom_value' cannot be null
Вам нужно в скрипте перед вызовом updateListParam() установить listParamValue.setCustomValue( "" );

Например,
Код:
ListParamValue listParamValue = new ListParamValue();
listParamValue.setId( value );
listParamValue.setCustomValue( "" );
new ContractParameterManager( con ).updateListParam( cid, pid, listParamValue, userID );
Автор:  dalfos [ 26 окт 2015, 22:53 ]
Заголовок сообщения:  Re: [5.2] Column 'custom_value' cannot be null
Спасибо, помогло!
Страница 1 из 1 Часовой пояс: UTC + 5 часов [ Летнее время ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/