Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

"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
Summary
The IMSVA generated scheduled reports are stuck with "In progress" state.
Details
Public
To resolve the issue:
  1. Log in to IMSVA command line as a root user.
  2. Run the following command to access the PostgreSQL database:
    /opt/trend/imss/PostgreSQL/bin/psql imss sa
  3. 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 ~]#
Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
1101542
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.


Need More Help?

Create a technical support case if you need further support.