Error in Defining Rule in AlarmTool

# 8 years ago
Ganesh	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 http://logback.qos.ch/codes.html#layoutInsteadOfEncoder 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 Attachments:

# 8 years ago

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 http://logback.qos.ch/codes.html#layoutInsteadOfEncoder 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

# 8 years ago
bchitalia2	Hi All Following error is coming while using alarmtool GUI 1. Rule creation error Cannot set rule to database Unknown column 'custom' in 'field list. 2. ./ AlarmManager 1 This read at the bottom of console INFO Thread-12-f.s.a.a.a.i.s.i.LocalManager.registerNewArchivers:105 - Register Archiver archiving/alarmdb/alarmdbarchiver.01_01 What does this mean ? Thanks and Regards Balkrishna

# 8 years ago
Sudeep	Hi Ganesh,Bala, Refer to this post by Katy to get updated version of AlarmTool and follow 'ReadMe.txt'. Hope this will help. Thank you. Sudeep Roy !!~Sudeep Roy~!!

# 8 years ago
Katy	Hello Ganesh, Are you succeed to install AlarmTool ? Let me know if not, I will help you. The database script delivered in the Archiving Package is wrong. So as Sudeep answer you please dowload the last standalone package https://svn.code.sf.net/p/tango-cs/code/archiving/tool/AlarmArchivingGUI/delivery/AlarmTool-1.1.7.zip Best regards, Katy