Oracle Database 11g R2 -- ORA-15512: directory "string" does not contain a valid processed workload capture

Problem

While preprocessing workload with the DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE procedure you get error below:

ORA-15512: directory "CAPTURE_DIR" does not contain a valid processed workload capture
ORA-06512: at "SYS.DBMS_WORKLOAD_REPLAY", line 2014
ORA-06512: at line 1

You used workload capture in the exclusion mode with inclusive filters.

Solution

Check if any workload has been captured

SQL> select id, status, user_calls from DBA_WORKLOAD_CAPTURES;

        ID STATUS       USER_CALLS
---------- ------------ ----------
       212 COMPLETED             0

Workload might not be captured when either inclusive filters are not set up properly or capture process did not run sufficiently to capture any workload.

Check inclusive filters or let the capture to run enough time to capture any workload.