Inquiry about errors that occur when querying Oracle DB using linked server in sqlserver2019.

Question

hello.

I would like to inquire about errors that occur when querying from sqlserver to oracle server using the linked server function.

The version of sqlserver is 2019.

The detailed version is 15.0.2000.5.

Oracle Server is 11g.

Oracle 11g client is installed on the server computer.

OPENQUERY is used, and this is a query that INSERT data from ORACLE DB into MSSQL DB.

When I run this query, an error occurs and the SQLSERVER service stops.

When the service is stopped, the SERVER ERROR LOG DUMP file is attached.

I would like to know the cause of this error and a solution.

09/06/2023 14:26:30,spid61,알 수 없음,External dump process return code 0x20000001.<nl/>External dump process returned no errors.

09/06/2023 14:26:29,spid61,알 수 없음,Stack Signature for the dump is 0x000000001862BD40

09/06/2023 14:26:29,spid61,알 수 없음,00007FFC0ADAA351 Module(ntdll+000000000005A351)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFC08377AC4 Module(KERNEL32+0000000000017AC4)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE4A6AFA4 Module(sqldk+000000000002AFA4)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE4A6AA5B Module(sqldk+000000000002AA5B)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE4A6B160 Module(sqldk+000000000002B160)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE4A46C75 Module(sqldk+0000000000006C75)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE4A46E6D Module(sqldk+0000000000006E6D)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE4A46523 Module(sqldk+0000000000006523)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE815D5EF Module(sqllang+000000000001D5EF)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE815D815 Module(sqllang+000000000001D815)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE815E67B Module(sqllang+000000000001E67B)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE815387A Module(sqllang+000000000001387A)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE81559C3 Module(sqllang+00000000000159C3)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE82E5124 Module(sqllang+00000000001A5124)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE82E4A79 Module(sqllang+00000000001A4A79)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE82E5576 Module(sqllang+00000000001A5576)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE82F4E47 Module(sqllang+00000000001B4E47)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE82F3F23 Module(sqllang+00000000001B3F23)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE82F415D Module(sqllang+00000000001B415D)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE82F42DD Module(sqllang+00000000001B42DD)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE82F415D Module(sqllang+00000000001B415D)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE831C2A3 Module(sqllang+00000000001DC2A3)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE82F415D Module(sqllang+00000000001B415D)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE83318A1 Module(sqllang+00000000001F18A1)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE82F415D Module(sqllang+00000000001B415D)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE83294B3 Module(sqllang+00000000001E94B3)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE830DFB8 Module(sqllang+00000000001CDFB8)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE8A4E366 Module(sqllang+000000000090E366)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE90A1572 Module(sqllang+0000000000F61572)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE90A40C8 Module(sqllang+0000000000F640C8)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE90A45AB Module(sqllang+0000000000F645AB)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE90A523A Module(sqllang+0000000000F6523A)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE903B810 Module(sqllang+0000000000EFB810)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE9086639 Module(sqllang+0000000000F46639)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFBE908CBD1 Module(sqllang+0000000000F4CBD1)

09/06/2023 14:26:29,spid61,알 수 없음,0000000010001DB1 Module(OraOLEDB11+0000000000001DB1)

09/06/2023 14:26:29,spid61,알 수 없음,000000004442446D Module(OraOLEDBrst11+000000000002446D)

09/06/2023 14:26:29,spid61,알 수 없음,0000000044423371 Module(OraOLEDBrst11+0000000000023371)

09/06/2023 14:26:29,spid61,알 수 없음,0000000044701A5F Module(OraOLEDButl11+0000000000001A5F)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFC0AD6822E Module(ntdll+000000000001822E)

09/06/2023 14:26:29,spid61,알 수 없음,00007FFC0AD6A71C Module(ntdll+000000000001A71C)

09/06/2023 14:26:29,spid61,알 수 없음,* Short Stack Dump

09/06/2023 14:26:29,spid61,알 수 없음,* -------------------------------------------------------------------------------

09/06/2023 14:26:29,spid61,알 수 없음,* *******************************************************************************

09/06/2023 14:26:29,spid61,알 수 없음,* Rip: 00007FFC0AD6A71C: 084F8B4D24048B49 0002C1850FC13B49 02B8850FC03B4900 480846B70F410000 8B48000000C08329 D285480000013893

09/06/2023 14:26:29,spid61,알 수 없음,* R15: 000000013EF27020:

09/06/2023 14:26:29,spid61,알 수 없음,* R14: 000002435036B610: 8463CFB82994E282 0003872428000028 000000013EF27020 0000000000000000 00000243506C8D90 0000000000000000

09/06/2023 14:26:29,spid61,알 수 없음,* R13: 0000000000000000:

09/06/2023 14:26:29,spid61,알 수 없음,* R12: 0000000000000000:

