BiTel

03-17/05:26:39 ERROR ["http-bio-/0.0.0.0-8443"-exec-4] AbstractEntityAttrDao - SELECT SQL_CALC_FOUND_ROWS inet_device_10.*, entity.entitySpecId, entity.title as entityTitle FROM inet_device_10
LEFT JOIN entity ON entity.id=inet_device_10.entityId
LEFT JOIN inv_device_group_link_10 as deviceGroups ON deviceGroups.deviceId=inet_device_10.id
 WHERE (? OR identifier LIKE ?) AND (? OR host LIKE ?) AND (? OR deviceTypeId=?)
 GROUP BY inet_device_10.id
03-17/05:26:39 ERROR ["http-bio-/0.0.0.0-8443"-exec-4] AbstractJaxWsHandler - java.sql.SQLException: Column 'uptime' not found.
ru.bitel.bgbilling.common.BGException: java.sql.SQLException: Column 'uptime' not found.
        at ru.bitel.oss.kernel.entity.server.bean.AbstractEntityAttrDao.listImpl(AbstractEntityAttrDao.java:652)
        at ru.bitel.oss.kernel.entity.server.bean.AbstractEntityDao.list(AbstractEntityDao.java:190)
        at ru.bitel.oss.systems.inventory.resource.server.bean.DeviceDao.root(DeviceDao.java:211)
        at ru.bitel.oss.systems.inventory.resource.server.DeviceServiceImpl.deviceRoot(DeviceServiceImpl.java:106)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at ru.bitel.bgbilling.kernel.container.service.server.ServiceInfo.invoke(ServiceInfo.java:102)
        at ru.bitel.bgbilling.kernel.container.ws.server.AbstractJaxWsHandler.invoke(AbstractJaxWsHandler.java:202)
        at ru.bitel.bgbilling.kernel.container.ws.server.JaxWsHandler.access$1(JaxWsHandler.java:1)
        at ru.bitel.bgbilling.kernel.container.ws.server.JaxWsHandler$2.run(JaxWsHandler.java:338)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:396)
        at ru.bitel.bgbilling.kernel.container.ws.server.JaxWsHandler.invoke(JaxWsHandler.java:332)
        at ru.bitel.bgbilling.kernel.container.ws.server.AbstractJaxWsHandler$ServiceInstanceResolver$1.invoke(AbstractJaxWsHandler.java:314)
        at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:150)
        at com.sun.xml.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:261)
        at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:100)
        at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:641)
        at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:600)
        at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:585)
        at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:482)
        at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:314)
        at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:608)
        at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:259)
        at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:162)
        at ru.bitel.common.server.JaxWSAdapter.handle(JaxWSAdapter.java:396)
        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$Worker.runTask(ThreadPoolExecutor.java:895)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
        at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Column 'uptime' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
        at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5610)
        at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263)
        at ru.bitel.oss.systems.inventory.resource.server.bean.DeviceDao.getFromRSImpl(DeviceDao.java:76)
        at ru.bitel.oss.systems.inventory.resource.server.bean.DeviceDao.getFromRSImpl(DeviceDao.java:1)
        at ru.bitel.oss.kernel.entity.server.bean.AbstractEntityDao.getFromRS(AbstractEntityDao.java:244)
        at ru.bitel.oss.kernel.entity.server.bean.AbstractEntityDao.getFromRS(AbstractEntityDao.java:1)
        at ru.bitel.oss.kernel.entity.server.bean.AbstractEntityAttrDao.listImpl(AbstractEntityAttrDao.java:641)
        ... 49 more

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

  Сервер: вер. 6.0 сборка 1692 от 04.03.2014 22:47:26
    os: Linux; java: Java HotSpot(TM) Server VM, v.1.6.0_45

  inet вер. 6.0 сборка 1345 от 03.03.2014 14:26:07

03-17/16:46:02  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1060) Duplicate column name 'config'
03-17/16:46:03  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1146) Table 'bgbilling.connection_log_entry_11_201105' doesn't exist
03-17/16:46:03  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1146) Table 'bgbilling.connection_log_entry_11_201106' doesn't exist
03-17/16:46:03  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1054) Unknown column 'subsciberId' in 'inv_ip_resource_subscription_11'
03-17/16:46:03  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1060) Duplicate column name 'accessCode'
03-17/16:46:07  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1091) Can't DROP 'ipCategoryId'; check that column/key exists
03-17/16:46:07  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1060) Duplicate column name 'ipCategoryId'
03-17/16:46:07  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1054) Unknown column 'subcriberId' in 'inv_device_port_subscription_11'
03-17/16:46:07  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1054) Unknown column 'subcriberTitle' in 'inv_device_port_subscription_11'
03-17/16:46:25  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1060) Duplicate column name 'parentTypeIds'
03-17/16:46:26  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1060) Duplicate column name 'yy'
03-17/16:46:26  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1060) Duplicate column name 'yy'
03-17/16:46:27  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1060) Duplicate column name 'personalVlan'
03-17/16:46:27  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - Table 'bgbilling.inv_ip_resource_subscription_dyn_201112' doesn't exist
03-17/16:46:27  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - Table 'bgbilling.inv_ip_resource_subscription_dyn_11_201112' doesn't exist
03-17/16:46:27  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1054) Unknown column 'hour' in 'inet_task_process_11'
03-17/16:46:27  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1061) Duplicate key name 'sessionId'
03-17/16:46:27  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1061) Duplicate key name 'sessionId'
03-17/16:46:27  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1060) Duplicate column name 'comment'
03-17/16:46:35  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1146) Table 'bgbilling.inet_session_11_seq' doesn't exist
03-17/16:46:35  INFO ["http-bio-/0.0.0.0-8443"-exec-5] LoggingPrintStream - (1146) Table 'bgbilling.inet_connection_11_seq' doesn't exist
03-17/16:47:57  INFO ["http-bio-/0.0.0.0-8443"-exec-7] Setup - Load config for mid=11