ContractRemover cr = new ContractRemover( Setup.getSetup(), con, null );
 
   long timeStart = System.currentTimeMillis();
 
   query = "SELECT id FROM contract";
   ps  = con.prepareStatement( query );
   rs = ps.executeQuery();
 
   int count = 0;
   while ( rs.next() )
   {
      int cid = rs.getInt( 1 );
      if (cid == 1 || cid == 2 || cid == 3 || cid < 4 ) {
         error( "NOT REMOVED:" + cid );
      } else {
         error( "REMOVED:" + cid );
         cr.deleteContract( cid );
      }
      count ++;            
   }
   ps.close();
   
   error( "Removed " + count + " contracts.." );

07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at java.lang.Thread.run(Thread.java:636)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - Caused by: ru.bitel.bgbilling.common.BGException: ru.bitel.bgbilling.common.BGMessageException: ?????
????? ??????? ?????? ? ???????? ???????? ????????.
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEvent
Processor.java:181)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEvent
Processor.java:1)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.kernel.event.LocalEventProcessor.request(LocalEventProcessor.java:240)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     ... 59 more
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - Caused by: ru.bitel.bgbilling.common.BGMessageException: ?????????? ??????? ?????? ? ???????? ???????
? ????????.
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.modules.inet.api.server.service.InetServServiceImpl.inetServIsActive(InetSe
rvServiceImpl.java:749)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.modules.inet.api.server.service.InetServServiceImpl.inetServDelete(InetServ
ServiceImpl.java:781)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.modules.inet.api.server.Module.contractDelete(Module.java:431)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.modules.inet.api.server.Module.moduleAction(Module.java:169)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEvent
Processor.java:160)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     ... 61 more
07-02/17:39:01  INFO ["http-bio-/0.0.0.0-8080"-exec-9] CommonKernelEventProcessor - Process event cid:115975; event:Event[ru.bitel.bgbilling.kernel.event.events.system.ContractD
eleteEvent] moduleId: 0; pluginId: no; cid: 115975; scid: -1; userId: 0; timestamp: 1372757941047
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] CommonKernelEventProcessor - ?????????? ??????? ?????? ? ???????? ???????? ????????.
ru.bitel.bgbilling.common.BGMessageException: ?????????? ??????? ?????? ? ???????? ???????? ????????.
        at ru.bitel.bgbilling.modules.inet.api.server.service.InetServServiceImpl.inetServIsActive(InetServServiceImpl.java:749)
        at ru.bitel.bgbilling.modules.inet.api.server.service.InetServServiceImpl.inetServDelete(InetServServiceImpl.java:781)
        at ru.bitel.bgbilling.modules.inet.api.server.Module.contractDelete(Module.java:431)
        at ru.bitel.bgbilling.modules.inet.api.server.Module.moduleAction(Module.java:169)
        at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEventProcessor.java:160)
        at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEventProcessor.java:1)
        at ru.bitel.bgbilling.kernel.event.LocalEventProcessor.request(LocalEventProcessor.java:240)
        at ru.bitel.bgbilling.kernel.event.EventProcessor.request(EventProcessor.java:869)
        at ru.bitel.bgbilling.kernel.event.EventProcessor.request(EventProcessor.java:838)
        at bitel.billing.server.contract.ContractRemover.deleteContract(ContractRemover.java:231)
        at bitel.billing.server.contract.ContractRemover.deleteContract(ContractRemover.java:217)
        at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at bsh.Reflect.invokeMethod(Reflect.java:137)
        at bsh.Reflect.invokeObjectMethod(Reflect.java:83)
        at bsh.Name.invokeMethod(Name.java:858)
        at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:75)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:102)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
        at bsh.BSHBlock.evalBlock(BSHBlock.java:131)
        at bsh.BSHBlock.eval(BSHBlock.java:81)
        at bsh.BSHBlock.eval(BSHBlock.java:47)
        at bsh.BSHIfStatement.eval(BSHIfStatement.java:51)
        at bsh.BSHBlock.evalBlock(BSHBlock.java:131)
        at bsh.BSHBlock.eval(BSHBlock.java:81)
        at bsh.BSHBlock.eval(BSHBlock.java:47)
        at bsh.BSHWhileStatement.eval(BSHWhileStatement.java:72)
        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 ru.bitel.bgbilling.kernel.script.server.bean.ScriptInstance.invoke(ScriptInstance.java:385)
        at bitel.billing.server.script.global.bean.GlobalScriptMachine.runScriptImpl(GlobalScriptMachine.java:140)
        at bitel.billing.server.script.global.bean.GlobalScriptMachine.runScript(GlobalScriptMachine.java:73)
        at bitel.billing.server.script.global.bean.GlobalScriptManager.executeGlobalScript(GlobalScriptManager.java:40)
        at bitel.billing.server.script.global.action.ActionExecuteScript.doAction(ActionExecuteScript.java:32)
        at bitel.billing.server.Executer.doModule(Unknown Source)
        at bitel.billing.server.Executer$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:416)
        at bitel.billing.server.Executer.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:636)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - ru.bitel.bgbilling.kernel.event.EventProcessorException: ru.bitel.bgbilling.common.BGException: ru.bi