09/06/2023 14:26:29,spid61,알 수 없음,* R11: 00000243514F9FD0: 000002313A8FDDD0 00000243506DBE30 F0E0D0C00000000A 00000000C3F13C4E 000000000000000B 00000243514FA000

09/06/2023 14:26:29,spid61,알 수 없음,* R10: 000002313A9600F0: 0000000002080000 0000000000000000 00000000000000C4 0009001700000006 0000000000000009 0000000000000000

09/06/2023 14:26:29,spid61,알 수 없음,* R9: 000002435036A960: 0000000000000000 0000000B00010000 0000000100000000 0000000000000000 0000000000000000 0000000000000000

09/06/2023 14:26:29,spid61,알 수 없음,* R8: 000002435036B620: 000000013EF27020 0000000000000000 00000243506C8D90 0000000000000000 54769BC8623F3401 BF8CCF11B7028AC7

09/06/2023 14:26:29,spid61,알 수 없음,* Rdi: 0000000000000000:

09/06/2023 14:26:29,spid61,알 수 없음,* Rsi: 000002435036A950: 820300050501010D 100387A8CD0100CC 0000000000000000 0000000B00010000 0000000100000000 0000000000000000

09/06/2023 14:26:29,spid61,알 수 없음,* Rbp: 000002313A860000: 0000000000000000 010087E88D934208 00000002FFEEFFEE 000002313B5C0018 000002313A860120 000002313A860000

09/06/2023 14:26:29,spid61,알 수 없음,* Rsp: 00000070619F8BD0: 0000000000000400 0000000000000000 0000023100000000 00007FFC0AD5EE3F 0000000000000000 0000023100000000

09/06/2023 14:26:29,spid61,알 수 없음,* Rbx: 000002313A860000: 0000000000000000 010087E88D934208 00000002FFEEFFEE 000002313B5C0018 000002313A860120 000002313A860000

09/06/2023 14:26:29,spid61,알 수 없음,* Rdx: 0000000000000028:

09/06/2023 14:26:29,spid61,알 수 없음,* Rcx: 0000000000002828:

09/06/2023 14:26:29,spid61,알 수 없음,* Rax: 0000000000280000:

09/06/2023 14:26:29,spid61,알 수 없음,* EFlags: 0000000000010246:

09/06/2023 14:26:29,spid61,알 수 없음,* SegSs: 000000000000002B:

09/06/2023 14:26:29,spid61,알 수 없음,* SegGs: 000000000000002B:

09/06/2023 14:26:29,spid61,알 수 없음,* SegFs: 0000000000000053:

09/06/2023 14:26:29,spid61,알 수 없음,* SegEs: 000000000000002B:

09/06/2023 14:26:29,spid61,알 수 없음,* SegDs: 000000000000002B:

09/06/2023 14:26:29,spid61,알 수 없음,* SegCs: 0000000000000033:

09/06/2023 14:26:29,spid61,알 수 없음,* MxCsr: 0000000000001F80:

09/06/2023 14:26:29,spid61,알 수 없음,* ContextFlags: 000000000010005F:

09/06/2023 14:26:29,spid61,알 수 없음,* P6Home: 00007FFBE51C4253: 00000538249C8B48 41000004F0C48148 C35E5F5C415E415F 9090909090909090 9090909090909090 48F3FF9090909090

09/06/2023 14:26:29,spid61,알 수 없음,* P5Home: 0000000000000000:

09/06/2023 14:26:29,spid61,알 수 없음,* P4Home: 0000000000000000:

09/06/2023 14:26:29,spid61,알 수 없음,* P3Home: 000002313A860000: 0000000000000000 010087E88D934208 00000002FFEEFFEE 000002313B5C0018 000002313A860120 000002313A860000

09/06/2023 14:26:29,spid61,알 수 없음,* P2Home: 00000240F0334638: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000

09/06/2023 14:26:29,spid61,알 수 없음,* P1Home: 0000000000000000:

09/06/2023 14:26:29,spid61,알 수 없음,*

09/06/2023 14:26:29,spid61,알 수 없음,* fwpuclnt 00007FFBF9E00000 00007FFBF9E78FFF 00079000

09/06/2023 14:26:29,spid61,알 수 없음,* rasadhlp 00007FFBF94C0000 00007FFBF94C9FFF 0000a000

09/06/2023 14:26:29,spid61,알 수 없음,* odbccp32 00007FFBCCC00000 00007FFBCCC25FFF 00026000

09/06/2023 14:26:29,spid61,알 수 없음,* SAMLIB 00007FFBF8DC0000 00007FFBF8DE4FFF 00025000

09/06/2023 14:26:29,spid61,알 수 없음,* DSROLE 00007FFC02AB0000 00007FFC02AB9FFF 0000a000

09/06/2023 14:26:29,spid61,알 수 없음,* xplog70 000002434F610000 000002434F612FFF 00003000

