Proposed Solution 2: Resetting report data positions on systems using external database

Procedure

Log into Linux on the Primary EPM server as a user with root privileges.
To navigate to the appropriate directory, run the cd $AVAYA_HOME/Support/Security-Tools command.
To reset the report data position, run the ./ResetEmailSMSExtDB “<Database_URL>” <JDBC_Driver> <Database_User_Name> <Experience_Portal_Name> <Auxiliary_EPM_Name> command.
Where:
- “<Database_URL>” is the URL of the external database as it appears on the Report Database Settings page of the EPM Web interface.
  
  Important:
  
  Put quotation marks around the URL.
- <JDBC_Driver> is the JDBC driver for the external database as it appears on the Report Database Settings page of the EPM web interface.
- <Database_User_Name> is the user name for the external database as it appears on the Report Database Settings page of the EPM web interface.
- <Experience_Portal_Name> is the name of the Experience Portal system as it appears on the EPM Settings page of the EPM web interface.
- <Auxiliary_EPM_name> is the name of the Auxiliary EPM as it appears on the EPM Servers page of the EPM web interface.
Reboot the Primary EPM server.

	Important:
	Put quotation marks around the URL.