Why are email notifications not being sent yet no error is reported?

0 Likes

Problem:

Why are email notifications not being sent yet no error is reported?

Resolution:

ANSWER
----------------------------------
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 this:

D.Product = SilkTest

Instead of:

D.Product = "SilkTest"

Then an exception will be reported. You can view this exception by choosing:
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 4.0.

Old KB# 23749
Comment List
Anonymous
Related Discussions
Recommended