Sql Tuning Advisor Fails With ORA-07445 [msqcol()+1698] [ACCESS_VIOLATION] (Doc ID 1641945.1)

Last updated on JUNE 16, 2017

Applies to:

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

Symptoms

Alert log reports next error for automatic sql tuning

ORA-07445: exception encountered: core dump [msqcol()+1698] [ACCESS_VIOLATION] [ADDR:0x10] [PC:0x144168A4C] [UNABLE_TO_READ] []


The trace file shows:

----- Current SQL Statement for this session (sql_id=200zhggbsk6cp) -----
/* SQL Analyze(22,1) */ SELECT distinct
'QAR' as CURRENCY,
NVL(LONG_NAME, 'N/A') as CUSTOMER_NAME,
NVL(Q_GROUP_DESCRIPTION, 'N/A') AS group_name,
(CASE
            When Q_Cust_Request.No_Financial_Stmts = 'N' Then
             lo_entity.rating  || ' (Original: ' || lo_entity.Q_Original_Orr || ')' || ' (Rating Not Processed)'
            Else
             lo_entity.rating || ' (Original: ' || lo_entity.Q_Original_Orr || ')'
             End)
             as PROPOSED_ORR,
(Case
            When Q_Cust_Request.No_Financial_Stmts = 'N' Then
(select Decode(((Select Itemvalue From Q_No_Fs_Archive
Where Archivepoint = (Select Max(Archivepoint) From Q_No_Fs_Archive Where Counterparty_Id = Lo_Entity.Id And Itemvalue != Lo_Entity.Rating And Itemdef In ('OverrideGrade'))
...
...
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
000007FFF13902D8     11816  package body SYS.DBMS_SQLTUNE_INTERNAL
000007FFF13195F0         7  SYS.WRI$_ADV_SQLTUNE
000007FFF1498A70       587  package body SYS.PRVT_ADVISOR
000007FFF1498A70      2655  package body SYS.PRVT_ADVISOR
000007FFF13920A8       241  package body SYS.DBMS_ADVISOR
000007FFF151D9A8       821  package body SYS.DBMS_SQLTUNE
000007FFE8169B78         4  anonymous block

----- Call Stack Trace -----
... msqcol  msqopnws  msqsellst  msqsel  qksdsAppendFroElem  qksdsEInitCtx  kkoatVerifyEst  kkeAdjJoinPrefCard  kkejcd  kkojnp  kkocnp  kkooqb  kkoqbc  apakkoqb  apaqbdDescendents  apaqbdList  apaqbdDescendents  apaqbdList ...

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