Support Center > Search Results > SecureKnowledge Details
"ERROR: column "dlp_violation" does not exist" when generating DLP report with a filter in SmartEvent
Symptoms
  • When generating DLP report with a filter in SmartEvent, the following error appears:

    Unable to complete generation for:  Section: 5. DLP User Actions by User Unit: 5.1 DLP User Actions by User
    Additional information:
    :ERROR:  column "dlp_violation" does not exist
    LINE 1: ..._VIEW ON (TEMP_VIEW.rowid=USERS_VIEW.eventid    , dlp_violat...
    
  • $RTDIR/log/SVRServer.log file shows:

    [Date Time][Generator] Unable to complete generation for:  Section: 5. DLP User Actions by User Unit: 5.1 DLP User Actions by User
    Additional information:
    [Date Time][Generator] :ERROR:  column "dlp_violation" does not exist
    LINE 1: ..._VIEW ON (TEMP_VIEW.rowid=USERS_VIEW.eventid    , dlp_violat...
                                                                 ^
    
    [Date Time][SVRServer] The Reporting Server denied the connection attempt of user USER_NAME.USER_LASTNAME on the IP_ADDRESS machine.
    
Cause

Misplaced closing ")" in thq query in $FWDIR/conf/reporting_unit_templates.C file. As a result, the dlp_violation section is a part of FROM section in the query, and not part of the JOIN USERS_VIEW ON (..) section.


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