Why are email notifications not being sent yet no error is reported?
If email notifications stop being sent without warning, the cause may be invalid SQL code contained in a new rule.
If a rule created in SilkCentral Issue Manager contains invalid
SQL statements, then it causes an exception which stops all other
notification triggers from working.
One example is if a column name is specified in SQL like
D.Product = SilkTest
D.Product = "SilkTest"
Then an exception will be reported. You can view this exception
ADMINISTRATION | REPORTS | FRONTENDSERVER LOG. The exception in the Frontend Server log will be similar to:
[DATE_TIME_STAMP];IM ;Thread-15;com.inet.tds.SQLException: Msg 207, Level 16, State 3, Line 1, Sqlstate S0022[MACHINE_NAME]Invalid column name "SilkTest".
Although general SQL syntax errors will be reported like:
[DATE_TIME_STAMP];IM ;Thread-15;com.inet.tds.SQLException: Msg 170, Level 15, State 1, Line 1, Sqlstate 01000 [MACHINE_NAME]Line 1: Incorrect syntax near "s".
To resolve this issue please check each rules SQL statement.
This issue has been resolved in SilkCentral Issue Manager