Resetting report data positions using the local database

About this task

Use this procedure to reset report data positions in the local database after you run the restore scripts.

Although you must always run the script mentioned in this procedure on the primary EPM, you might need to run the script multiple times. You must specify different EPM names each time you restore the EPM. If you restore multiple EPMs, then you must run the script once for each of those EPM names.

	Note:
	If you do not run the script on the primary EPM, Experience Portal does not collect email and SMS report data from the primary or auxiliary EPM.

Procedure

Log on to Linux on the Experience Portal primary EPM server as a user with root privileges.
To navigate to the appropriate directory, run the cd $AVAYA_HOME/Support/VP-Tools command:
On the primary EPM, for each configured EPM name that has a SMS or Email processor, run the ./ResetEmailSMSLocalDB <EPM_Name> command.
Reboot the primary EPM server.