tel.bgbilling.common.BGMessageException: ?????????? ??????? ?????? ? ???????? ???????? ????????.
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.kernel.event.LocalEventProcessor.request(LocalEventProcessor.java:245)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.kernel.event.EventProcessor.request(EventProcessor.java:869)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.kernel.event.EventProcessor.request(EventProcessor.java:838)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bitel.billing.server.contract.ContractRemover.deleteContract(ContractRemover.java:231)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bitel.billing.server.contract.ContractRemover.deleteContract(ContractRemover.java:217)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at java.lang.reflect.Method.invoke(Method.java:616)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.Reflect.invokeMethod(Reflect.java:137)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.Reflect.invokeObjectMethod(Reflect.java:83)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.Name.invokeMethod(Name.java:858)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:75)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:102)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.BSHBlock.evalBlock(BSHBlock.java:131)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.BSHBlock.eval(BSHBlock.java:81)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.BSHBlock.eval(BSHBlock.java:47)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.BSHIfStatement.eval(BSHIfStatement.java:51)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.BSHBlock.evalBlock(BSHBlock.java:131)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.BSHBlock.eval(BSHBlock.java:81)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.BSHBlock.eval(BSHBlock.java:47)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.BSHWhileStatement.eval(BSHWhileStatement.java:72)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.BSHBlock.evalBlock(BSHBlock.java:131)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.BSHBlock.eval(BSHBlock.java:81)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.BshMethod.invokeImpl(BshMethod.java:362)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.BshMethod.invoke(BshMethod.java:258)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.BshMethod.invoke(BshMethod.java:186)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.This.invokeMethod(This.java:255)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bsh.This.invokeMethod(This.java:174)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.kernel.script.server.bean.ScriptInstance.invoke(ScriptInstance.java:385)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bitel.billing.server.script.global.bean.GlobalScriptMachine.runScriptImpl(GlobalScriptMachine.
java:140)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bitel.billing.server.script.global.bean.GlobalScriptMachine.runScript(GlobalScriptMachine.java
:73)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bitel.billing.server.script.global.bean.GlobalScriptManager.executeGlobalScript(GlobalScriptMa
nager.java:40)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bitel.billing.server.script.global.action.ActionExecuteScript.doAction(ActionExecuteScript.jav
a:32)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bitel.billing.server.Executer.doModule(Unknown Source)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bitel.billing.server.Executer$1.run(Unknown Source)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at java.security.AccessController.doPrivileged(Native Method)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at javax.security.auth.Subject.doAs(Subject.java:416)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bitel.billing.server.Executer.doPost(Unknown Source)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:3
04)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.ja
va:48)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:2
43)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:16
2)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at java.lang.Thread.run(Thread.java:636)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - Caused by: ru.bitel.bgbilling.common.BGException: ru.bitel.bgbilling.common.BGMessageException: ?????
????? ??????? ?????? ? ???????? ???????? ????????.
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEvent
Processor.java:181)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEvent
Processor.java:1)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.kernel.event.LocalEventProcessor.request(LocalEventProcessor.java:240)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     ... 59 more
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream - Caused by: ru.bitel.bgbilling.common.BGMessageException: ?????????? ??????? ?????? ? ???????? ???????
? ????????.
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.modules.inet.api.server.service.InetServServiceImpl.inetServIsActive(InetSe
rvServiceImpl.java:749)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.modules.inet.api.server.service.InetServServiceImpl.inetServDelete(InetServ
ServiceImpl.java:781)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.modules.inet.api.server.Module.contractDelete(Module.java:431)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.modules.inet.api.server.Module.moduleAction(Module.java:169)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEvent
Processor.java:160)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] LoggingPrintStream -     ... 61 more
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] script - Eval error: Typed variable declaration : Method Invocation cm.createFromPattern
Typed variable declaration : Method Invocation cm.createFromPattern : at Line: 570 : in file: CSVtoBGBilling2 : cm .createFromPattern ( patternId , title , TimeUtils .convertDat
eToCalendar ( curdate ) , password )

