My Oracle Support Banner

After Oct 2023 RU and Above: ORA-31934 Error Occurred While Shrinking The Materialized View Log At KkzlRunSA:prepare (Doc ID 2989060.1)

Last updated on FEBRUARY 25, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.21.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Env: DB 19.21


After patching the Database with the Oct 2023 RU, the following errors are logged in the Alert log during Materialized view refresh:

From trace file:

=====================
PARSE ERROR #139707998980496:len=102 dep=1 uid=0 oct=47 lid=0 tim=9081509786789 err=6550
begin sys.dbms_irefstats.run_sa(:1, :2, :3, :4, :5, :6); exception when others NULL; end;
kkzfThrowError: error_pos = kkzlRunSA:prepare errcode = 6550 msgbuf =ORA-06550: line 1, column 90:
PLS-00103: Encountered the symbol "NULL" when expecting one of the following:
then or
The symbol "then" was substituted for "NULL" to continue. ◄◄◄◄◄◄
*** 2023-11-17T20:49:44.221809+00:00 (CDB1_PDB1(3))
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
<error barrier> at 0x7ffde465bcd8 placed dbked.c@749
<error barrier> at 0x7ffde465c060 placed kse.c@2752
<error barrier> at 0x7ffde465c438 placed dbkda.c@336
ORA-31934: error occurred while shrinking the materialized view log at kkzlRunSA:prepare
ORA-06550: line 1, column 90:
PLS-00103: Encountered the symbol "NULL" when expecting one of the following:
then or
The symbol "then" was substituted for "NULL" to continue. ◄◄◄◄◄◄ Error was resolved
at kkzf.c@40356:kkzfThrowError
----- Current SQL Statement for this session (sql_id=cakhvykmuaz0n) -----
BEGIN dbms_mview.REFRESH ('TC.MVTEST', 'F'); END;

The error is getting resolved, and refresh and the mview log shrinking appear to be working fine.

Changes

Applied Oct 2023 RU

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
Changes
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.