Materialized Views Refresh fails With ORA-01403: No Data Found After Upgrade To 19C (Doc ID 2895541.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

BEGIN DBMS_MVIEW.refresh('<<<>>>>>'); END;
Error at line 1
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3020
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 347
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2893
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3263
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3295
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 16
ORA-06512: at line 1

From the trace file:

PARSING IN CURSOR #140466823891584 len=79 dep=1 uid=0 oct=3 lid=0 tim=2535446085176 hv=276141043 ad='4bf716d38' sqlid='7n63dq887b4zm'

SELECT COLLECTION_LEVEL FROM SYS.MVREF$_STATS_SYS_DEFAULTS FETCH FIRST ROW ONLY ◄◄◄◄◄◄

END OF STMT

STAT #140466823891584 id=3 cnt=0 pid=2 pos=1 obj=7110197 op='TABLE ACCESS FULL MVREF$_STATS_SYS_DEFAULTS (cr=3 pr=0 pw=0 str=1 time=34 us cost=2 size=13 card=1)'

STACK TARCE

<strong>ksedst1</strong> <- ksedst <- <strong>dbkedDefDump</strong> <- ksedmp <- <strong>dbkdaKsdActDriver</strong>
        <- <strong>dbgdaExecuteAction</strong> <- <strong>dbgdaRunAction</strong> <- <strong>dbgdRunActions</strong> <- <strong>dbgdProcessEventAct</strong> <- <strong>ions</strong>
         <- <strong>dbgdChkEventKgErr</strong> <- <strong>dbkdChkEventRdbmsEr</strong> <- <strong>dbgePostErrorKGE</strong> <- <strong>1066</strong> <- <strong>dbkePostKGE_kgsf</strong>
          <- <strong>kgeade</strong> <- <strong>kgeselv</strong> <- <strong>ksesecl0</strong> <- <strong>psddr0</strong> <- <strong>psdnal</strong>
           <- <strong>pevm_EXECC</strong> <- <strong>pfrinstr_EXECC</strong> <- <strong>pfrrun_no_tool</strong> <- <strong>pfrrun</strong> <- <strong>plsql_run</strong>
            <- <strong>peicnt</strong> <- <strong>kkxexe</strong> <- <strong>opiexe</strong> <- <strong>kpoal8</strong> <- <strong>opiodr</strong>
             <- <strong>ttcpip</strong> <- <strong>opitsk</strong> <- <strong>opiino</strong> <- <strong>opiodr</strong> <- opidrv
              <- <strong>sou2o</strong> <- <strong>opimai_real</strong> <- <strong>ssthrdmain</strong> <- <strong>main</strong> <- <strong>libc_start_main</strong>
               <- start

Changes

 Upgrade to 19C.

Cause

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