Called from method: main : at Line: -1 : in file: <Called from Java Code> : <Compiled Java Code>
Target exception: ru.bitel.bgbilling.common.BGMessageException: ??????? ? ????? ?????? ??? ??????????!

        at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:97)
        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.BSHBlock.eval(BSHBlock.java:47)
        at bsh.BSHForStatement.eval(BSHForStatement.java:111)
        at bsh.BSHBlock.evalBlock(BSHBlock.java:131)
        at bsh.BSHBlock.eval(BSHBlock.java:81)
        at bsh.BSHBlock.eval(BSHBlock.java:47)
        at bsh.BSHIfStatement.eval(BSHIfStatement.java:48)
        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.Name.invokeLocalMethod(Name.java:917)
        at bsh.Name.invokeMethod(Name.java:804)
        at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:75)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:102)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
        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 ru.bitel.bgbilling.kernel.script.server.bean.ScriptInstance.invoke(ScriptInstance.java:385)
        at bitel.billing.server.script.global.bean.GlobalScriptMachine.runScriptImpl(GlobalScriptMachine.java:140)
        at bitel.billing.server.script.global.bean.GlobalScriptMachine.runScript(GlobalScriptMachine.java:73)
        at bitel.billing.server.script.global.bean.GlobalScriptManager.executeGlobalScript(GlobalScriptManager.java:40)
        at bitel.billing.server.script.global.action.ActionExecuteScript.doAction(ActionExecuteScript.java:32)
        at bitel.billing.server.Executer.doModule(Unknown Source)
        at bitel.billing.server.Executer$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:416)
        at bitel.billing.server.Executer.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:636)
07-02/17:39:01 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] script - // Error: REMOVED:114949

SELECT id FROM contract WHERE id NOT IN (1,2,3)

for ( InetServ oldServ : wsServ.inetServList( cid ) )
         {            
            //во такой вот костыль чтобы удалить сервис, иначе не дает
            if ( oldServ.getDateTo() == null || TimeUtils.dateBefore(  now, oldServ.getDateTo() ) )
            {
               oldServ.setDateTo( TimeUtils.getPrevDay( now ) );
 
               try
                    {
                  //logger.info( "updating serv date for cid = " + cid );
                  wsServ.inetServUpdate( oldServ, new ArrayList<InetServOption>(), false, false, 0  );
                    }
                    catch( Exception e )
                    {
                       String message =  "Error while updating service date for contract " + cid + ":" + e.getMessage() ;
                       logger.error( message, e );
                       print( message );
                       //logger.error( "", e );
                       continue;
                    }
            }