Support Center > Search Results > SecureKnowledge Details
Cannot generate reports in SmartEvent filtered on Service field
Symptoms
  • Report generation in SmartEvent with custom Service field filter (for example SMTP and POP3) fails with warning:
    "Unable to complete generation for:  Section: 1. List of All Events Unit: 1.1 List of All Events
    Additional information:
    :ERROR:  missing FROM-clause entry for table 'service'
    LINE 1: ...,4))) AND ((servicename IN('pop-3','smtp')) OR (((Service.PO...
    

Solution
Note: To view this solution you need to Sign In .