Process Reporting Database fails with "The user name or password is incorrect."

Symptoms

Process Reporting Database task fails to complete. The exceptions list for the task in the SchedulerTasks log includes an error with content similar to the example below.
 
Error during process reporting database.
Internal error: The operation terminated unsuccessfully.
The following system error occurred:  The user name or password is incorrect.
Errors in the high-level relational engine. A connection could not be made to
the data source with the DataSourceID of 'ActiveNav4', Name of 'ActiveNav4'.
 
Cause

This error is typically seen if the service account username or password has been updated and the process for updating this information within the system configuration has not been completed.

It may also be observed if it has been necessary to rebuild the SSAS database, for example due to corruption, and the Data Source configuration has not been carried out correctly.

Resolution

The data source within the Active Navigation SSAS database must be configured with account details that allow access to the Active Navigation SQL database.

Please refer to the Knowledge Base article describing updating usernames, passwords, or rebuilding the SSAS database for details of how to correctly configure the data source.

Managing changes to Active Navigation and related service account passwords

Managing changes to the service accounts usernames

SSAS database corruption indicated in log files

Applies to

Active Navigation Discovery Center 4.x