09/06/2023 14:26:29,spid61,알 수 없음,* xplog70 00007FFBCBEC0000 00007FFBCBED5FFF 00016000

09/06/2023 14:26:29,spid61,알 수 없음,* cryptnet 00007FFC00290000 00007FFC002BEFFF 0002f000

09/06/2023 14:26:29,spid61,알 수 없음,* OraOLEDBpus11 0000000044200000 0000000044207FFF 00008000

09/06/2023 14:26:29,spid61,알 수 없음,* OraOLEDB11ko 0000000044300000 0000000044305FFF 00006000

09/06/2023 14:26:29,spid61,알 수 없음,* OraPlc11 000002457B8D0000 000002457B8EFFFF 00020000

09/06/2023 14:26:29,spid61,알 수 없음,* oraocrb11 000002457B7B0000 000002457B8A3FFF 000f4000

09/06/2023 14:26:29,spid61,알 수 없음,* oraocrutl11 000002457B790000 000002457B7A0FFF 00011000

09/06/2023 14:26:29,spid61,알 수 없음,* MSVCP80 0000000050060000 0000000050168FFF 00109000

09/06/2023 14:26:29,spid61,알 수 없음,* oraocr11 000002457B680000 000002457B747FFF 000c8000

09/06/2023 14:26:29,spid61,알 수 없음,* orahasgen11 000002457B3A0000 000002457B675FFF 002d6000

09/06/2023 14:26:29,spid61,알 수 없음,* oraxml11 000002457AEA0000 000002457B37EFFF 004df000

09/06/2023 14:26:29,spid61,알 수 없음,* oraplp11 000002457AAA0000 000002457AE94FFF 003f5000

09/06/2023 14:26:29,spid61,알 수 없음,* oravsn11 000002457AA90000 000002457AA96FFF 00007000

09/06/2023 14:26:29,spid61,알 수 없음,* oraslax11 000002457AA80000 000002457AA8EFFF 0000f000

09/06/2023 14:26:29,spid61,알 수 없음,* oracell11 000002457A9F0000 000002457AA3AFFF 0004b000

09/06/2023 14:26:29,spid61,알 수 없음,* orasnls11 000002457A9B0000 000002457A9ECFFF 0003d000

09/06/2023 14:26:29,spid61,알 수 없음,* orantcp11 000002457A970000 000002457A9A4FFF 00035000

09/06/2023 14:26:29,spid61,알 수 없음,* oraztkg11 000002457A8A0000 000002457A952FFF 000b3000

09/06/2023 14:26:29,spid61,알 수 없음,* orantns11 000002457A860000 000002457A870FFF 00011000

09/06/2023 14:26:29,spid61,알 수 없음,* orancds11 000002457A850000 000002457A856FFF 00007000

09/06/2023 14:26:29,spid61,알 수 없음,* oranhost11 000002457A830000 000002457A839FFF 0000a000

09/06/2023 14:26:29,spid61,알 수 없음,* oranldap11 000002457A7D0000 000002457A81AFFF 0004b000

09/06/2023 14:26:29,spid61,알 수 없음,* orazt11 000002457A5E0000 000002457A7CFFFF 001f0000

09/06/2023 14:26:29,spid61,알 수 없음,* orannzsbb11 000002457A440000 000002457A5C3FFF 00184000

09/06/2023 14:26:29,spid61,알 수 없음,* WSOCK32 00007FFBED060000 00007FFBED068FFF 00009000

09/06/2023 14:26:29,spid61,알 수 없음,* orageneric11 00000245794F0000 000002457A3F0FFF 00f01000

09/06/2023 14:26:29,spid61,알 수 없음,* orapls11 0000024578FB0000 00000245794D0FFF 00521000

09/06/2023 14:26:29,spid61,알 수 없음,* orasql11 0000024578F40000 0000024578F9DFFF 0005e000

09/06/2023 14:26:29,spid61,알 수 없음,* orauts 0000024577E20000 0000024577E26FFF 00007000

09/06/2023 14:26:29,spid61,알 수 없음,* oranl11 0000024578EC0000 0000024578F2EFFF 0006f000

09/06/2023 14:26:29,spid61,알 수 없음,* oranro11 0000024578E60000 0000024578EBAFFF 0005b000

09/06/2023 14:26:29,spid61,알 수 없음,* oraldapclnt11 0000024578C60000 0000024578E51FFF 001f2000

09/06/2023 14:26:29,spid61,알 수 없음,* oran11 0000024578800000 0000024578C53FFF 00454000

09/06/2023 14:26:29,spid61,알 수 없음,* oracore11 00000245786A0000 00000245787FFFFF 00160000

09/06/2023 14:26:29,spid61,알 수 없음,* oracommon11 00000245783E0000 0000024578696FFF 002b7000

09/06/2023 14:26:29,spid61,알 수 없음,* orancrypt11 0000024577DA0000 0000024577DC3FFF 00024000

09/06/2023 14:26:29,spid61,알 수 없음,* oranls11 00000245782E0000 00000245783DEFFF 000ff000

09/06/2023 14:26:29,spid61,알 수 없음,* oraunls11 0000024577D70000 0000024577D8FFFF 00020000

09/06/2023 14:26:29,spid61,알 수 없음,* OraClient11 0000024577E40000 00000245782DDFFF 0049e000

09/06/2023 14:26:29,spid61,알 수 없음,* MSVCR80 0000000050750000 0000000050818FFF 000c9000

09/06/2023 14:26:29,spid61,알 수 없음,* OCI 0000000180000000 00000001800AAFFF 000ab000

09/06/2023 14:26:29,spid61,알 수 없음,* OraOLEDButl11 0000000044700000 0000000044708FFF 00009000

09/06/2023 14:26:29,spid61,알 수 없음,* OraOLEDBgmr11 0000000044100000 0000000044126FFF 00027000

09/06/2023 14:26:29,spid61,알 수 없음,* OraOLEDBrst11 0000000044400000 0000000044434FFF 00035000

09/06/2023 14:26:29,spid61,알 수 없음,* OraOLEDB11 0000000010000000 000000001008EFFF 0008f000

09/06/2023 14:26:29,spid61,알 수 없음,* comsvcs 00007FFBC8170000 00007FFBC8316FFF 001a7000

09/06/2023 14:26:29,spid61,알 수 없음,* Comctl32 00007FFBEEA50000 00007FFBEECC8FFF 00279000

09/06/2023 14:26:29,spid61,알 수 없음,* MSDART 00007FFBCBF00000 00007FFBCBF26FFF 00027000

09/06/2023 14:26:29,spid61,알 수 없음,* oledb32 00007FFBC8320000 00007FFBC840CFFF 000ed000

09/06/2023 14:26:29,spid61,알 수 없음,* xpstar 0000024577C00000 0000024577C09FFF 0000a000

09/06/2023 14:26:29,spid61,알 수 없음,* SQLSCM 00007FFBD35D0000 00007FFBD35E3FFF 00014000

09/06/2023 14:26:29,spid61,알 수 없음,* xpstar 00007FFBCBF30000 00007FFBCBFA1FFF 00072000

09/06/2023 14:26:29,spid61,알 수 없음,* xpsqlbot 00007FFC01D70000 00007FFC01D79FFF 0000a000

09/06/2023 14:26:29,spid61,알 수 없음,* ncryptsslp 00007FFBEB1A0000 00007FFBEB1C3FFF 00024000

09/06/2023 14:26:29,spid61,알 수 없음,* DSPARSE 00007FFBF94B0000 00007FFBF94BCFFF 0000d000

09/06/2023 14:26:29,spid61,알 수 없음,* ntdsapi 00007FFBCCC30000 00007FFBCCC57FFF 00028000

09/06/2023 14:26:29,spid61,알 수 없음,* MSFTE 0000000049980000 0000000049D2DFFF 003ae000

09/06/2023 14:26:29,spid61,알 수 없음,* ftimport 0000000060000000 0000000060024FFF 00025000

09/06/2023 14:26:29,spid61,알 수 없음,* mskeyprotect 00007FFBE4750000 00007FFBE4764FFF 00015000

09/06/2023 14:26:29,spid61,알 수 없음,* SRVCLI 00007FFBFF1B0000 00007FFBFF1D5FFF 00026000

09/06/2023 14:26:29,spid61,알 수 없음,* BatchParser 00007FFC01D80000 00007FFC01DA9FFF 0002a000

09/06/2023 14:26:29,spid61,알 수 없음,* clrjit 00007FFBDD820000 00007FFBDD94AFFF 0012b000

09/06/2023 14:26:29,spid61,알 수 없음,* SqlAccess 00007FFBCCC60000 00007FFBCCCD5FFF 00076000

09/06/2023 14:26:29,spid61,알 수 없음,* mscorlib.ni 00007FFBE0B40000 00007FFBE20D0FFF 01591000

09/06/2023 14:26:29,spid61,알 수 없음,* MSVCR120_CLR0400 00007FFBE3560000 00007FFBE3656FFF 000f7000

09/06/2023 14:26:29,spid61,알 수 없음,* clr 00007FFBE3800000 00007FFBE423AFFF 00a3b000

09/06/2023 14:26:29,spid61,알 수 없음,* SQLNCLIRDAR11 000002434F690000 000002434F6C7FFF 00038000

09/06/2023 14:26:29,spid61,알 수 없음,* sqlnclirda11 0000000050170000 00000000504C8FFF 00359000

09/06/2023 14:26:29,spid61,알 수 없음,* netbios 00007FFC04F70000 00007FFC04F7BFFF 0000c000

09/06/2023 14:26:29,spid61,알 수 없음,* SQLNCLIR11 000002434F460000 000002434F497FFF 00038000

