Dell Security Management Server Fails to Export the Reports

Affected Products:

• Dell Security Management Server

Affected Versions:

• v10.x and Earlier

Affected Operating Systems:

• Windows

On the Dell Security Management Server, it is possible to generate and export different managed reports, by going to Reporting > Manage Reports:

To export a report, it is sufficient to select Export File and choose the format Excel or CSV:

Caution: Due to the size of the report and the number of endpoints, it is possible that while waiting for the report to be exported, after sixty seconds, the Dell Security Management Console will throw the error below and the export will fail:

Checking the Security Server Service logs in c:\Program Files\*** an error similar to the one below is reported at the time of the failure:

2020-12-07 12:07:56,350 ERROR com.dell.ddps.webui.controllers.ReportController [qtp1551039242-71115] - Timeout in webservice controller java.lang.IllegalStateException: WRITER
2020-12-07 12:07:56,351 ERROR com.dell.ddps.webui.controllers.ReportController [qtp1551039242-71115] - ServiceException thrown in webservice controller com.dell.ddps.webui.controllers.BaseWebUiController$LocalizedServiceException: The service did not respond in a timely manner.
2020-12-07 12:07:56,352 WARN org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver [qtp1551039242-71115] - Failed to invoke @ExceptionHandler method: public java.lang.Object com.dell.ddps.webui.controllers.BaseWebUiController.handleException(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,java.lang.Exception,java.util.Locale) java.lang.IllegalStateException: WRITER
2020-12-07 12:07:56,353 WARN org.eclipse.jetty.server.HttpChannel [qtp1551039242-71115] - /webui/exportToExcel javax.servlet.ServletException: org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.IllegalStateException: WRITER

The Denial of Service (DoS) filter terminates the server connection after 60 seconds.

To increase the DoS filter threshold, follow the below steps:

1. Using notepad, open the webdefault.xml, located in C:\Program Files\Dell\Enterprise Edition\Security Server\conf by default, and update the MaxRequestMs and maxIdleTrackerMs timeouts from 60000 to 300000:
   
2. After the values have been changed from 60000 to 300000, save the file and restart the Security Server Service. To restart the Security Server Service, follow the steps below:
3. Right click Start and select Run:
   
4. In the Run dialog window type services.msc, and press Enter or click OK:
   
5. Right click the Dell Security Server Service and select Restart: