почему то при запуске SA он не видит реальную таблицу inet_device_tree_20
Код:
connection 04-18/01:41:33 INFO [sa-p-11-t-50] TerminalServiceActivator - optionsDisable
connection 04-18/01:41:33 INFO [sa-p-11-t-50] TerminalServiceActivator - switchOptions
connection 04-18/01:41:33 INFO [sa-p-11-t-50] TerminalServiceActivator - serviceDisable
connection 04-18/01:41:33 INFO [sa-p-11-t-50] InetInterfaceMap - (Re)loading InetInterfaceMap
connection 04-18/01:41:33 INFO [sa-p-11-t-50] InetDeviceMap - (Re)loading InetDeviceMap
connection 04-18/01:41:33 ERROR [sa-p-11-t-50] AbstractEntityAttrDao - SELECT SQL_CALC_FOUND_ROWS invDevice.*, inet_device_tree.id as customId, inet_device_tree.parentId as customParentId, inet_device_tree.identifier as customIdentifier, inet_device_tree.deviceTypeId as customDeviceTypeId, inet_device_tree.host as customHost, inet_device_tree.config as customConfig, inet_device_tree.title as customTitle, entity.entitySpecId, entity.title as entityTitle FROM inet_device_tree
LEFT JOIN inv_device_0 as invDevice ON invDevice.id=inet_device_tree.invDeviceId LEFT JOIN entity ON entity.id=invDevice.entityId
WHERE (? OR invDevice.identifier LIKE ? OR inet_device_tree.identifier LIKE ?) AND (? OR invDevice.host LIKE ? OR inet_device_tree.host LIKE ?) AND ((? OR (invDevice.dateFrom IS NOT NULL AND invDevice.dateFrom>=?)) AND (? OR (invDevice.dateTo IS NOT NULL AND invDevice.dateTo<=?))) AND ((? OR invDevice.dateFrom IS NULL OR invDevice.dateFrom<=?) AND (? OR invDevice.dateTo IS NULL OR invDevice.dateTo>=?))
GROUP BY inet_device_tree.id
connection 04-18/01:41:33 ERROR [sa-p-11-t-50] EventWorker - Error on device:752 - ru.bitel.bgbilling.common.BGRuntimeException: ru.bitel.bgbilling.common.BGException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bgbilling.inet_device_tree' doesn't exist
ru.bitel.bgbilling.common.BGException: Error on device:752 - ru.bitel.bgbilling.common.BGRuntimeException: ru.bitel.bgbilling.common.BGException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bgbilling.inet_device_tree' doesn't exist
at ru.bitel.bgbilling.modules.inet.access.sa.ServiceActivatorDeviceWorker.doTask(ServiceActivatorDeviceWorker.java:504)
at ru.bitel.bgbilling.kernel.event.AsyncEventWorker.internalDoTaskImpl(AsyncEventWorker.java:211)
at ru.bitel.bgbilling.kernel.event.AsyncEventWorker.internalDoTask(AsyncEventWorker.java:183)
at ru.bitel.bgbilling.kernel.event.AsyncEventWorker.doTasks(AsyncEventWorker.java:109)
at ru.bitel.bgbilling.modules.inet.access.sa.ServiceActivatorDeviceWorker.runWorker(ServiceActivatorDeviceWorker.java:246)
at ru.bitel.bgbilling.kernel.event.EventWorker.internalRunWorker(EventWorker.java:142)
at ru.bitel.bgbilling.modules.inet.access.sa.ServiceActivatorDeviceWorker.runImpl(ServiceActivatorDeviceWorker.java:152)
at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:87)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:46)
Caused by: ru.bitel.bgbilling.common.BGRuntimeException: ru.bitel.bgbilling.common.BGException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bgbilling.inet_device_tree' doesn't exist
at ru.bitel.common.function.ThrowingSupplier.get(ThrowingSupplier.java:25)
at ru.bitel.common.function.Lazy.get(Lazy.java:49)
at ru.bitel.bgbilling.modules.inet.runtime.InetInterfaceMap.getInterfaceTitle(InetInterfaceMap.java:138)
at ru.bitel.bgbilling.modules.inet.dyn.device.terminal.TerminalServiceActivator.invoke(TerminalServiceActivator.java:1509)
at ru.bitel.bgbilling.modules.inet.dyn.device.terminal.TerminalServiceActivator.invoke(TerminalServiceActivator.java:1178)
at ru.bitel.bgbilling.modules.inet.dyn.device.terminal.TerminalServiceActivator$TGroovyMacro.invoke(TerminalServiceActivator.java:232)
at ru.bitel.common.groovy.GroovyMacro$MacroMetaClassDelegate.invokeMethod(GroovyMacro.java:241)
at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.callCurrent(PogoMetaClassSite.java:69)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:158)
at Script3$_run_closure1.doCall(Script3.groovy:1)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:93)
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:325)
at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:294)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1022)
at ru.bitel.common.groovy.MetaClassDelegate.invokeMethod(MetaClassDelegate.java:107)
at ru.bitel.common.groovy.GroovyMacro$MacroMetaClassDelegate.invokeMethod(GroovyMacro.java:236)
at groovy.lang.Closure.call(Closure.java:414)
at ru.bitel.common.groovy.GroovyMacro.eval(GroovyMacro.java:201)
at ru.bitel.bgbilling.modules.inet.dyn.device.terminal.TerminalServiceActivator.executeCommands(TerminalServiceActivator.java:674)
at ru.bitel.bgbilling.modules.inet.dyn.device.terminal.TerminalServiceActivator.executeCommands(TerminalServiceActivator.java:652)
at ru.bitel.bgbilling.modules.inet.dyn.device.terminal.TerminalServiceActivator.serviceCancel(TerminalServiceActivator.java:1941)
at ru.bitel.bgbilling.modules.inet.access.sa.ServiceActivatorSet.serviceCancel(ServiceActivatorSet.java:359)
at ru.bitel.bgbilling.modules.inet.access.sa.ServiceActivatorDeviceWorker.doCommand(ServiceActivatorDeviceWorker.java:557)
at ru.bitel.bgbilling.modules.inet.access.sa.ServiceActivatorDeviceWorker.doTask(ServiceActivatorDeviceWorker.java:500)
... 15 more
Caused by: ru.bitel.bgbilling.common.BGException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bgbilling.inet_device_tree' doesn't exist
at ru.bitel.oss.kernel.entity.server.bean.AbstractEntityAttrDao.listImpl(AbstractEntityAttrDao.java:863)
at ru.bitel.bgbilling.modules.inet.api.server.bean.InetDeviceDao0.list(InetDeviceDao0.java:254)
at ru.bitel.bgbilling.modules.inet.api.server.bean.InetDeviceDao0.list0(InetDeviceDao0.java:185)
at ru.bitel.bgbilling.modules.inet.api.server.bean.InetDeviceDao0.root(InetDeviceDao0.java:284)
at ru.bitel.bgbilling.modules.inet.api.server.bean.InetDeviceDao.root(InetDeviceDao.java:67)
at ru.bitel.bgbilling.modules.inet.api.server.bean.InetDeviceMap.load(InetDeviceMap.java:234)
at ru.bitel.bgbilling.modules.inet.api.server.bean.InetDeviceMap.getMap(InetDeviceMap.java:480)
at ru.bitel.bgbilling.modules.inet.runtime.InetInterfaceMap.loadImpl(InetInterfaceMap.java:198)
at ru.bitel.bgbilling.modules.inet.runtime.InetInterfaceMap.load(InetInterfaceMap.java:177)
at ru.bitel.bgbilling.modules.inet.runtime.InetInterfaceMap.lambda$new$0(InetInterfaceMap.java:111)
at ru.bitel.bgbilling.modules.inet.runtime.InetInterfaceMap$$Lambda$18/1890934602.getThrows(Unknown Source)
at ru.bitel.common.function.ThrowingSupplier.get(ThrowingSupplier.java:17)
... 42 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bgbilling.inet_device_tree' doesn't exist
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:404)
at com.mysql.jdbc.Util.getInstance(Util.java:387)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at ru.bitel.oss.kernel.entity.server.bean.AbstractEntityAttrDao.listImpl(AbstractEntityAttrDao.java:848)
... 53 more
Код:
Сервер: вер. 7.0.1358 / 13.04.2018 02:22:44
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_45
bill: вер. 7.0.137 / 13.04.2018 02:02:36
card: вер. 7.0.48 / 14.03.2018 16:03:03
dialup: вер. 7.0.325 / 14.03.2018 16:02:12
drweb: вер. 7.0.78 / 14.03.2018 16:03:36
inet: вер. 7.0.862 / 13.04.2018 20:29:15
ipn: вер. 7.0.277 / 21.03.2018 15:22:20
mps: вер. 7.0.226 / 14.03.2018 16:04:03
npay: вер. 7.0.214 / 14.03.2018 16:04:12
paymaster: вер. 7.0.68 / 14.03.2018 16:04:18
rentsoft: вер. 7.0.72 / 21.03.2018 15:22:51
reports: вер. 7.0.241 / 11.04.2018 21:18:23
rscm: вер. 7.0.189 / 14.03.2018 16:04:57
ru.bitel.bgbilling.plugins.bonus: вер. 7.0.134 / 14.03.2018 16:02:59
ru.bitel.bgbilling.plugins.crm: вер. 7.0.201 / 14.03.2018 16:03:34
ru.bitel.bgbilling.plugins.dispatch: вер. 7.0.98 / 14.03.2018 16:03:35
sberbank: вер. 7.0.81 / 21.03.2018 15:23:00
trayinfo: вер. 7.0.181 / 14.03.2018 16:05:14
tv: вер. 7.0.285 / 06.04.2018 18:39:42