09/06/2023 14:26:29,spid61,알 수 없음,* ntmarta 00007FFC05D40000 00007FFC05D70FFF 00031000

09/06/2023 14:26:29,spid61,알 수 없음,* ESENT 00007FFBF5480000 00007FFBF57AAFFF 0032b000

09/06/2023 14:26:29,spid61,알 수 없음,* ualapi 00007FFBF57B0000 00007FFBF57C9FFF 0001a000

09/06/2023 14:26:29,spid61,알 수 없음,* MSVCR100 00000000504D0000 00000000505A1FFF 000d2000

09/06/2023 14:26:29,spid61,알 수 없음,* sqlncli11 00007FFBCC760000 00007FFBCCAB3FFF 00354000

09/06/2023 14:26:29,spid61,알 수 없음,* dhcpcsvc6 00007FFBFFF60000 00007FFBFFF75FFF 00016000

09/06/2023 14:26:29,spid61,알 수 없음,* MSOLEDBSQLR 000002434F3E0000 000002434F3F7FFF 00018000

09/06/2023 14:26:29,spid61,알 수 없음,* imm32 00007FFC0ACF0000 00007FFC0AD1DFFF 0002e000

09/06/2023 14:26:29,spid61,알 수 없음,* MSWSOCK 00007FFC06560000 00007FFC065C6FFF 00067000

09/06/2023 14:26:29,spid61,알 수 없음,* powrprof 00007FFC06D80000 00007FFC06DDCFFF 0005d000

09/06/2023 14:26:29,spid61,알 수 없음,* windows.storage 00007FFC07800000 00007FFC07F48FFF 00749000

09/06/2023 14:26:29,spid61,알 수 없음,* COMCTL32 00007FFBF9CA0000 00007FFBF9D48FFF 000a9000

09/06/2023 14:26:29,spid61,알 수 없음,* SHELL32 00007FFC08F00000 00007FFC0A3F7FFF 014f8000

09/06/2023 14:26:29,spid61,알 수 없음,* shcore 00007FFC082B0000 00007FFC08356FFF 000a7000

09/06/2023 14:26:29,spid61,알 수 없음,* COMDLG32 00007FFC08DD0000 00007FFC08EF5FFF 00126000

09/06/2023 14:26:29,spid61,알 수 없음,* msoledbsql 00007FFBCCCE0000 00007FFBCCF7FFFF 002a0000

09/06/2023 14:26:29,spid61,알 수 없음,* msxml3 00007FFBEB510000 00007FFBEB74AFFF 0023b000

09/06/2023 14:26:29,spid61,알 수 없음,* clbcatq 00007FFC08440000 00007FFC084E7FFF 000a8000

09/06/2023 14:26:29,spid61,알 수 없음,* SqlServerSpatial150 00007FFBD35F0000 00007FFBD3691FFF 000a2000

09/06/2023 14:26:29,spid61,알 수 없음,* mscoreei 00007FFBE4550000 00007FFBE45EBFFF 0009c000

09/06/2023 14:26:29,spid61,알 수 없음,* MSCOREE 00007FFBEB0D0000 00007FFBEB133FFF 00064000

09/06/2023 14:26:29,spid61,알 수 없음,* SECURITY 000002433F1F0000 000002433F1F2FFF 00003000

09/06/2023 14:26:29,spid61,알 수 없음,* schannel 00007FFC06010000 00007FFC0609BFFF 0008c000

09/06/2023 14:26:29,spid61,알 수 없음,* kerberos 00007FFC06620000 00007FFC06722FFF 00103000

09/06/2023 14:26:29,spid61,알 수 없음,* cryptdll 00007FFC065D0000 00007FFC065E4FFF 00015000

09/06/2023 14:26:29,spid61,알 수 없음,* NtlmShared 00007FFC064D0000 00007FFC064DCFFF 0000d000

09/06/2023 14:26:29,spid61,알 수 없음,* msv1_0 00007FFC064E0000 00007FFC06556FFF 00077000

09/06/2023 14:26:29,spid61,알 수 없음,* ncryptprov 00007FFBF5040000 00007FFBF5099FFF 0005a000

09/06/2023 14:26:29,spid61,알 수 없음,* SHLWAPI 00007FFC0A970000 00007FFC0A9C1FFF 00052000

09/06/2023 14:26:29,spid61,알 수 없음,* hkengine 00007FFBCD910000 00007FFBCE005FFF 006f6000

09/06/2023 14:26:29,spid61,알 수 없음,* hkcompile 00007FFBCE010000 00007FFBCE14FFFF 00140000

09/06/2023 14:26:29,spid61,알 수 없음,* dbghelp 00007FFBF4E20000 00007FFBF500CFFF 001ed000

09/06/2023 14:26:29,spid61,알 수 없음,* hkruntime 00007FFC01DB0000 00007FFC02082FFF 002d3000

09/06/2023 14:26:29,spid61,알 수 없음,* VERSION 00007FFC007B0000 00007FFC007B9FFF 0000a000

09/06/2023 14:26:29,spid61,알 수 없음,* RESUTILS 00007FFBEB7B0000 00007FFBEB84DFFF 0009e000

09/06/2023 14:26:29,spid61,알 수 없음,* IPHLPAPI 00007FFC06270000 00007FFC062ACFFF 0003d000

09/06/2023 14:26:29,spid61,알 수 없음,* DNSAPI 00007FFC062B0000 00007FFC06375FFF 000c6000

09/06/2023 14:26:29,spid61,알 수 없음,* CLUSAPI 00007FFBECF50000 00007FFBED057FFF 00108000

09/06/2023 14:26:29,spid61,알 수 없음,* sqlevn70 000002313B8D0000 000002313BC08FFF 00339000

09/06/2023 14:26:29,spid61,알 수 없음,* sqlevn70 000002313B6C0000 000002313B8CCFFF 0020d000

09/06/2023 14:26:29,spid61,알 수 없음,* cscapi 00007FFBEB750000 00007FFBEB761FFF 00012000

09/06/2023 14:26:29,spid61,알 수 없음,* wkscli 00007FFBFF0F0000 00007FFBFF107FFF 00018000

09/06/2023 14:26:29,spid61,알 수 없음,* gpapi 00007FFC05970000 00007FFC05991FFF 00022000

09/06/2023 14:26:29,spid61,알 수 없음,* imagehlp 00007FFC08420000 00007FFC0843CFFF 0001d000

09/06/2023 14:26:29,spid61,알 수 없음,* CRYPTBASE 00007FFC06730000 00007FFC0673BFFF 0000c000

09/06/2023 14:26:29,spid61,알 수 없음,* rsaenh 00007FFC060E0000 00007FFC06112FFF 00033000

09/06/2023 14:26:29,spid61,알 수 없음,* CRYPTSP 00007FFC073A0000 00007FFC073BAFFF 0001b000

09/06/2023 14:26:29,spid61,알 수 없음,* instapi150 00007FFBE2110000 00007FFBE2123FFF 00014000

09/06/2023 14:26:29,spid61,알 수 없음,* kernel.appcore 00007FFC06D30000 00007FFC06D40FFF 00011000

09/06/2023 14:26:29,spid61,알 수 없음,* psapi 00007FFC086F0000 00007FFC086F7FFF 00008000

09/06/2023 14:26:29,spid61,알 수 없음,* NTASN1 00007FFC067F0000 00007FFC0682BFFF 0003c000

09/06/2023 14:26:29,spid61,알 수 없음,* LOGONCLI 00007FFC06390000 00007FFC063D0FFF 00041000

09/06/2023 14:26:29,spid61,알 수 없음,* NSI 00007FFC0ACE0000 00007FFC0ACE7FFF 00008000

09/06/2023 14:26:29,spid61,알 수 없음,* dhcpcsvc 00007FFBFFF40000 00007FFBFFF5BFFF 0001c000

09/06/2023 14:26:29,spid61,알 수 없음,* XmlLite 00007FFBF9EB0000 00007FFBF9EE9FFF 0003a000

09/06/2023 14:26:29,spid61,알 수 없음,* AUTHZ 00007FFC05EA0000 00007FFC05EEBFFF 0004c000

09/06/2023 14:26:29,spid61,알 수 없음,* profapi 00007FFC06D50000 00007FFC06D72FFF 00023000

09/06/2023 14:26:29,spid61,알 수 없음,* USERENV 00007FFC06C10000 00007FFC06C38FFF 00029000

09/06/2023 14:26:29,spid61,알 수 없음,* WINTRUST 00007FFC077A0000 00007FFC077FEFFF 0005f000

09/06/2023 14:26:29,spid61,알 수 없음,* SAMCLI 00007FFC024B0000 00007FFC024C7FFF 00018000

09/06/2023 14:26:29,spid61,알 수 없음,* sqllang 00007FFBE8140000 00007FFBEA707FFF 025c8000

09/06/2023 14:26:29,spid61,알 수 없음,* NETUTILS 00007FFC06380000 00007FFC0638DFFF 0000e000

09/06/2023 14:26:29,spid61,알 수 없음,* ncrypt 00007FFC06830000 00007FFC0685BFFF 0002c000

09/06/2023 14:26:29,spid61,알 수 없음,* SSPICLI 00007FFC06C40000 00007FFC06C6EFFF 0002f000

09/06/2023 14:26:29,spid61,알 수 없음,* bcrypt 00007FFC07F50000 00007FFC07F75FFF 00026000

09/06/2023 14:26:29,spid61,알 수 없음,* secforwarder 00007FFBE4480000 00007FFBE4490FFF 00011000

