Webarchive error "ORA-00904: ALLTYPEMESSAGEDATE: invalid identifier" when the "All Channels" report limited to one channel

Products

• Data Loss Prevention

Issue/Introduction

Webarchive error "ORA-00904: ALLTYPEMESSAGEDATE: invalid identifier" when the "All Channels" report limited to one channel

Environment

Must be upgraded to 16.0.1

Cause

If DLP is upgraded from 15.8 to 16.01, Web Archive fails with the following error:

Web Archive failed.

In logs we see:

Thread: 141 SEVERE [com.vontu.condition.sql.query.Query] Failed DB query=SELECT 
    i.incidentID incidentID, i.policyGroupID policyGroupID, ms.networkSenderIdentifier networkSenderIdentifier, m.messageSubject messageSubject, m.channelsubtype channelsubtype,
    i.messageType messageTypeID, p.name policyName, p.label policyLabel, i.violationCount matchCount, i.messageDate messageDate,
    i.blockedStatus blockedStatus, istat.name incidentStatusName, i.incidentSeverityID severityID, m.messageID messageID,
    i.dataOwnerEmailID dataOwnerEmailID,
    CASE WHEN m.hasAttachment = 'Y' THEN 'yes' ELSE 'no' END hasAttachment
   FROM 
   Incident i, Message m, Policy p, MessageOriginator ms, IncidentStatus istat
   WHERE 
   i.policyID = p.policyID
   AND i.messageID = m.messageID
   AND m.messageOriginatorID = ms.messageOriginatorID
   AND i.incidentStatusID = istat.incidentStatusID
         AND (i.isDeleted = 0) AND ((i.messageSource = 'NETWORK') AND ((i.messageType NOT IN (48, 49) OR i.messageType IS NULL)) AND ((i.incidentStatusID IS NOT NULL) AND (i.messageDate BETWEEN {ts '2023-06-07 00:00:00.0'} AND {ts '2024-01-10 23:59:59.999'}) AND (i.shouldHideFromReports = 0))) ORDER BY allTypeMessageDate DESC, incidentID DESC
13 Feb 2024 15:49:19,665- Thread: 141 SEVERE [com.vontu.manager.report] Error exporting the report.
Cause:
java.security.PrivilegedActionExceptionjava.security.PrivilegedActionException: com.vontu.manager.ProtectManagerException: Error exporting report for action {0}
    at java.security.AccessController.doPrivileged(Native Method)
    at javax.security.auth.Subject.doAsPrivileged(Subject.java:549)
    at com.vontu.manager.report.export.ExportIncidentsThread.run(ExportIncidentsThread.java:75)
    at java.lang.Thread.run(Thread.java:750)
Caused by: com.vontu.manager.ProtectManagerException: Error exporting report for action {0}
    at com.vontu.manager.report.export.PageExporter.export(PageExporter.java:85)
    at com.vontu.manager.report.export.ReportExporter.exportIncidentList(ReportExporter.java:194)
    at com.vontu.manager.report.export.ReportExporter.exportAll(ReportExporter.java:183)
    at com.vontu.manager.report.export.ReportExporter.export(ReportExporter.java:163)
    at com.vontu.manager.report.export.ExportIncidentsThread$1.run(ExportIncidentsThread.java:79)
    ... 4 more
Caused by: com.vontu.util.jdbc.DatabaseRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00904: "ALLTYPEMESSAGEDATE": invalid identifier

Resolution

This issue has been resolved in 16.0 RU2.

Workarounds:

1]Avoid using the "All Channels" report. Instead, filter it down to a single channel, such as "Network."
2]Alternatively, edit the "All Channels" report, sort it by date, and save the changes again.