question

ReamerMarc-3981 avatar image
0 Votes"
ReamerMarc-3981 asked ErlandSommarskog commented

Fatal Exceptions in SQL Server requires server restart

We are getting intermittent Fatal Exceptions in SQL Server. Once the error triggers it will retrigger in the same area of the application on all connections. Restarting the application or running from another PC will get the same error. The only way we've managed to get around it is to restart the SQL Server service.
The server is on the latest 2019 patch.

Can anyone help with this?

From application log:
Error in Execute Reader:
Cannot continue the execution because the session is in the kill state.
A severe error occurred on the current command. The results, if any, should be discarded.

Event Viewer:
A user request from the session with SPID 130 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.

SQL dump:
Current time is 15:42:56 09/22/21.
=====================================================================
BugCheck Dump
=====================================================================

This file is generated by Microsoft SQL Server
version 15.0.4138.2
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.

Computer type is Intel(R) Xeon(R) Silver 4215 CPU @ 2.50GHz.
Bios Version is INTEL - 6040000
VMW71.00V.17369862.B64.2012240522
8 X64 level 8664, 10 Mhz processor (s).
Windows NT 10.0 Build 17763 CSD .

Memory
MemoryLoad = 69%
Total Physical = 65535 MB
Available Physical = 20061 MB
Total Page File = 75263 MB
Available Page File = 27970 MB
Total Virtual = 134217727 MB
Available Virtual = 134147250 MB
Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\LOG\SQLDump0119.txt
SqlDumpExceptionHandler: Process 135 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.