09/06/2023 14:26:29,spid61,알 수 없음,* DPAPI 00007FFC06B60000 00007FFC06B69FFF 0000a000

09/06/2023 14:26:29,spid61,알 수 없음,* ODBC32 00007FFBED5A0000 00007FFBED653FFF 000b4000

09/06/2023 14:26:29,spid61,알 수 없음,* WINHTTP 00007FFC00AB0000 00007FFC00BAEFFF 000ff000

09/06/2023 14:26:29,spid61,알 수 없음,* Secur32 00007FFBF5030000 00007FFBF503BFFF 0000c000

09/06/2023 14:26:29,spid61,알 수 없음,* WS2_32 00007FFC0A690000 00007FFC0A6FCFFF 0006d000

09/06/2023 14:26:29,spid61,알 수 없음,* sqlmin 00007FFBE5180000 00007FFBE8137FFF 02fb8000

09/06/2023 14:26:29,spid61,알 수 없음,* cfgmgr32 00007FFC07230000 00007FFC07279FFF 0004a000

09/06/2023 14:26:29,spid61,알 수 없음,* WINMMBASE 00007FFC048E0000 00007FFC0490CFFF 0002d000

09/06/2023 14:26:29,spid61,알 수 없음,* WININET 00007FFBEBA50000 00007FFBEBF32FFF 004e3000

09/06/2023 14:26:29,spid61,알 수 없음,* VCRUNTIME140_1 00007FFBF9580000 00007FFBF958BFFF 0000c000

09/06/2023 14:26:29,spid61,알 수 없음,* WINMM 00007FFC04D60000 00007FFC04D83FFF 00024000

09/06/2023 14:26:29,spid61,알 수 없음,* MPR 00007FFBF5370000 00007FFBF538AFFF 0001b000

09/06/2023 14:26:29,spid61,알 수 없음,* VCRUNTIME140 00007FFBF95D0000 00007FFBF95EAFFF 0001b000

09/06/2023 14:26:29,spid61,알 수 없음,* MSVCP140 00007FFBF9420000 00007FFBF94ADFFF 0008e000

09/06/2023 14:26:29,spid61,알 수 없음,* qds 00007FFBE45F0000 00007FFBE4718FFF 00129000

09/06/2023 14:26:29,spid61,알 수 없음,* svl 00007FFBE4720000 00007FFBE474CFFF 0002d000

09/06/2023 14:26:29,spid61,알 수 없음,* opends60 00007FFBE4770000 00007FFBE4778FFF 00009000

09/06/2023 14:26:29,spid61,알 수 없음,* MSASN1 00007FFC06D10000 00007FFC06D21FFF 00012000

09/06/2023 14:26:29,spid61,알 수 없음,* CRYPT32 00007FFC07030000 00007FFC0722AFFF 001fb000

09/06/2023 14:26:29,spid61,알 수 없음,* OLEAUT32 00007FFC08CD0000 00007FFC08D93FFF 000c4000

09/06/2023 14:26:29,spid61,알 수 없음,* sqldk 00007FFBE4A40000 00007FFBE4F65FFF 00526000

09/06/2023 14:26:29,spid61,알 수 없음,* sqlTsEs 00007FFBEA710000 00007FFBEAFD8FFF 008c9000

09/06/2023 14:26:29,spid61,알 수 없음,* SQLOS 00007FFBEB860000 00007FFBEB868FFF 00009000

09/06/2023 14:26:29,spid61,알 수 없음,* win32u 00007FFC07380000 00007FFC0739FFFF 00020000

09/06/2023 14:26:29,spid61,알 수 없음,* USER32 00007FFC084F0000 00007FFC08687FFF 00198000

09/06/2023 14:26:29,spid61,알 수 없음,* msvcp_win 00007FFC06DE0000 00007FFC06E7FFFF 000a0000

09/06/2023 14:26:29,spid61,알 수 없음,* gdi32full 00007FFC06E80000 00007FFC07025FFF 001a6000

09/06/2023 14:26:29,spid61,알 수 없음,* GDI32 00007FFC08DA0000 00007FFC08DC8FFF 00029000

09/06/2023 14:26:29,spid61,알 수 없음,* bcryptPrimitives 00007FFC07660000 00007FFC076E1FFF 00082000

09/06/2023 14:26:29,spid61,알 수 없음,* ucrtbase 00007FFC07280000 00007FFC07379FFF 000fa000

09/06/2023 14:26:29,spid61,알 수 없음,* combase 00007FFC07F80000 00007FFC082AAFFF 0032b000

09/06/2023 14:26:29,spid61,알 수 없음,* ole32 00007FFC0AB80000 00007FFC0ACD5FFF 00156000

09/06/2023 14:26:29,spid61,알 수 없음,* pdh 00007FFC00F00000 00007FFC00F4CFFF 0004d000

09/06/2023 14:26:29,spid61,알 수 없음,* NETAPI32 00007FFBF5170000 00007FFBF5188FFF 00019000

