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 JULY 20, 2024

Applies to:

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:

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

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;

Changes

Applied Oct 2023 RU

Cause

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