BEGIN STACK DUMP:
09/22/21 15:42:56 spid 135



  • Exception Address = 00007FFA956F5CCD Module(sqlmin+0000000000075CCD)

  • Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

  • Access Violation occurred reading address 0000000000000078

  • Input Buffer 255 bytes -

  •                   16 00 00 00 12 00 00 00 02 00 00 00 00 00 00 00 00 00                                      
    
  •    ÿÿ      cJ(       01 00 00 00 ff ff 0a 00 02 00 00 00 63 4a 28 00 00 09                                      
    
  • Ð 4J( 04 d0 00 34 4a 28 00 00 0d 00 0a 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •        s e l e c  20 00 20 00 20 00 20 00 73 00 65 00 6c 00 65 00 63 00                                      
    
  • t r e q . r e q 74 00 20 00 72 00 65 00 71 00 2e 00 72 00 65 00 71 00

  • u i s i t i o n _ 75 00 69 00 73 00 69 00 74 00 69 00 6f 00 6e 00 5f 00

  • i d , 69 00 64 00 2c 00 0d 00 0a 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •  r e q . p a t i  20 00 72 00 65 00 71 00 2e 00 70 00 61 00 74 00 69 00                                      
    
  • e n t _ e i d , 65 00 6e 00 74 00 5f 00 65 00 69 00 64 00 2c 00 0d 00

  •                   0a 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •            e n t  20 00 20 00 20 00 20 00 20 00 20 00 65 00 6e 00 74 00                                      
    
  • . a c t i v e p 2e 00 61 00 63 00 74 00 69 00 76 00 65 00 20 00 70 00

  • a t i e n t _ a c 61 00 74 00 69 00 65 00 6e 00 74 00 5f 00 61 00 63 00

  • t i v e , 74 00 69 00 76 00 65 00 2c 00 0d 00 0a 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •      r q p . r e  20 00 20 00 20 00 72 00 71 00 70 00 2e 00 72 00 65 00                                      
    
  • q p a n e l i 71 00 5f 00 70 00 61 00 6e 00 65 00 6c 00 5f 00 69 00

  • d , 64 00 2c 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  • r q p . p a n e l 72 00 71 00 70 00 2e 00 70 00 61 00 6e 00 65 00 6c 00

  • _ i d , 5f 00 69 00 64 00 2c 00 0d 00 0a 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •    d b o . p k g  20 00 20 00 64 00 62 00 6f 00 2e 00 70 00 6b 00 67 00                                      
    
  • r e q p a n e 5f 00 72 00 65 00 71 00 5f 00 70 00 61 00 6e 00 65 00

  • l i s _ r e q 6c 00 5f 00 5f 00 69 00 73 00 5f 00 72 00 65 00 71 00

  • p a n e l t e 5f 00 70 00 61 00 6e 00 65 00 6c 00 5f 00 74 00 65 00

  • s t _ u p l o a d 73 00 74 00 5f 00 75 00 70 00 6c 00 6f 00 61 00 64 00

  • e d ( r q p . r e 65 00 64 00 28 00 72 00 71 00 70 00 2e 00 72 00 65 00

  • q p a n e l i 71 00 5f 00 70 00 61 00 6e 00 65 00 6c 00 5f 00 69 00

  • d , t s t . t e 64 00 2c 00 20 00 74 00 73 00 74 00 2e 00 74 00 65 00

  • s t _ i d ) w a 73 00 74 00 5f 00 69 00 64 00 29 00 20 00 77 00 61 00

  • s _ u p l o a d e 73 00 5f 00 75 00 70 00 6c 00 6f 00 61 00 64 00 65 00

  • d , 64 00 2c 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  • t s t . t e s t _ 74 00 73 00 74 00 2e 00 74 00 65 00 73 00 74 00 5f 00

  • i d , 69 00 64 00 2c 00 0d 00 0a 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •  t s t . t e s t  20 00 74 00 73 00 74 00 2e 00 74 00 65 00 73 00 74 00                                      
    
  • _ c o d e , 5f 00 63 00 6f 00 64 00 65 00 2c 00 0d 00 0a 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •        t s t . v  20 00 20 00 20 00 20 00 74 00 73 00 74 00 2e 00 76 00                                      
    
  • a l i d i t y , 61 00 6c 00 69 00 64 00 69 00 74 00 79 00 2c 00 0d 00

  •                   0a 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •            t s t  20 00 20 00 20 00 20 00 20 00 20 00 74 00 73 00 74 00                                      
    
  • . s o r t _ o r d 2e 00 73 00 6f 00 72 00 74 00 5f 00 6f 00 72 00 64 00

  • e r t e s t _ s 65 00 72 00 20 00 74 00 65 00 73 00 74 00 5f 00 73 00

  • o r t _ o r d e r 6f 00 72 00 74 00 5f 00 6f 00 72 00 64 00 65 00 72 00

  • , 2c 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                d  20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 64 00                                      
    
  • b o . p k g _ r e 62 00 6f 00 2e 00 70 00 6b 00 67 00 5f 00 72 00 65 00

  • s u l t g e t 73 00 75 00 6c 00 74 00 5f 00 5f 00 67 00 65 00 74 00

  • t e s t n a m 5f 00 74 00 65 00 73 00 74 00 5f 00 6e 00 61 00 6d 00

  • e w i t h s t 65 00 5f 00 77 00 69 00 74 00 68 00 5f 00 73 00 74 00

  • a t u s _ m i c r 61 00 74 00 75 00 73 00 5f 00 6d 00 69 00 63 00 72 00

  • o ( r q p . r e q 6f 00 28 00 72 00 71 00 70 00 2e 00 72 00 65 00 71 00

  • p a n e l i d 5f 00 70 00 61 00 6e 00 65 00 6c 00 5f 00 69 00 64 00

  • , t s t . t e s 2c 00 20 00 74 00 73 00 74 00 2e 00 74 00 65 00 73 00

  • t _ i d , r e s 74 00 5f 00 69 00 64 00 2c 00 20 00 72 00 65 00 73 00

  • . r e s u l t _ i 2e 00 72 00 65 00 73 00 75 00 6c 00 74 00 5f 00 69 00

  • d , r e s . r e 64 00 2c 00 20 00 72 00 65 00 73 00 2e 00 72 00 65 00

  • s u l t _ c o l u 73 00 75 00 6c 00 74 00 5f 00 63 00 6f 00 6c 00 75 00

  • m n _ i n d e x ) 6d 00 6e 00 5f 00 69 00 6e 00 64 00 65 00 78 00 29 00

  •  t e s t _ n a m  20 00 74 00 65 00 73 00 74 00 5f 00 6e 00 61 00 6d 00                                      
    
  • e , 65 00 2c 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  • c a s e 63 00 61 00 73 00 65 00 0d 00 0a 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •        w h e n    20 00 20 00 20 00 20 00 77 00 68 00 65 00 6e 00 20 00                                      
    
  • p n t . a c t i v 70 00 6e 00 74 00 2e 00 61 00 63 00 74 00 69 00 76 00

  • e = 0 t h e 65 00 20 00 3d 00 20 00 30 00 20 00 74 00 68 00 65 00

  • n 6e 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •      0            20 00 20 00 20 00 30 00 0d 00 0a 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •        e l s e    20 00 20 00 20 00 20 00 65 00 6c 00 73 00 65 00 0d 00                                      
    
  •                   0a 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •  t s t . a c t i  20 00 74 00 73 00 74 00 2e 00 61 00 63 00 74 00 69 00                                      
    
  • v e 76 00 65 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  • e n d a c t i v 65 00 6e 00 64 00 20 00 61 00 63 00 74 00 69 00 76 00

  • e , 65 00 2c 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  • r e s . u n i t _ 72 00 65 00 73 00 2e 00 75 00 6e 00 69 00 74 00 5f 00

  • o f _ m e a s u r 6f 00 66 00 5f 00 6d 00 65 00 61 00 73 00 75 00 72 00

  • e , 65 00 2c 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  • r e s . r e s u l 72 00 65 00 73 00 2e 00 72 00 65 00 73 00 75 00 6c 00

  • t _ r a w , 74 00 5f 00 72 00 61 00 77 00 2c 00 0d 00 0a 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •        r e s . r  20 00 20 00 20 00 20 00 72 00 65 00 73 00 2e 00 72 00                                      
    
  • e s u l t , 65 00 73 00 75 00 6c 00 74 00 2c 00 0d 00 0a 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •        t s t . m  20 00 20 00 20 00 20 00 74 00 73 00 74 00 2e 00 6d 00                                      
    
  • i c r o _ t e s t 69 00 63 00 72 00 6f 00 5f 00 74 00 65 00 73 00 74 00

  • _ t y p e , 5f 00 74 00 79 00 70 00 65 00 2c 00 0d 00 0a 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •        r e s . r  20 00 20 00 20 00 20 00 72 00 65 00 73 00 2e 00 72 00                                      
    
  • e s u l t _ i d , 65 00 73 00 75 00 6c 00 74 00 5f 00 69 00 64 00 2c 00

  •                   0d 00 0a 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •              d b  20 00 20 00 20 00 20 00 20 00 20 00 20 00 64 00 62 00                                      
    
  • o . p k g _ t e s 6f 00 2e 00 70 00 6b 00 67 00 5f 00 74 00 65 00 73 00

  • t a l i a s _ 74 00 5f 00 5f 00 61 00 6c 00 69 00 61 00 73 00 5f 00

  • r e p l a c e ( r 72 00 65 00 70 00 6c 00 61 00 63 00 65 00 28 00 72 00

  • e s . r e s u l t 65 00 73 00 2e 00 72 00 65 00 73 00 75 00 6c 00 74 00

  • _ i d , t s t . 5f 00 69 00 64 00 2c 00 20 00 74 00 73 00 74 00 2e 00

  • t e s t _ i d , 74 00 65 00 73 00 74 00 5f 00 69 00 64 00 2c 00 20 00

  • r e s . f l a g ) 72 00 65 00 73 00 2e 00 66 00 6c 00 61 00 67 00 29 00

  •  a l i a s _ f l  20 00 61 00 6c 00 69 00 61 00 73 00 5f 00 66 00 6c 00                                      
    
  • a g , 61 00 67 00 2c 00 0d 00 0a 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •  r e s . f l a g  20 00 72 00 65 00 73 00 2e 00 66 00 6c 00 61 00 67 00                                      
    
  • , 2c 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                r  20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 72 00                                      
    
  • e s . s t a t u s 65 00 73 00 2e 00 73 00 74 00 61 00 74 00 75 00 73 00

  • , 2c 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                r  20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 72 00                                      
    
  • e s . c r e a t e 65 00 73 00 2e 00 63 00 72 00 65 00 61 00 74 00 65 00

  • d _ d a t e r s 64 00 5f 00 64 00 61 00 74 00 65 00 20 00 72 00 73 00

  • c r e a t e d 5f 00 63 00 72 00 65 00 61 00 74 00 65 00 64 00 5f 00

  • d a t e , 64 00 61 00 74 00 65 00 2c 00 0d 00 0a 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •      r e s . c r  20 00 20 00 20 00 72 00 65 00 73 00 2e 00 63 00 72 00                                      
    
  • e a t e d _ u s e 65 00 61 00 74 00 65 00 64 00 5f 00 75 00 73 00 65 00

  • r e i d r s 72 00 5f 00 65 00 69 00 64 00 20 00 72 00 73 00 5f 00

  • c r e a t e d _ u 63 00 72 00 65 00 61 00 74 00 65 00 64 00 5f 00 75 00

  • s e r _ e i d , 73 00 65 00 72 00 5f 00 65 00 69 00 64 00 2c 00 0d 00

  •                   0a 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •            r s _  20 00 20 00 20 00 20 00 20 00 20 00 72 00 73 00 5f 00                                      
    
  • u s r . i n i t i 75 00 73 00 72 00 2e 00 69 00 6e 00 69 00 74 00 69 00

  • a l s r s _ c r 61 00 6c 00 73 00 20 00 72 00 73 00 5f 00 63 00 72 00

  • e a t e d _ u s e 65 00 61 00 74 00 65 00 64 00 5f 00 75 00 73 00 65 00

  • r _ i n i t i a l 72 00 5f 00 69 00 6e 00 69 00 74 00 69 00 61 00 6c 00

  • s , 73 00 2c 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  • r e s . r e f e r 72 00 65 00 73 00 2e 00 72 00 65 00 66 00 65 00 72 00

  • e n c e _ r a n g 65 00 6e 00 63 00 65 00 5f 00 72 00 61 00 6e 00 67 00

  • e _ t e x t , 65 00 5f 00 74 00 65 00 78 00 74 00 2c 00 0d 00 0a 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •          r e s .  20 00 20 00 20 00 20 00 20 00 72 00 65 00 73 00 2e 00                                      
    
  • l o w , 6c 00 6f 00 77 00 2c 00 0d 00 0a 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •    r e s . h i g  20 00 20 00 72 00 65 00 73 00 2e 00 68 00 69 00 67 00                                      
    
  • h , 68 00 2c 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  • c a s e 63 00 61 00 73 00 65 00 0d 00 0a 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •        w h e n    20 00 20 00 20 00 20 00 77 00 68 00 65 00 6e 00 20 00                                      
    
  • p n l . p a n e l 70 00 6e 00 6c 00 2e 00 70 00 61 00 6e 00 65 00 6c 00

  • _ t y p e = d 5f 00 74 00 79 00 70 00 65 00 20 00 3d 00 20 00 64 00

  • b o . p k g _ p a 62 00 6f 00 2e 00 70 00 6b 00 67 00 5f 00 70 00 61 00

  • n e l p t y _ 6e 00 65 00 6c 00 5f 00 5f 00 70 00 74 00 79 00 5f 00

  • p a i n _ t e s t 70 00 61 00 69 00 6e 00 5f 00 74 00 65 00 73 00 74 00

  • i n g _ c o d e ( 69 00 6e 00 67 00 5f 00 63 00 6f 00 64 00 65 00 28 00

  • ) t h e n 29 00 20 00 74 00 68 00 65 00 6e 00 0d 00 0a 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                r  20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 72 00                                      
    
  • e s . i s _ m e d 65 00 73 00 2e 00 69 00 73 00 5f 00 6d 00 65 00 64 00

  • i c a t e d 69 00 63 00 61 00 74 00 65 00 64 00 0d 00 0a 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •            e l s  20 00 20 00 20 00 20 00 20 00 20 00 65 00 6c 00 73 00                                      
    
  • e 65 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •      n u l l      20 00 20 00 20 00 6e 00 75 00 6c 00 6c 00 0d 00 0a 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •          e n d    20 00 20 00 20 00 20 00 20 00 65 00 6e 00 64 00 20 00                                      
    
  • i s _ m e d i c a 69 00 73 00 5f 00 6d 00 65 00 64 00 69 00 63 00 61 00

  • t e d , 74 00 65 00 64 00 2c 00 0d 00 0a 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •    c a s e        20 00 20 00 63 00 61 00 73 00 65 00 0d 00 0a 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •            w h e  20 00 20 00 20 00 20 00 20 00 20 00 77 00 68 00 65 00                                      
    
  • n p n l . p a n 6e 00 20 00 70 00 6e 00 6c 00 2e 00 70 00 61 00 6e 00

  • e l _ t y p e = 65 00 6c 00 5f 00 74 00 79 00 70 00 65 00 20 00 3d 00

  •  d b o . p k g _  20 00 64 00 62 00 6f 00 2e 00 70 00 6b 00 67 00 5f 00                                      
    
  • p a n e l p t 70 00 61 00 6e 00 65 00 6c 00 5f 00 5f 00 70 00 74 00

  • y p a i n t e 79 00 5f 00 70 00 61 00 69 00 6e 00 5f 00 74 00 65 00

  • s t i n g _ c o d 73 00 74 00 69 00 6e 00 67 00 5f 00 63 00 6f 00 64 00

  • e ( ) t h e n 65 00 28 00 29 00 20 00 74 00 68 00 65 00 6e 00 0d 00

  •                   0a 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •  r e s . i s _ c  20 00 72 00 65 00 73 00 2e 00 69 00 73 00 5f 00 63 00                                      
    
  • o n s i s t e n t 6f 00 6e 00 73 00 69 00 73 00 74 00 65 00 6e 00 74 00

  •                   0d 00 0a 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  • e l s e 65 00 6c 00 73 00 65 00 0d 00 0a 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •            n u l  20 00 20 00 20 00 20 00 20 00 20 00 6e 00 75 00 6c 00                                      
    
  • l 6c 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                e  20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 65 00                                      
    
  • n d i s _ c o n 6e 00 64 00 20 00 69 00 73 00 5f 00 63 00 6f 00 6e 00

  • s i s t e n t , 73 00 69 00 73 00 74 00 65 00 6e 00 74 00 2c 00 0d 00

  •                   0a 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •            r e s  20 00 20 00 20 00 20 00 20 00 20 00 72 00 65 00 73 00                                      
    
  • . r e s u l t _ q 2e 00 72 00 65 00 73 00 75 00 6c 00 74 00 5f 00 71 00

  • u a l i f i e r _ 75 00 61 00 6c 00 69 00 66 00 69 00 65 00 72 00 5f 00

  • c o d e , 63 00 6f 00 64 00 65 00 2c 00 0d 00 0a 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •      r e s . r e  20 00 20 00 20 00 72 00 65 00 73 00 2e 00 72 00 65 00                                      
    
  • s u l t _ q u a l 73 00 75 00 6c 00 74 00 5f 00 71 00 75 00 61 00 6c 00

  • i f i e r _ t e x 69 00 66 00 69 00 65 00 72 00 5f 00 74 00 65 00 78 00

  • t , 74 00 2c 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  • r e s . r e r u n 72 00 65 00 73 00 2e 00 72 00 65 00 72 00 75 00 6e 00

  • , 2c 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                c  20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 63 00                                      
    
  • t y . c o n t a i 74 00 79 00 2e 00 63 00 6f 00 6e 00 74 00 61 00 69 00

  • n e r t y p e 6e 00 65 00 72 00 5f 00 74 00 79 00 70 00 65 00 5f 00

  • i d , 69 00 64 00 2c 00 0d 00 0a 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •  c t y . c o n t  20 00 63 00 74 00 79 00 2e 00 63 00 6f 00 6e 00 74 00                                      
    
  • a i n e r _ t y p 61 00 69 00 6e 00 65 00 72 00 5f 00 74 00 79 00 70 00

  • e _ n a m e , 65 00 5f 00 6e 00 61 00 6d 00 65 00 2c 00 0d 00 0a 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •          c a s e  20 00 20 00 20 00 20 00 20 00 63 00 61 00 73 00 65 00                                      
    
  •                   0d 00 0a 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  • w h e n r e s . 77 00 68 00 65 00 6e 00 20 00 72 00 65 00 73 00 2e 00

  • n o t e i s n 6e 00 6f 00 74 00 65 00 20 00 69 00 73 00 20 00 6e 00

  • u l l a n d ( 75 00 6c 00 6c 00 20 00 61 00 6e 00 64 00 20 00 28 00

  • ( s e l e c t c 28 00 73 00 65 00 6c 00 65 00 63 00 74 00 20 00 63 00

  • o u n t ( r e s u 6f 00 75 00 6e 00 74 00 28 00 72 00 65 00 73 00 75 00

  • l t n o t e i 6c 00 74 00 5f 00 6e 00 6f 00 74 00 65 00 5f 00 69 00

  • d ) 64 00 29 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •          f r o m  20 00 20 00 20 00 20 00 20 00 66 00 72 00 6f 00 6d 00                                      
    
  •  r e s u l t _ n  20 00 72 00 65 00 73 00 75 00 6c 00 74 00 5f 00 6e 00                                      
    
  • o t e 6f 00 74 00 65 00 0d 00 0a 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •          w h e r  20 00 20 00 20 00 20 00 20 00 77 00 68 00 65 00 72 00                                      
    
  • e r e s u l t _ 65 00 20 00 72 00 65 00 73 00 75 00 6c 00 74 00 5f 00

  • i d = r e s . 69 00 64 00 20 00 3d 00 20 00 72 00 65 00 73 00 2e 00

  • r e s u l t _ i d 72 00 65 00 73 00 75 00 6c 00 74 00 5f 00 69 00 64 00

  • ) = 0 ) t h 29 00 20 00 3d 00 20 00 30 00 29 00 20 00 74 00 68 00

  • e n 65 00 6e 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •        c a s t (  20 00 20 00 20 00 20 00 63 00 61 00 73 00 74 00 28 00                                      
    
  • 0 a s b i t ) 30 00 20 00 61 00 73 00 20 00 62 00 69 00 74 00 29 00

  •                   0d 00 0a 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  • e l s e 65 00 6c 00 73 00 65 00 0d 00 0a 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •            c a s  20 00 20 00 20 00 20 00 20 00 20 00 63 00 61 00 73 00                                      
    
  • t ( 1 a s b i 74 00 28 00 31 00 20 00 61 00 73 00 20 00 62 00 69 00

  • t ) 74 00 29 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  • e n d h a s _ n 65 00 6e 00 64 00 20 00 68 00 61 00 73 00 5f 00 6e 00

  • o t e , 6f 00 74 00 65 00 2c 00 0d 00 0a 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •    c a s e        20 00 20 00 63 00 61 00 73 00 65 00 0d 00 0a 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •            w h e  20 00 20 00 20 00 20 00 20 00 20 00 77 00 68 00 65 00                                      
    
  • n e x i s t s 6e 00 20 00 65 00 78 00 69 00 73 00 74 00 73 00 20 00

  • ( s e l e c t 1 28 00 73 00 65 00 6c 00 65 00 63 00 74 00 20 00 31 00

  •                   20 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •              f r  20 00 20 00 20 00 20 00 20 00 20 00 20 00 66 00 72 00                                      
    
  • o m r e s u l t 6f 00 6d 00 20 00 72 00 65 00 73 00 75 00 6c 00 74 00

  • _ a t t a c h m e 5f 00 61 00 74 00 74 00 61 00 63 00 68 00 6d 00 65 00

  • n t r a 6e 00 74 00 20 00 72 00 61 00 0d 00 0a 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •  w h e r e   r a  20 00 77 00 68 00 65 00 72 00 65 00 20 00 72 00 61 00                                      
    
  • . r e s u l t _ i 2e 00 72 00 65 00 73 00 75 00 6c 00 74 00 5f 00 69 00

  • d = r e s . r 64 00 20 00 3d 00 20 00 72 00 65 00 73 00 2e 00 72 00

  • e s u l t _ i d ) 65 00 73 00 75 00 6c 00 74 00 5f 00 69 00 64 00 29 00

  •  t h e n          20 00 74 00 68 00 65 00 6e 00 0d 00 0a 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •              c a  20 00 20 00 20 00 20 00 20 00 20 00 20 00 63 00 61 00                                      
    
  • s t ( 1 a s b 73 00 74 00 28 00 31 00 20 00 61 00 73 00 20 00 62 00

  • i t ) 69 00 74 00 29 00 0d 00 0a 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •      e l s e      20 00 20 00 20 00 65 00 6c 00 73 00 65 00 0d 00 0a 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  • c a s t ( 0 a s 63 00 61 00 73 00 74 00 28 00 30 00 20 00 61 00 73 00

  •  b i t )          20 00 62 00 69 00 74 00 29 00 0d 00 0a 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •      e n d   h a  20 00 20 00 20 00 65 00 6e 00 64 00 20 00 68 00 61 00                                      
    
  • s _ a t t a c h m 73 00 5f 00 61 00 74 00 74 00 61 00 63 00 68 00 6d 00

  • e n t 65 00 6e 00 74 00 0d 00 0a 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •          f r o m  20 00 20 00 20 00 20 00 20 00 66 00 72 00 6f 00 6d 00                                      
    
  •  v w _ r e q u i  20 00 76 00 77 00 5f 00 72 00 65 00 71 00 75 00 69 00                                      
    
  • s i t i o n r e 73 00 69 00 74 00 69 00 6f 00 6e 00 20 00 72 00 65 00

  • q 71 00 0d 00 0a 00 20 00 20 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                i  20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 69 00                                      
    
  • n n e r j o i n 6e 00 6e 00 65 00 72 00 20 00 6a 00 6f 00 69 00 6e 00

  •  p a t i e n t _  20 00 70 00 61 00 74 00 69 00 65 00 6e 00 74 00 5f 00                                      
    
  • d e t a i l p a 64 00 65 00 74 00 61 00 69 00 6c 00 20 00 70 00 61 00

  • t o n p a t . 74 00 20 00 6f 00 6e 00 20 00 70 00 61 00 74 00 2e 00

  • e n t i t y _ i d 65 00 6e 00 74 00 69 00 74 00 79 00 5f 00 69 00 64 00

  •  =   r e q . p a  20 00 3d 00 20 00 72 00 65 00 71 00 2e 00 70 00 61 00                                      
    
  • t i e n t _ e i d 74 00 69 00 65 00 6e 00 74 00 5f 00 65 00 69 00 64 00

  •                   0d 00 0a 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •              i n  20 00 20 00 20 00 20 00 20 00 20 00 20 00 69 00 6e 00                                      
    
  • n e r j o i n 6e 00 65 00 72 00 20 00 6a 00 6f 00 69 00 6e 00 20 00

  • e n t i t y e n 65 00 6e 00 74 00 69 00 74 00 79 00 20 00 65 00 6e 00

  • t o n p a t . 74 00 20 00 6f 00 6e 00 20 00 70 00 61 00 74 00 2e 00

  • e n t i t y _ i d 65 00 6e 00 74 00 69 00 74 00 79 00 5f 00 69 00 64 00

  •  =   e n t . e n  20 00 3d 00 20 00 65 00 6e 00 74 00 2e 00 65 00 6e 00                                      
    
  • t i t y _ i d 74 00 69 00 74 00 79 00 5f 00 69 00 64 00 0d 00 0a 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •          i n n e  20 00 20 00 20 00 20 00 20 00 69 00 6e 00 6e 00 65 00                                      
    
  • r j o i n v w 72 00 20 00 6a 00 6f 00 69 00 6e 00 20 00 76 00 77 00

  • r e q p a n e 5f 00 72 00 65 00 71 00 5f 00 70 00 61 00 6e 00 65 00

  • l r q p o n 6c 00 20 00 72 00 71 00 70 00 20 00 6f 00 6e 00 20 00

  • r e q . r e q u i 72 00 65 00 71 00 2e 00 72 00 65 00 71 00 75 00 69 00

  • s i t i o n _ i d 73 00 69 00 74 00 69 00 6f 00 6e 00 5f 00 69 00 64 00

  •  =   r q p . r e  20 00 3d 00 20 00 72 00 71 00 70 00 2e 00 72 00 65 00                                      
    
  • q u i s i t i o n 71 00 75 00 69 00 73 00 69 00 74 00 69 00 6f 00 6e 00

  • _ i d 5f 00 69 00 64 00 0d 00 0a 00 20 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •  i n n e r   j o  20 00 69 00 6e 00 6e 00 65 00 72 00 20 00 6a 00 6f 00                                      
    
  • i n p a n e l 69 00 6e 00 20 00 70 00 61 00 6e 00 65 00 6c 00 20 00

  • p n l o n r q 70 00 6e 00 6c 00 20 00 6f 00 6e 00 20 00 72 00 71 00

  • p . p a n e l _ i 70 00 2e 00 70 00 61 00 6e 00 65 00 6c 00 5f 00 69 00

  • d = p n l . p 64 00 20 00 3d 00 20 00 70 00 6e 00 6c 00 2e 00 70 00

  • a n e l _ i d 61 00 6e 00 65 00 6c 00 5f 00 69 00 64 00 0d 00 0a 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •          i n n e  20 00 20 00 20 00 20 00 20 00 69 00 6e 00 6e 00 65 00                                      
    
  • r j o i n p a 72 00 20 00 6a 00 6f 00 69 00 6e 00 20 00 70 00 61 00

  • n e l _ t e s t 6e 00 65 00 6c 00 5f 00 74 00 65 00 73 00 74 00 20 00

  • p n t o n p n 70 00 6e 00 74 00 20 00 6f 00 6e 00 20 00 70 00 6e 00

  • t . p a n e l _ i 74 00 2e 00 70 00 61 00 6e 00 65 00 6c 00 5f 00 69 00

  • d = p n l . p 64 00 20 00 3d 00 20 00 70 00 6e 00 6c 00 2e 00 70 00

  • a n e l _ i d 61 00 6e 00 65 00 6c 00 5f 00 69 00 64 00 20 00 0d 00

  •                   0a 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •        a n d   c  20 00 20 00 20 00 20 00 61 00 6e 00 64 00 20 00 63 00                                      
    
  • o a l e s c e ( p 6f 00 61 00 6c 00 65 00 73 00 63 00 65 00 28 00 70 00

  • n l . p a n e l _ 6e 00 6c 00 2e 00 70 00 61 00 6e 00 65 00 6c 00 5f 00

  • t y p e , ' X ' 74 00 79 00 70 00 65 00 2c 00 20 00 27 00 58 00 27 00

  • ) n o t i n 29 00 20 00 6e 00 6f 00 74 00 20 00 69 00 6e 00 20 00

  • ( d b o . p k g _ 28 00 64 00 62 00 6f 00 2e 00 70 00 6b 00 67 00 5f 00

  • p a n e l p t 70 00 61 00 6e 00 65 00 6c 00 5f 00 5f 00 70 00 74 00

  • y p a i n m e 79 00 5f 00 70 00 61 00 69 00 6e 00 5f 00 6d 00 65 00

  • d i c i n e _ c o 64 00 69 00 63 00 69 00 6e 00 65 00 5f 00 63 00 6f 00

  • d e ( ) ) 64 00 65 00 28 00 29 00 29 00 0d 00 0a 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •      i n n e r    20 00 20 00 20 00 69 00 6e 00 6e 00 65 00 72 00 20 00                                      
    
  • j o i n t e s t 6a 00 6f 00 69 00 6e 00 20 00 74 00 65 00 73 00 74 00

  •  t s t   o n   t  20 00 74 00 73 00 74 00 20 00 6f 00 6e 00 20 00 74 00                                      
    
  • s t . t e s t _ i 73 00 74 00 2e 00 74 00 65 00 73 00 74 00 5f 00 69 00

  • d = p n t . t 64 00 20 00 3d 00 20 00 70 00 6e 00 74 00 2e 00 74 00

  • e s t _ i d 65 00 73 00 74 00 5f 00 69 00 64 00 0d 00 0a 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •        l e f t    20 00 20 00 20 00 20 00 6c 00 65 00 66 00 74 00 20 00                                      
    
  • j o i n v w _ r 6a 00 6f 00 69 00 6e 00 20 00 76 00 77 00 5f 00 72 00

  • e s u l t r e s 65 00 73 00 75 00 6c 00 74 00 20 00 72 00 65 00 73 00

  •  o n   r e s . r  20 00 6f 00 6e 00 20 00 72 00 65 00 73 00 2e 00 72 00                                      
    
  • e q p a n e l 65 00 71 00 5f 00 70 00 61 00 6e 00 65 00 6c 00 5f 00

  • i d = r q p . 69 00 64 00 20 00 3d 00 20 00 72 00 71 00 70 00 2e 00

  • r e q _ p a n e l 72 00 65 00 71 00 5f 00 70 00 61 00 6e 00 65 00 6c 00

  • _ i d 5f 00 69 00 64 00 20 00 0d 00 0a 00 20 00 20 00 20 00

  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •                   20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00                                      
    
  •              a n  20 00 20 00 20 00 20 00 20 00 20 00 20 00 61 00 6e 00                                      
    
  • d r e s . p a n 64 00 20 00 72 00 65 00 73 00 2e 00 70 00 61 00 6e 00



  • MODULE BASE END SIZE

  • sqlservr 00007FF79FFE0000 00007FF7A007EFFF 0009f000

  • ntd1l 00000159AC6B0000 00000159AC89CFFF 001ed000

  • kern3l32 00000159AC8A0000 00000159AC952FFF 000b3000

  • ntdll 00007FFAADB10000 00007FFAADCFCFFF 001ed000

  • KERNEL32 00007FFAAB260000 00007FFAAB312FFF 000b3000

  • KERNELBASE 00007FFAA9C00000 00007FFAA9E94FFF 00295000

  • InProcessClient64 00007FFAA9830000 00007FFAA9A51FFF 00222000

  • ADVAPI32 00007FFAACBE0000 00007FFAACC83FFF 000a4000

  • msvcrt 00007FFAACD70000 00007FFAACE0DFFF 0009e000

  • sechost 00007FFAAB440000 00007FFAAB4DDFFF 0009e000

  • RPCRT4 00007FFAAD4E0000 00007FFAAD5FEFFF 0011f000

  • CRYPT32 00007FFAAA070000 00007FFAAA252FFF 001e3000

  • ucrtbase 00007FFAA9F70000 00007FFAAA069FFF 000fa000

  • MSASN1 00007FFAA9B70000 00007FFAA9B81FFF 00012000

  • ole32 00007FFAAD2E0000 00007FFAAD435FFF 00156000

  • combase 00007FFAAAE50000 00007FFAAB17CFFF 0032d000

  • bcryptPrimitives 00007FFAAAAB0000 00007FFAAAB31FFF 00082000

  • GDI32 00007FFAAB320000 00007FFAAB348FFF 00029000

  • gdi32full 00007FFAAAB40000 00007FFAAACDBFFF 0019c000

  • msvcp_win 00007FFAA9EA0000 00007FFAA9F3FFFF 000a0000

  • USER32 00007FFAAD140000 00007FFAAD2D7FFF 00198000

  • win32u 00007FFAA9BE0000 00007FFAA9BFFFFF 00020000

  • SQLOS 00007FFA986D0000 00007FFA986D7FFF 00008000

  • NETAPI32 00007FFA9D950000 00007FFA9D966FFF 00017000

  • sqlTsEs 00007FFA92460000 00007FFA92D2BFFF 008cc000

  • pdh 00007FFA95360000 00007FFA953ACFFF 0004d000

  • OLEAUT32 00007FFAAB4E0000 00007FFAAB5A3FFF 000c4000

  • opends60 00007FFA99120000 00007FFA99128FFF 00009000

  • sqldk 00007FFA91DE0000 00007FFA9230CFFF 0052d000

  • sqlmin 00007FFA95680000 00007FFA986C7FFF 03048000

  • WS2_32 00007FFAAB350000 00007FFAAB3BCFFF 0006d000

  • MSVCP140 00007FFA9DA90000 00007FFA9DB1CFFF 0008d000

  • MPR 00007FFA9EAB0000 00007FFA9EACAFFF 0001b000

  • VCRUNTIME140 00007FFA9EAD0000 00007FFA9EAEAFFF 0001b000

  • sqllang 00007FFA92D30000 00007FFA95354FFF 02625000

  • svl 00007FFA98CA0000 00007FFA98CCCFFF 0002d000

  • WINTRUST 00007FFAAACE0000 00007FFAAAD38FFF 00059000

  • Secur32 00007FFA9FA40000 00007FFA9FA4BFFF 0000c000

  • WINHTTP 00007FFAA3F10000 00007FFAA4000FFF 000f1000

  • qds 00007FFA954A0000 00007FFA955CBFFF 0012c000

  • ODBC32 00007FFA91D20000 00007FFA91DD3FFF 000b4000

  • secforwarder 00007FFA95430000 00007FFA95440FFF 00011000

  • bcrypt 00007FFAA9F40000 00007FFAA9F65FFF 00026000

  • WINMM 00007FFAA7770000 00007FFAA7793FFF 00024000

  • VCRUNTIME140_1 00007FFA9D0A0000 00007FFA9D0ABFFF 0000c000

  • USERENV 00007FFAA9720000 00007FFAA9748FFF 00029000

  • profapi 00007FFAA9B90000 00007FFAA9BB3FFF 00024000

  • XmlLite 00007FFAA0540000 00007FFAA0579FFF 0003a000

  • AUTHZ 00007FFAA8A10000 00007FFAA8A5AFFF 0004b000

  • dhcpcsvc 00007FFAA5A20000 00007FFAA5A3BFFF 0001c000

  • NSI 00007FFAAB1E0000 00007FFAAB1E7FFF 00008000

  • WININET 00007FFA91830000 00007FFA91D10FFF 004e1000

  • ncrypt 00007FFAA93D0000 00007FFAA93F5FFF 00026000

  • WINMMBASE 00007FFAA7650000 00007FFAA767CFFF 0002d000

  • cfgmgr32 00007FFAAAA60000 00007FFAAAAA9FFF 0004a000

  • NETUTILS 00007FFAA8E00000 00007FFAA8E0DFFF 0000e000

  • NTASN1 00007FFAA9390000 00007FFAA93CBFFF 0003c000

  • SSPICLI 00007FFAA9750000 00007FFAA977EFFF 0002f000

  • DPAPI 00007FFAA9700000 00007FFAA9709FFF 0000a000

  • SAMCLI 00007FFAA0130000 00007FFAA0147FFF 00018000

  • LOGONCLI 00007FFAA8EE0000 00007FFAA8F1FFFF 00040000

  • VERSION 00007FFAA9710000 00007FFAA9719FFF 0000a000

  • psapi 00007FFAAB1F0000 00007FFAAB1F7FFF 00008000

  • kernel.appcore 00007FFAA9B50000 00007FFAA9B60FFF 00011000

  • instapi150 00007FFA8CFE0000 00007FFA8CFF3FFF 00014000

  • CRYPTSP 00007FFAA9BC0000 00007FFAA9BD6FFF 00017000

  • rsaenh 00007FFAA8C30000 00007FFAA8C62FFF 00033000

  • CRYPTBASE 00007FFAA92D0000 00007FFAA92DBFFF 0000c000

  • imagehlp 00007FFAAD440000 00007FFAAD45CFFF 0001d000

  • gpapi 00007FFAA8530000 00007FFAA8551FFF 00022000

  • wkscli 00007FFAA43F0000 00007FFAA4406FFF 00017000

  • cscapi 00007FFA8F660000 00007FFA8F671FFF 00012000

  • sqlevn70 00000159AD570000 00000159AD8ACFFF 0033d000

  • CLUSAPI 00007FFA99590000 00007FFA99699FFF 0010a000

  • DNSAPI 00007FFAA8E10000 00007FFAA8ED5FFF 000c6000

  • IPHLPAPI 00007FFAA8DC0000 00007FFAA8DFCFFF 0003d000

  • RESUTILS 00007FFA9A360000 00007FFA9A406FFF 000a7000

  • hkruntime 00007FFA88590000 00007FFA88862FFF 002d3000

  • hkcompile 00007FFA88360000 00007FFA8849FFFF 00140000

  • SHLWAPI 00007FFAAD600000 00007FFAAD651FFF 00052000

  • hkengine 00007FFA87C60000 00007FFA88355FFF 006f6000

  • dbghelp 00007FFA9E330000 00007FFA9E51CFFF 001ed000

  • ncryptprov 00007FFA9F4E0000 00007FFA9F53AFFF 0005b000

  • msv1_0 00007FFAA9080000 00007FFAA90F5FFF 00076000

  • NtlmShared 00007FFAA9070000 00007FFAA907CFFF 0000d000

  • cryptdll 00007FFAA9170000 00007FFAA9184FFF 00015000

  • kerberos 00007FFAA91C0000 00007FFAA92C1FFF 00102000

  • schannel 00007FFAA8B60000 00007FFAA8BE3FFF 00084000

  • SECURITY 0000016832060000 0000016832062FFF 00003000

  • MSCOREE 00007FFAA05D0000 00007FFAA0633FFF 00064000

  • mscoreei 00007FFA9AFD0000 00007FFA9B06BFFF 0009c000

  • SqlServerSpatial150 00007FFA87840000 00007FFA878E1FFF 000a2000

  • clbcatq 00007FFAAADA0000 00007FFAAAE41FFF 000a2000

  • msoledbsql 00007FFA875B0000 00007FFA87837FFF 00288000

  • COMDLG32 00007FFAAB5B0000 00007FFAAB6D6FFF 00127000

  • shcore 00007FFAACCC0000 00007FFAACD67FFF 000a8000

  • SHELL32 00007FFAAB6E0000 00007FFAACBD8FFF 014f9000

  • windows.storage 00007FFAAA310000 00007FFAAAA5AFFF 0074b000

  • powrprof 00007FFAA9AF0000 00007FFAA9B4CFFF 0005d000

  • COMCTL32 00007FFA955D0000 00007FFA95678FFF 000a9000

  • MSWSOCK 00007FFAA9100000 00007FFAA9166FFF 00067000

  • msxml3 00007FFA878F0000 00007FFA87B2AFFF 0023b000

  • MSOLEDBSQLR 000001683A230000 000001683A251FFF 00022000

  • dhcpcsvc6 00007FFAA5AF0000 00007FFAA5B05FFF 00016000

  • sqlncli11 00007FFA87250000 00007FFA875A2FFF 00353000

  • MSVCR100 0000000066E20000 0000000066EF1FFF 000d2000

  • SQLNCLIR11 000001683A2C0000 000001683A2F7FFF 00038000

  • netbios 00007FFA87C30000 00007FFA87C3BFFF 0000c000

  • ualapi 00007FFAA00A0000 00007FFAA00B9FFF 0001a000

  • ESENT 00007FFA9F160000 00007FFA9F48BFFF 0032c000

  • ntmarta 00007FFAA88D0000 00007FFAA8900FFF 00031000

  • sqlnclirda11 0000000066AC0000 0000000066E18FFF 00359000

  • SQLNCLIRDAR11 000001683A380000 000001683A3B7FFF 00038000

  • clr 00007FFA99970000 00007FFA9A35BFFF 009ec000

  • MSVCR120_CLR0400 00007FFA996A0000 00007FFA99796FFF 000f7000

  • mscorlib.ni 00007FFA900C0000 00007FFA91650FFF 01591000

  • SqlAccess 00007FFA87060000 00007FFA870D5FFF 00076000

  • clrjit 00007FFA8FD50000 00007FFA8FE7AFFF 0012b000

  • BatchParser 00007FFA9A7E0000 00007FFA9A809FFF 0002a000

  • SRVCLI 00007FFAA0B30000 00007FFAA0B55FFF 00026000

  • mskeyprotect 00007FFA8E050000 00007FFA8E065FFF 00016000

  • ntdsapi 00007FFA9B300000 00007FFA9B327FFF 00028000

  • DSPARSE 00007FFAA23C0000 00007FFAA23CCFFF 0000d000

  • rasadhlp 00007FFAA28D0000 00007FFAA28D9FFF 0000a000

  • fwpuclnt 00007FFAA5CF0000 00007FFAA5D68FFF 00079000

  • ncryptsslp 00007FFA8F590000 00007FFA8F5B3FFF 00024000

  • xpsqlbot 00007FFA84830000 00007FFA84839FFF 0000a000

  • xpstar 00007FFA84790000 00007FFA84801FFF 00072000

  • SQLSCM 00007FFA8CCE0000 00007FFA8CCF3FFF 00014000

  • xpstar 00000169BD2F0000 00000169BD2FCFFF 0000d000

  • sqlvdi 00007FFA818E0000 00007FFA8191AFFF 0003b000

  • xplog70 00007FFA8DE80000 00007FFA8DE95FFF 00016000

  • xplog70 00000169BD460000 00000169BD463FFF 00004000

  • odbccp32 00007FFA86A70000 00007FFA86A95FFF 00026000

  • SAMLIB 00007FFAA0100000 00007FFAA0124FFF 00025000

  • Sort00060101 00007FFA86A50000 00007FFA86A62FFF 00013000

  • System.ni 00007FFA8E270000 00007FFA8EEB3FFF 00c44000

  • System.Core.ni 00007FFA8D420000 00007FFA8DE6FFFF 00a50000

  • System.Data 00007FFA82220000 00007FFA82587FFF 00368000

  • System.Transactions 00007FFA81AB0000 00007FFA81AFEFFF 0004f000

  • System.Security.ni 00007FFA87B30000 00007FFA87C22FFF 000f3000

  • System.Xml.ni 00007FFA8C3F0000 00007FFA8CC7BFFF 0088c000


  •   P1Home: 0000015FD1D48078:  0000015FD1D48040  0000000000000000  0000000000000000  0000015FD1D48000  00000000
    

00000000 0000000000000000
P2Home: 00007FFA91DE6275: 850FC08548D08B48 43BF0F48000039F3 C8B70F44C88B4816 25850F08C75C3B48 45184B8B
4800008D 000800F98148C033
P3Home: 0000000000000000:
P4Home: 0000002C449F88D0: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 00000000
00000000 0000000000000000
P5Home: 0000000000000000:
P6Home: 0000F7840D98C344:
ContextFlags: 000000000010005F:
MxCsr: 0000000000001FA8:
SegCs: 0000000000000033:
SegDs: 000000000000002B:
SegEs: 000000000000002B:
SegFs: 0000000000000053:
SegGs: 000000000000002B:
SegSs: 000000000000002B:
EFlags: 0000000000010246:
Rax: 0000000000000078:
Rcx: 0000015C154F16D8: 00007FFA97341690 00007FFA973417D8 0000000000000005 00007FFA97332420 00000000
00000000 0000015DA494AF00
Rdx: 0000000000000000:
Rbx: 0000000000000000:
Rsp: 0000002C449F94D0: 0000000000000000 00007FFA938E21B3 0000002C449F9500 00007FFA92DC71BA 00000000
00000000 00007FFA92DFAC6A
Rbp: 0000002C449F9609: C000000000000000 0000007FFA929204 F00000015F73E96B 000000015DC5B811 00000001
5F2A411C 0000000000000000
Rsi: 0000015F73E96060: 00007FFA91FAC090 0000000200000001 0000000000002000 0000060000000012 0000015B
7A83CB80 0000002400000008
Rdi: 0000000000000000:
R8: 0000000000000078:
R9: 0000015C14FC88D8: 005F0067006B0070 0075007300650072 005F005F0074006C 005F007400650067 00740073
00650074 006D0061006E005F
R10: 0000000000000025:
R11: 0000000000000025:
R12: 00000160E82220E0: 00007FFA946D8230 00000160E82233F0 0000000000000000 0000AD9E00AB6F8A 11B63E6C
00000005 FFFFFFFFFFFFFFFF
R13: 0000015C154F1B60: 00007FFA94838500 0000015FABC88060 0000000000000000 0000015C154F16D8 0000015D
A494AF00 0000015DA494AFB8
R14: 0000000000000000:
R15: 0000015F73E96B00: 0000000000000000 00000160E8222C40 0000000000000189 0000000000000000 00000000
00000000 0000000000000000
Rip: 00007FFA956F5CCD: 0C4A5F850F013883 78428D48D2854800 0F4900000080B841 D28548108B48C044 8B48000C
4A42840F 0001D2058D4CD849
**
-------------------------------------------------------------------------------
* Short Stack Dump
00007FFA956F5CCD Module(sqlmin+0000000000075CCD)
00007FFA92DFAC6A Module(sqllang+00000000000CAC6A)
00007FFA92DCF0C8 Module(sqllang+000000000009F0C8)
00007FFA92FEBF78 Module(sqllang+00000000002BBF78)
00007FFA92FEBF21 Module(sqllang+00000000002BBF21)
00007FFA92FEBF78 Module(sqllang+00000000002BBF78)
00007FFA92FEBF21 Module(sqllang+00000000002BBF21)
00007FFA938E7064 Module(sqllang+0000000000BB7064)
00007FFA9363AB63 Module(sqllang+000000000090AB63)
00007FFA92DCAA03 Module(sqllang+000000000009AA03)
00007FFA92DB728F Module(sqllang+000000000008728F)
00007FFA92DAD3F8 Module(sqllang+000000000007D3F8)
00007FFA92DAD7EE Module(sqllang+000000000007D7EE)
00007FFA92DAC203 Module(sqllang+000000000007C203)
00007FFA92D9BBC7 Module(sqllang+000000000006BBC7)
00007FFA92D9C035 Module(sqllang+000000000006C035)
00007FFA92D42915 Module(sqllang+0000000000012915)
00007FFA92D4065F Module(sqllang+000000000001065F)
00007FFA939829EB Module(sqllang+0000000000C529EB)
00007FFA93996623 Module(sqllang+0000000000C66623)
00007FFA93996F4E Module(sqllang+0000000000C66F4E)
00007FFA92D4698F Module(sqllang+000000000001698F)
00007FFA92D3AD26 Module(sqllang+000000000000AD26)
00007FFA92D3AE53 Module(sqllang+000000000000AE53)
00007FFA91DE9E23 Module(sqldk+0000000000009E23)
00007FFA91DEA39D Module(sqldk+000000000000A39D)
00007FFA91DEA19E Module(sqldk+000000000000A19E)
00007FFA91E18242 Module(sqldk+0000000000038242)
00007FFA91E17E4C Module(sqldk+0000000000037E4C)
00007FFA91E18993 Module(sqldk+0000000000038993)
00007FFAAB277974 Module(KERNEL32+0000000000017974)
00007FFAADB6A2F1 Module(ntdll+000000000005A2F1)

CSession @0x0000015F6E37A830


m_sessionId = 135 m_cRef = 16 m_rgcRefType[0] = 1
m_rgcRefType[1] = 1 m_rgcRefType[2] = 11 m_rgcRefType[3] = 3
m_rgcRefType[4] = 0 m_rgcRefType[5] = 0 m_pmo = 0x0000015F6E37A040
m_pstackBhfPool = 0x000001613C33BFC0 m_dwLoginFlags = 0x100003e0 m_fBackground = 0
m_eConnResetOption = 0 m_fUserProc = 1 m_fConnReset = 0
m_fIsConnReset = 0 m_fInLogin = 0 m_fAuditLoginSent = 1
m_fAuditLoginFailedSent = 0 m_fReplRelease = 0 m_fKill = 0
m_ulLoginStamp = 111413 m_eclClient = 7 m_protType = 5


CUEnvTransient @0x0000015F6E37BBC0


m_ululRowcount = 25 m_cidLastOpen = 0 m_lFetchStat = -1
m_lRetStat = 0 m_lLastError = 0 m_lPrevError = 0
m_cNestLevel = 0 m_lHoldRand1 = 0 m_lHoldRand2 = 0
m_cbContextInfo = 0 m_rgbContextInfo = 0000015F6E37BDBC

CDbAndSetOpts @0x0000015F6E37BBE0


m_fHasDbRef = 0 m_fDateFirstSet = 0 m_fDateFormatSet = 0
m_lUserOpt1 = 0x14816000 m_lUserOpt2 = 0x0 m_lUserOpt1SetMask = 0xffffe7f7
m_idtInsert.objid = 0 m_idtInsert.state = 0 m_idtInsert.dbid = 0
m_llRowcnt = 0 m_lStatList = 0 m_lTextSize = -1
m_lOffsets = 0x0 m_ulLockTimeout = 4294967295 m_ulQueryGov = 0
m_eDtFmt = 1 m_eDayDateFirst = 7 m_eDdLckPri = 0
m_eIsoLvl = 2 m_eFipsFlag = 0x0 m_sLangId = 0


m_pV7LoginRec


0000000000000000: 1b010000 04000074 401f0000 00000006 14370000 .......t@........7..

0000000000000014: 00000000 e0030010 00000000 00000000 5e000b00 ....à...........^...

0000000000000028: 74000300 7a000000 9a000a00 ae000d00 c8000400 t...z... ...®...È...

000000000000003C: cc001c00 04010000 04010300 000c299c c3c50a01 Ì.............) ÃÅ..

0000000000000050: 00000a01 00000a01 00000000 0000 ..............




CPhysicalConnection @0x0000015F6E37A400


m_pPhyConn->m_pmo = 0x0000015F6E37A040
m_pPhyConn->m_pNetConn = 0x0000015F6E356040
m_pPhyConn->m_pConnList = 0x0000015F6E37A800
m_pPhyConn->m_pSess = 0x0000015F6E37A880 m_pPhyConn->m_fTracked = 1
m_pPhyConn->m_cbPacketsize = 8000 m_pPhyConn->m_fMars = 1 m_pPhyConn->m_fKill = 0


CBatch @0x0000015D9216FD90


m_pSess = 0x0000015F6E37A830 m_pConn = 0x0000015D9216EA10 m_cRef = 3
m_rgcRefType[0] = 1 m_rgcRefType[1] = 1 m_rgcRefType[2] = 1
m_rgcRefType[3] = 0 m_rgcRefType[4] = 0 m_pTask = 0x0000015AFFDDDC28


EXCEPT (null) @0x0000002C449F5918


exc_number = 0 exc_severity = 0 exc_func = sqldk.dll+0x0000000000050FB0



Task @0x0000015AFFDDDC28


CPU Ticks used (ms) = 8 Task State = 2
WAITINFO_INTERNAL: WaitResource = 0x0000000000000000 WAITINFO_INTERNAL: WaitType = 0x0
WAITINFO_INTERNAL: WaitSpinlock = 0x0000000000000000 SchedulerId = 0x3
ThreadId = 0x168c m_state = 0 m_eAbortSev = 0



EC @0x000001613C31B680


spid = 0 ecid = 0 ec_stat = 0x0
ec_stat2 = 0x0 ec_atomic = 0x0 ecType = 0
__pSETLS = 0x0000015D9216F7E0 __pSEParams = 0x0000015D9216FF50

SEInternalTLS @0x0000015D9216F7E0


m_activeHeapDatasetList = 0x0000015D9216FBF0
m_activeIndexDatasetList = 0x0000015D9216FC00 m_flags = 0
m_TLSstatus = 3 m_CriticalOpDbId = 65535 m_CloudHostDbId = 65535
m_RestoringDbId = 65535 m_RestoreTargetDbId = 0 m_isReplicatedSysDb = false
m_noLockScanCount = 0 m_readonlyDatabaseScan = false m_inCatchupRedo = false
m_pBulkOpLockNotification = 0x0000000000000000 m_pDbccContext = 0x0000000000000000
m_pCompressionContext = 0x0000000000000000
m_pRetentionCleanupContext = 0x0000000000000000 m_pAllocFileLimit = 0x0000000000000000
m_dekInstanceIndex = 0x-1 m_pImbiContext = 0x0000000000000000
m_pNcciThreadContext = 0x0000000000000000

SEParams @0x0000015D9216FF50


 m_lockTimeout = -1                      m_isoLevel = 4096                       m_logDontReplicate = 0                
 m_neverReplicate = 0                    m_XactWorkspace = 0x0000015C9760AD70                                       
 m_execStats = 0x00000160CDD13B00    





sql-server-generalsql-server-transact-sql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yufeishao-msft avatar image
0 Votes"
Yufeishao-msft answered

Hi @ReamerMarc-3981,

No one of us from the community can analyze a dump stack, you have to raise a case at Microsoft Support.
You can ask professional engineer for help from below link, and they will deal with your problem separately and confidentially. https://support.microsoft.com/en-us/assistedsupportproducts

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered ErlandSommarskog commented

I would recommend that you open a support case with Microsoft. These stack dumps are always bugs in the product, so anything you are charged initially for the the case, should be refunded to you.

It is not very fruitful to try to resolve these dumps here in the forums, as it requires access to the source.

You may however want to apply CU12 which is the latest Cumulative Update before you open a case, just in case that resolves the issue. Yeah, I saw that you said that you are on the most recent patch, but the version number in the dump is 15.0.4138, which may be CU11. I have 15.0.4153 which is CU12. I would not really hold my breath that CU12 fixes the issue, though.

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I immediately need to correct myself. These access violations are not always bugs in the product. These are things to check for before you open a case:

  • User-written extended stored procedures.

  • Unsafe assemblies.

  • Linked servers with non-Microsoft providers that run in-process.

  • Use of sp_OAxxxxx with non-Microsoft COM-objects

All these are things that could scribble server memory (which seems to happen here, since it keeps on crashing.)

0 Votes 0 ·

Thank you for replying. You're right, we are one patch behind.

I suspect it is in one of our procedures, we don't use any of the other things you've listed. I have the SQL the application runs when it hits the error, and I can run it in SSMS without issue.
It only occurs on production server after days of normal operation.
Is there any way to figure out or reproduce the what is happening?

0 Votes 0 ·

You should definitely open a case. You may be able to nail down where it happens, but it will take you quite some time. A support case will be more efficient.

1 Vote 1 ·