09/06/2023 14:26:29,spid61,알 수 없음,* RPCRT4 00007FFC0A4B0000 00007FFC0A5CDFFF 0011e000

09/06/2023 14:26:29,spid61,알 수 없음,* sechost 00007FFC0A400000 00007FFC0A49EFFF 0009f000

09/06/2023 14:26:29,spid61,알 수 없음,* msvcrt 00007FFC08C30000 00007FFC08CCDFFF 0009e000

09/06/2023 14:26:29,spid61,알 수 없음,* ADVAPI32 00007FFC08700000 00007FFC087A6FFF 000a7000

09/06/2023 14:26:29,spid61,알 수 없음,* KERNELBASE 00007FFC073C0000 00007FFC0765CFFF 0029d000

09/06/2023 14:26:29,spid61,알 수 없음,* KERNEL32 00007FFC08360000 00007FFC08412FFF 000b3000

09/06/2023 14:26:29,spid61,알 수 없음,* ntdll 00007FFC0AD50000 00007FFC0AF3EFFF 001ef000

09/06/2023 14:26:29,spid61,알 수 없음,* sqlservr 00007FF7B7840000 00007FF7B78DCFFF 0009d000

09/06/2023 14:26:29,spid61,알 수 없음,* MODULE BASE END SIZE

09/06/2023 14:26:29,spid61,알 수 없음,*

09/06/2023 14:26:29,spid61,알 수 없음,*

09/06/2023 14:26:29,spid61,알 수 없음,* ORDER_ID<c/>LOAD_ORDER')

09/06/2023 14:26:29,spid61,알 수 없음,* AND WORK_DATE = ''20230906'' ORDER BY MES_

09/06/2023 14:26:29,spid61,알 수 없음,* PE WHERE 1=1 AND LIST_YEAR <> ''0000''

09/06/2023 14:26:29,spid61,알 수 없음,* <c/>LOAD_ORDER AS MES_LOAD_ORDER FROM KFLAVOR.WS_ORDER_RECI

09/06/2023 14:26:29,spid61,알 수 없음,* RD_UDF3<c/>ORD_UDF4<c/>ORD_UDF5<c/>CREATOR_ID<c/>CREATE_DTTM<c/>MODIFIER_ID<c/>MODIFY_DTTM

09/06/2023 14:26:29,spid61,알 수 없음,* ORDER) AS LOAD_ORDER <c/>SPLIT<c/>REQ_QTY<c/>ORD_UDF1<c/>ORD_UDF2<c/>O

09/06/2023 14:26:29,spid61,알 수 없음,* OW_NUMBER () OVER (PARTITION BY MES_ORDER_ID ORDER BY MES_ORDER_ID<c/>LOAD_

09/06/2023 14:26:29,spid61,알 수 없음,* LIST_NAME<c/>LIST_UNIT_QTY<c/>MIX_QTY<c/>MIX_BOX_QTY<c/>BAR_CODE <c/>R

09/06/2023 14:26:29,spid61,알 수 없음,* ERIAL_NAME<c/>CHABUN <c/>OPERATION_ID<c/>LIST_CODE<c/>LIST_YEAR<c/>

09/06/2023 14:26:29,spid61,알 수 없음,* SITE_ID<c/>WORK_DATE<c/>SCM_ORDER_ID<c/>ERP_ORDER_ID<c/>MES_ORDER_ID<c/>MATERIAL_ID<c/>MAT

09/06/2023 14:26:29,spid61,알 수 없음,* SELECT * FROM OPENQUERY(MESDBYJ<c/>' SELECT

09/06/2023 14:26:29,spid61,알 수 없음,* Input Buffer 510 bytes -

09/06/2023 14:26:29,spid61,알 수 없음,* Access Violation occurred reading address 0000000000000000

09/06/2023 14:26:29,spid61,알 수 없음,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

09/06/2023 14:26:29,spid61,알 수 없음,* Exception Address = 00007FFC0AD6A71C Module(ntdll+000000000001A71C)

09/06/2023 14:26:29,spid61,알 수 없음,*

09/06/2023 14:26:29,spid61,알 수 없음,*

09/06/2023 14:26:29,spid61,알 수 없음,* 09/06/23 14:26:29 spid 61

09/06/2023 14:26:29,spid61,알 수 없음,* BEGIN STACK DUMP:

Answer 1

I note that you are running the RTM version of SQL Server 2019. You should download and install the most recent Cumulative Update of SQL 2019 to get access to many bug fixes and enhancements.

I can't promise that this will resolve the issue, as the issue also could be with the Oracle OLE DB driver, but you should start there.

Answer 2

Hi @EUNCHONG CHOI,

You have got the DUMP file, I'd like to suggest you may open a ticket to Microsoft support and the engineers will help to resolve the issue.

Services Hub (microsoft.com)

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.