Compliance Reporter Returns Error Code 404 on a Dell Security Management Server and Virtual Server

Summary: In Dell Security Management Server Virtual and Security Management Server (formerly Dell Data Protection | Enterprise Edition and Virtual Edition) compliance reporter returns error code 404. ...

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

Note: Compliance Reporter is disabled by default on v10.1 and later.

Affected Products:

  • Dell Security Management Server Virtual
  • Dell Security Management Server
  • Dell Data Protection | Virtual Edition
  • Dell Data Protection | Enterprise Edition

Cause

Not Applicable

Resolution

In the logs for the server, you see errors similar to the below:

INFO | jvm 1 | 2016/08/02 16:55:24 | Caused by:
com.credant.serverrpt.dao.ManagerException: init: Table FOLDER not found; SQL statement:
INFO | jvm 1 | 2016/08/02 16:55:24 | SELECT folder_id, name, description, parent_id, owner_id FROM folder [42102-104]

OR

Caused by: com.credant.serverrpt.dao.ManagerException: init: General error: java.lang.RuntimeException: File ID mismatch got=265 expected=71 pos=1728 true org.h2.store.DiskFile:D:\Program Files\Dell\Enterprise Edition\Compliance Reporter\webapp\WEB-INF\reports\db\cmgreports.data.db blockCount:6; SQL statement: INFO | jvm 1 | 2016/08/02 16:40:40 | SELECT folder_id, name, description, parent_id, owner_id FROM folder [50000-104]

OR

ERROR com.credant.servergui.domain.FacadeImpl [http-8084-9] - Exception: error marshalling arguments; nested exception is:
java.io.NotSerializableException: com.credant.serverrpt.model.ReportUser

Preconditions:

  • Admin previously updated Dell Security Management Server Virtual (formerly Dell Data Protection | Virtual Edition)

Or

  • Admin restores from Dell Security Management Server Virtual.

Or

  • User customized Compliance Reporter prior to applying the Dell Security Management Server Virtual

Post-condition:

Upon startup of Compliance Reporter, a 404 error is generated due to irreconcilable data in the customization database.

Note: All Compliance Reporter customizations are lost during this procedure.

Corrective steps:

  • Dell Support or the Admin must log in as and perform the following actions:
  • Stop the Application using the UI.
  • Log in as ddpsupport.
  • Issue these six commands (they remove the user customizations to Compliance Reporter):
            sudo rm -f /opt/dell/server/reporter/webapp/WEB-INF/reports/db/cmgreports.XX.log.db
Note: XX changes for each server and we have to list the contents of the /opt/dell/server/reporter/webapp/WEB-INF/reports/db folder to find the name. 
            sudo rm -f /opt/dell/server/reporter/webapp/WEB-INF/reports/db/cmgreports.index.db
            sudo rm -f /opt/dell/server/reporter/webapp/WEB-INF/reports/db/cmgreports.lock.db
            sudo rm -f /opt/dell/server/reporter/webapp/WEB-INF/reports/db/cmgreports.trace.db
            sudo rm -f /opt/dell/server/reporter/output/*
            sudo cp /opt/dell/server/reporter/webapp/WEB-INF/reports/db/template/cmgreports.data.db /opt/dell/server/reporter/webapp/WEB-INF/reports/db/
  • Exit the shell and log in as ddpuser.
  • Start the Application using the UI.
Note: Updating to the most recent version (for example Dell Security Management Server Virtual v8.4.0) does not resolve the issue.

To resolve this issue in Dell Security Management Server (formerly Dell Data Protection | Enterprise Edition Server), follow the below steps:

Caution: This deletes any customization to the compliance reporter reports.
  1. Stop the Compliance Reporter service.
  2. Move all files within C:\Program Files\Dell\Enterprise Edition\Compliance Reporter\webapp\WEB-INF\reports\db to an archive folder.
  3. Copy the cmgreports.data file from within C:\Program Files\Dell\Enterprise Edition\Compliance Reporter\webapp\WEB-INF\reports\db\template to C:\Program Files\Dell\Enterprise Edition\Compliance Reporter\webapp\WEB-INF\reports\db.
  4. Move the contents of C:\Program Files\Dell\Enterprise Edition\Compliance Reporter\output to an archive folder.
  5. Start the Compliance Reporter Service.

To contact support, reference Dell Data Security International Support Phone Numbers.
Go to TechDirect to generate a technical support request online.
For additional insights and resources, join the Dell Security Community Forum.

Additional Information

Related Articles

How to configure Dell Data Protection Enterprise Edition and Virtual Edition Compliance Reporter

Affected Products

Dell Encryption
Article Properties
Article Number: 000130718
Article Type: Solution
Last Modified: 23 Jul 2024
Version:  11
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.