Dear All,
I am trying to gerenate alarm for a DevDouble variable x_test.
I defined the rule. It is evaluated successfully.
But getting prompt with error
Error 1: Cannot Set the rule to database Unknown column “custom” in the filed list. Please refer attach screen-shot.
Error 2: 20:43:00.733 ERROR SwingWorker-pool-2-thread-7-f.s.a.a.a.i.s.d.r.DbQueryTools.executeUpdate:151 - Cannot execute query : INSERT INTO rules (name,basicSeverity,reminderStateDelay,autoResetPeriod,description,dedicatedArchiver,textTalkerEnabled,textTalkerText,lastUpdate,custom) VALUES (?,?,?,?,?,?,?,?, Now() ,?) with param [rule4, 0, 0, 0, , NULL_STRING, false, NULL_STRING, false]
Please help me.
=========Here is the details==========================================
$ ./alarmtool
20:13:19,605 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [/home/750373/TANGO/ArchivingRoot-15.2.1/conf/linux/alarmtool-logback.xml]
20:13:19,605 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.groovy]
20:13:19,606 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.xml]
20:13:19,606 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found resource [logback.xml] at [jar:file:/home/750373/TANGO/ArchivingRoot-15.2.1/lib/java/fr.soleil.archiving.gui-AlarmArchivingGUI-1.1.5.jar!/logback.xml]
20:13:19,624 |-INFO in ch.qos.logback.core.joran.spi.ConfigurationWatchList@2e21712e - URL [jar:file:/home/750373/TANGO/ArchivingRoot-15.2.1/lib/java/fr.soleil.archiving.gui-AlarmArchivingGUI-1.1.5.jar!/logback.xml] is not of type file
20:13:19,676 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - debug attribute not set
20:13:19,680 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.ConsoleAppender]
20:13:19,690 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [CONSOLE]
20:13:19,786 |-WARN in ch.qos.logback.core.ConsoleAppender[CONSOLE] - This appender no longer admits a layout as a sub-component, set an encoder instead.
20:13:19,786 |-WARN in ch.qos.logback.core.ConsoleAppender[CONSOLE] - To ensure compatibility, wrapping your layout in LayoutWrappingEncoder.
20:13:19,786 |-WARN in ch.qos.logback.core.ConsoleAppender[CONSOLE] - See also Logback Error Codes for details
20:13:19,787 |-INFO in ch.qos.logback.core.joran.action.TimestampAction - Using current interpretation time, i.e. now, as time reference.
20:13:19,788 |-INFO in ch.qos.logback.core.joran.action.TimestampAction - Adding property to the context with key=“bySecond” and value=“20150606T201319” to the LOCAL scope
20:13:19,788 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.rolling.RollingFileAppender]
20:13:19,791 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [FILE]
20:13:19,816 |-INFO in ch.qos.logback.core.rolling.FixedWindowRollingPolicy@158d9aab - No compression will be used
20:13:19,831 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - Active log file name: /home/750373/logs/AlarmTool.log
20:13:19,831 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - File property is set to [/home/750373/logs/AlarmTool.log]
20:13:19,832 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [ch.qos.logback] to DEBUG
20:13:19,832 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [org.jacorb] to ERROR
20:13:19,833 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [org.tango] to ERROR
20:13:19,833 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [fr.soleil.archiving.alarm] to INFO
20:13:19,833 |-INFO in ch.qos.logback.classic.joran.action.RootLoggerAction - Setting level of ROOT logger to ERROR
20:13:19,833 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [CONSOLE] to Logger[ROOT]
20:13:19,834 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [FILE] to Logger[ROOT]
20:13:19,834 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration.
20:13:19,834 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@3a55b9b - Registering current configuration as safe fallback point
20:13:23.761 INFO AWT-EventQueue-0-f.s.archiving.alarm.gui.AlarmTools.createAndShowGUI:387 - User resources path is set to /home/750373/TANGO/AlarmPath
20:13:25.512 INFO AWT-EventQueue-0-f.s.a.alarm.api.FactoryProducer.initialize:318 - Starting factory initialization…
20:13:25.513 INFO AWT-EventQueue-0-f.s.a.alarm.api.FactoryProducer.getDefaultArchivingConfiguration:85 - No ArchiverMode in argument
20:13:25.514 INFO AWT-EventQueue-0-f.s.a.alarm.api.FactoryProducer.getDefaultArchivingConfiguration:102 - No StorageMode in argument
20:13:25.514 INFO AWT-EventQueue-0-f.s.a.alarm.api.FactoryProducer.getDefaultArchivingConfiguration:103 - StorageMode set to default database
20:13:25.515 INFO AWT-EventQueue-0-f.s.a.alarm.api.FactoryProducer.getDefaultArchivingConfiguration:116 - No CollectorMode in argument
20:13:25.515 INFO AWT-EventQueue-0-f.s.a.alarm.api.FactoryProducer.getDefaultArchivingConfiguration:117 - CollectorMode set to default tango
20:13:25.913 INFO AWT-EventQueue-0-f.s.a.alarm.api.FactoryProducer.initialize:344 - Create Manager service RemoteManager
20:13:25.915 INFO AWT-EventQueue-0-f.s.a.alarm.api.FactoryProducer.initialize:358 - Create Collector service TangoAttributeValuesCollector
20:13:26.043 INFO AWT-EventQueue-0-f.s.a.a.a.i.s.d.c.DatabaseConnection.setStorageInformation:130 - Connection information :
Connection driver : mysql
Database Scheme : alarmdb
Database User : root
Database Password : p@ssw0rd
Database Host : localhost
Database Name : alarmdb
20:13:26.659 INFO AWT-EventQueue-0-f.s.a.alarm.api.FactoryProducer.initialize:396 - Create Insertion service LocalAlarmDatabaseAccess
20:13:26.659 INFO AWT-EventQueue-0-f.s.a.alarm.api.FactoryProducer.initialize:400 - Create rule storage service DatabaseRuleStorage
20:13:26.660 INFO AWT-EventQueue-0-f.s.a.alarm.api.FactoryProducer.initialize:404 - Create alarm storage service DatabaseAlarmGroupStorage
20:13:26.675 INFO AWT-EventQueue-0-f.s.a.alarm.api.FactoryProducer.initialize:437 - Factory initialization done.
20:13:26.721 WARN AWT-EventQueue-0-f.s.a.alarm.gui.AlarmToolsPanel.init:302 - Problem loading settings file /home/750373/TANGO/AlarmPath/settings.xml. Using default settings
20:14:29.595 ERROR SwingWorker-pool-2-thread-2-f.s.a.a.a.i.s.d.r.DbQueryTools.executeUpdate:151 - Cannot execute query : INSERT INTO rules (name,basicSeverity,reminderStateDelay,autoResetPeriod,description,dedicatedArchiver,textTalkerEnabled,textTalkerText,lastUpdate,custom) VALUES (?,?,?,?,?,?,?,?, Now() ,?) with param [rule4, 0, 0, 0, , NULL_STRING, false, NULL_STRING, false]
20:14:41.012 ERROR SwingWorker-pool-2-thread-3-f.s.a.a.a.i.s.d.r.DbQueryTools.executeUpdate:151 - Cannot execute query : INSERT INTO rules (name,basicSeverity,reminderStateDelay,autoResetPeriod,description,dedicatedArchiver,textTalkerEnabled,textTalkerText,lastUpdate,custom) VALUES (?,?,?,?,?,?,?,?, Now() ,?) with param [rule4, 0, 0, 0, , NULL_STRING, false, NULL_STRING, false]
20:14:52.175 ERROR SwingWorker-pool-2-thread-4-f.s.a.a.a.i.s.d.r.DbQueryTools.executeUpdate:151 - Cannot execute query : INSERT INTO rules (name,basicSeverity,reminderStateDelay,autoResetPeriod,description,dedicatedArchiver,textTalkerEnabled,textTalkerText,lastUpdate,custom) VALUES (?,?,?,?,?,?,?,?, Now() ,?) with param [rule4, 0, 0, 0, , NULL_STRING, false, NULL_STRING, false]
20:39:36.597 ERROR SwingWorker-pool-2-thread-5-f.s.a.a.a.i.s.d.r.DbQueryTools.executeUpdate:151 - Cannot execute query : INSERT INTO rules (name,basicSeverity,reminderStateDelay,autoResetPeriod,description,dedicatedArchiver,textTalkerEnabled,textTalkerText,lastUpdate,custom) VALUES (?,?,?,?,?,?,?,?, Now() ,?) with param [rule4, 0, 0, 0, , NULL_STRING, false, NULL_STRING, false]
20:42:37.262 ERROR SwingWorker-pool-2-thread-6-f.s.a.a.a.i.s.d.r.DbQueryTools.executeUpdate:151 - Cannot execute query : INSERT INTO rules (name,basicSeverity,reminderStateDelay,autoResetPeriod,description,dedicatedArchiver,textTalkerEnabled,textTalkerText,lastUpdate,custom) VALUES (?,?,?,?,?,?,?,?, Now() ,?) with param [rule4, 0, 0, 0, , NULL_STRING, false, NULL_STRING, false]
20:43:00.733 ERROR SwingWorker-pool-2-thread-7-f.s.a.a.a.i.s.d.r.DbQueryTools.executeUpdate:151 - Cannot execute query : INSERT INTO rules (name,basicSeverity,reminderStateDelay,autoResetPeriod,description,dedicatedArchiver,textTalkerEnabled,textTalkerText,lastUpdate,custom) VALUES (?,?,?,?,?,?,?,?, Now() ,?) with param [rule4, 0, 0, 0, , NULL_STRING, false, NULL_STRING, false]
===========================================================
Thank you
Ganesh