My Oracle Support Banner

"BIS Materialized View Refresh Program" Returns ORA-32319: Cannot Use Direct Loader Log for IBE_BI_CUSTTIME_MV (Doc ID 2109253.1)

Last updated on AUGUST 23, 2022

Applies to:

Oracle Web Analytics - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and data used represents fictitious

data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead,

is purely coincidental and not intended in any manner.

 

 

On Test: 12.1.3 version, Installation Issues

Incremental Data Load conc request fails due to error in "BIS Materialized View Refresh Program" concurrent request.

ERROR
-----------------------
ORA-32319: Cannot use direct loader log to FAST REFRESH materialized view "APPS"."IBE_BI_CUSTTIME_MV"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Incremental Load program
2. Check "BIS Materialized View Refresh Program" conc request in error state

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to use web analytics reports in Prod.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.