Messages In Alert Log "Qksrc: Viewtext[Ecode=1031] = Select ..." (Doc ID 1135936.1)

Last updated on JUNE 28, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

The following messages started to appear in the alert log during materialized view refresh:


Thu Jun 10 15:20:20 2010
QKSRC: ViewText[ecode=1031] = SELECT /*+ RESULT_CACHE(LIFETIME=SESSION) */ "MAS$"."RID$" "RID$" , "MAS$"."VANDATUMTIJD", "MAS$"."HANDELSPARTIJ_ID", "MAS$"."TYPEHANDELSRESULTAAT_ID", "MAS$"."BEDRAG_LDN", "MAS$"."BEDRAG_ODN", "MAS$"."BONUS", "MAS$"."LIQUIDITEITSPREMIE", "MAS$"."VOLUME_LDN", "MAS$"."VOLUME_ODN", DECODE("MAS$"."OLD_NEW$$", 'N', 'I', 'D') "DML$$", "MAS$"."OLD_NEW$$" "OLD_NEW$$", "MAS$"."TIME$$" "TIME$$", "MAS$"."DMLTYPE$$" "DMLTYPE$$" FROM (SELECT "MAS$".*, MIN("MAS$"."SEQ$$") OVER (PARTITION BY "MAS$"."RID$") "MINSEQ$$", MAX("MAS$"."SEQ$$") OVER (PARTITION BY "MAS$"."RID$") "MAXSEQ$$" FROM (SELECT CHARTOROWID("MAS$"."M_ROW$$") RID$ , "MAS$"."VANDATUMTIJD", "MAS$"."HANDELSPARTIJ_ID", "MAS$"."TYPEHANDELSRESULTAAT_ID", "MAS$"."BEDRAG_LDN", "MAS$"."BEDRAG_ODN", "MAS$"."BONUS", "MAS$"."LIQUIDITEITSPREMIE", "MAS$"."VOLUME_LDN", "MAS$"."VOLUME_ODN" , DECODE("MAS$".OLD_NEW$$, 'N', 'I', 'D') DML$$, "MAS$"."DMLTYPE$$" "DMLTYPE$$", "MAS$"."SEQUENCE$$" "SEQ$$", "MAS$"."OLD_NEW$$" "OLD_NEW$$", "MAS$"."SNAPTIME$$" "TIME$$" FROM "UNLIMITED"."MLOG$_HAN_T_INKOOP_RES" "MAS$" WHERE "MAS$".SNAPTIME$$ > :B_ST0 ) AS OF SNAPSHOT(:B_SCN) "MAS$" ) "MAS$" WHERE ((("MAS$"."OLD_NEW$$" = 'N') AND ("MAS$"."SEQ$$" = "MAS$"."MAXSEQ$$")) OR (("MAS$"."OLD_NEW$$" IN ('O', 'U')) AND ("MAS$"."SEQ$$" = "MAS$"."MINSEQ$$")))

The refresh completes successfully: no error reported in the front end, and materialized view is fresh after refresh, and the materialized view log is emptied.


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms