Error E040

Message

[DBC-E040] %s: [%s] Cannot execute AWR generation procedure [%s:%s]

Creating AWR reports failed with the given Oracle message. More debug info should be in the dbcollect.log file.

The most likely cause is not having EXECUTE privileges on the DBMS_WORKLOAD_REPOSITORY procedures.

Solution:

GRANT EXECUTE ON DBMS_WORKLOAD_REPOSITORY to