Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

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

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

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

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 19:38
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.