Issue with comperhensive risk report

Updated: 21 May 2010 | 11 comments

0 0 Votes

Query Failed error come when comprehensive risk repot is run. It give below reasons.

This query could not be processed for one of the following reasons:

1. The database query timed out. Try reducing the number of filters, or increasing the SQL Server query timeout value.

2. An unexpected error occurred. Try running the query again by using default filter values.

3. String encoding was possibly not UTF-8, and may result from copying and pasting data instead of typing data. Try typing data in the input fields.

If i run comprehensive risk report with * in group box it work fine but if i select group name instead of * it gives query failed error. what could be possible reason.

Regrds
Hiren

query failed error1.JPG

discussion Filed Under:

Security, Endpoint Protection (AntiVirus) - 11.x, Endpoint Protection (AntiVirus), Reporting

Comments RSS Feed

Comments

Jul

2009

0 Votes 0

Prachand

Trusted Advisor

Which version of SEP is installed ?

"Query Failed" displays when exporting log data after sorting the Monitor Log reports by specific columns within the Symantec Endpoint Protection Manager console.

http://service1.symantec.com/SUPPORT/ent-security.nsf/docid/2008080608471048

This problem is fixed in Symantec Endpoint Protection 11 Maintenance Release (MR) 4. For information on how to obtain the latest build of Symantec Endpoint Protection, read Obtaining an upgrade or update for Symantec Endpoint Protection.
http://service1.symantec.com/SUPPORT/ent-security....

If the implementation of SEP 11 MR4 is not currently possible, the below steps can be used as a workaround:
Sort by one of the other non-affected column headers in the Computer Status or Scan Log reports.
Click export to receive the comma-delimited file with the expected data.

Prachand Kumar MCSE-2003 Symantec Technical Specialist (SCTS)

Jul

2009

0 Votes 0

kavin