Ora-7445 hokfesi_eval_select_item - Dg4odbc Crashes With MSSQL Image Transfer

(Doc ID 1326254.1)

Last updated on JANUARY 18, 2017

Applies to:

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

Symptoms

When a job which transfers images from the SQL Server is executed via DG4ODBC 11.2, it works for random amounts of images and then crashes with the provided error:
ORA-07445: exception encountered: core dump [hokfesi_eval_select_item()+218] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x5A34988] [UNABLE_TO_READ] []
This job has run ok for two years in 10.2.0.4.

Example of dump:
ORA-07445: exception encountered: core dump [hokfesi_eval_select_item()+218] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x5A34988] [UNABLE_TO_READ] []

========= Dump for incident 8675 (ORA 7445 [hokfesi_eval_select_item()+218]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x5A34988, hokfesi_eval_select_item()+218]

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
Process Id: 0x000007d0  Thread Id : 0x00000b24    Time : Tue May 17 10:59:46
Excp. Code: 0xc0000005  Excp. Type: ACCESS_VIO    Flags: 0x00000000

------------------- Registers ----------------------------
ip=0000000005A34988 sp=000000001FFE1A30 rp=0000000020673F90
r1=000000001FB99DF0 r2=ABC2459D80E255A2 r3=000000001FCCCE58
r4=0000000000000002 r5=000000001FFE1A30 r6=0000000020673F90 r7=0000000000000001
r8=000000001FBF10C0 r9=0000000018962750 r10=0000000000000000 r11=000000001FAE354A
r12=0000000024439D10 r13=0000000024439750 r14=000000001FFE2010 r15=0000000000000000
------------------- End of Registers ---------------------


*** 2011-05-17 10:59:46.619
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=dvtf7rnhu0yx9) -----
SELECT cardid, memlength, picture, cardtype, memid
             FROM getpictures
            WHERE cardid = '11099080'

----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)    
-------------------- -------- -------------------- ----------------------------
hokfesi_eval_select           0000000000000000     009AE2700 009AE270C 000000000
_item()+218                                        01FFC43C0
hokfsrws_fetch_send  CALL???  hokfesi_eval_select  000000004 020674168 01FA02420
_rows()+717                   _item()              003E2A06D
hokfch()+194         CALL???  hokfsrws_fetch_send  146F00000000 024439D10
                             _rows()              01FFE6620 020673F70
hoklls()+963         CALL???  hokfch()             7FF00000002 000000000
                                                  000000000 7FF642F9E48
hokll()+14           CALL???  hoklls()             01FFE3640 01FBF10C0 000000001
                                                  01FBF3040
hokl8()+1201         CALL???  hokll()              01FC31718 000000018 007B11D24
                                                  000000001
hogdre()+666         CALL???  hokl8()              01FBF2648 00000005E 000000016
                                                  146F84E81E56
hogodr()+116         CALL???  hogdre()             01FBF3040 024453B10 00000005E
                                                  01FFE6608
xupirtrc()+2739      CALL???  hogodr()             01FBF3040 00000005E 01FFE6608
                                                  01FFE6DA0
upirtrc()+124        CALL???  xupirtrc()           000000000 000000000 01FFE6608
                                                  01FFE6780
kpurcsc()+150        CALL???  upirtrc()            000001050 00996BF1C 024439D10
        ......

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