Reports in progress state - InterScan Messaging Security Virtual Appliance (IMSVA)

"In progress" status of reports in InterScan Messaging Security Virtual Appliance (IMSVA)

- Updated:
- 10 Dec 2013
- Product/Version:
- InterScan Messaging Security Virtual Appliance 8.5
- Platform:
- N/A N/A

To resolve the issue:

Log in to IMSVA command line as a root user.
Run the following command to access the PostgreSQL database:
/opt/trend/imss/PostgreSQL/bin/psql imss sa
Run the commands below in the PostgreSQL:
1. DROP VIEW t_blockedip;
2. CREATE VIEW t_blockedip AS SELECT t_iprule."domain", t_messagesdropped.scanner_id, t_messagesdropped.upstreammta_ip AS ip, t_messagesdropped.recordtime AS createtime, t_messagesdropped."type", t_messagesdropped.count FROM (t_messagesdropped LEFT JOIN t_iprule ON (((ipint2string(t_messagesdropped.upstreammta_ip))::text = (ipint2string(t_iprule.ip))::text)));

Below is a sample output:

[root@IMSVA ~]# /opt/trend/imss/PostgreSQL/bin/psql imss sa
Welcome to psql 8.1.3, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

imss=# DROP VIEW t_blockedip;
DROP VIEW

imss=# CREATE VIEW t_blockedip AS SELECT t_iprule."domain", t_messagesdropped.scanner_id, t_messagesdropped.upstreammta_ip AS ip, t_messagesdropped.recordtime AS createtime, t_messagesdropped."type", t_messagesdropped.count FROM (t_messagesdropped LEFT JOIN t_iprule ON (((ipint2string(t_messagesdropped.upstreammta_ip))::text = (ipint2string(t_iprule.ip))::text)));
CREATE VIEW
imss=# \q
[root@IMSVA85 ~]#

Need More Help?

"In progress" status of reports in InterScan Messaging Security Virtual Appliance (IMSVA)