SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 31102: A segmentation-violation error might occur after you apply Hot Fix E9BA83 and you access Oracle

DetailsHotfixAboutRate It

A segmentation-violation error similar to the following example might occur after you apply Hot Fix E9BA83 and you then access Oracle:

   1  proc sql _tree;
   2  select distinct trim(left(a.name)) || "=" || "_KUNDE_" ||
   trim(left(a.name)) into :L_RENMVAR
   !  separated by ' ' from
   3 ( select name from GWGBAT.MBVARTAB(where=(alias="KUNDE") keep=alias name) 
   4   union
   5   select name from GWGBAT.MBVARS (where=(alias="KUNDE") keep=alias name)) as a
   6   left join
   7   GWGBAT.INMODFLD(where=( key="KUNDE" and spalteC1="EXINMOD")) as b
   8   on upcase(a.name) = upcase(b.name)
   9   where upcase(a.name) ne upcase(b.name) and
   10  index( "#mandant#KNDID##MANDANT#DWH_DAT#INMODGRP#",
   10! "#"||upcase(trim(left(a.name)))||"#" ) < 1 ;
   ERROR:  Write Access Violation In Task [ SQL )
   Exception occurred at (048B3F41)
   Task Traceback
   Address   Frame     (DBGHELP API Version 4.0 rev 5)
   048B3F41  04F9FD08  sassqlp:\sqlpbuf.c\sqlpbuf 377 +(0x9)
   048AB0AF  04F9FDBC  sassqlp:\sqlplan.c\sqlplan 630 +(0xD)
   048CBF3D  04F9FE68  sassqlp:\sqlprep.c\sqlprep 239 +(0xD)
   047F270F  04F9FEDC  sassqx:\sql.c\sqlloop 538 +(0xF)
   047F1C2D  04F9FF3C  sassqx:\sql.c\sqlloop 119 +(0xD)
   0454137C  04F9FF7C  sassql:\sqlmain.c\sassql 131 +(0xF)
   01865693  04F9FFA0  sashost:\vvtentr.c\vvtentr 138 +(0x23)
   0186D3B4  04F9FFB4  sashost:htthread+0x38
   7C80B683  04F9FFEC  kernel32:GetModuleFileNameA+0x1B4

Select the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to OracleMicrosoft Windows NT Workstation9.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition9.1 TS1M3 SP4
Linux on Itanium9.1 TS1M3 SP4
64-bit Enabled HP-UX9.1 TS1M3 SP4
64-bit Enabled Solaris9.1 TS1M3 SP4
64-bit Enabled AIX9.1 TS1M3 SP4
HP-UX IPF9.1 TS1M3 SP4
Microsoft Windows XP Professional9.1 TS1M3 SP4
Windows Vista9.1 TS1M3 SP4
Linux9.1 TS1M3 SP4
Tru64 UNIX9.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition9.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition9.1 TS1M3 SP4
Microsoft Windows 2000 Professional9.1 TS1M3 SP4
Microsoft Windows 2000 Server9.1 TS1M3 SP4
Microsoft® Windows® for x649.1 TS1M3 SP4
Microsoft Windows 2000 Advanced Server9.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server9.1 TS1M3 SP4
OpenVMS Alpha9.1 TS1M3 SP4
Microsoft® Windows® for 64-Bit Itanium-based Systems9.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise 64-bit Edition9.1 TS1M3 SP4
Microsoft Windows XP 64-bit Edition9.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter 64-bit Edition9.1 TS1M3 SP4
SAS SystemBase SASMicrosoft® Windows® for 64-Bit Itanium-based Systems9.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter 64-bit Edition9.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise 64-bit Edition9.1 TS1M3 SP4
Microsoft Windows XP 64-bit Edition9.1 TS1M3 SP4
Microsoft® Windows® for x649.1 TS1M3 SP4
Microsoft Windows 2000 Advanced Server9.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server9.1 TS1M3 SP4
Microsoft Windows 2000 Server9.1 TS1M3 SP4
Microsoft Windows 2000 Professional9.1 TS1M3 SP4
Microsoft Windows NT Workstation9.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition9.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition9.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition9.1 TS1M3 SP4
Microsoft Windows XP Professional9.1 TS1M3 SP4
Windows Vista9.1 TS1M3 SP4
64-bit Enabled AIX9.1 TS1M3 SP4
64-bit Enabled HP-UX9.1 TS1M3 SP4
64-bit Enabled Solaris9.1 TS1M3 SP4
HP-UX IPF9.1 TS1M3 SP4
Linux9.1 TS1M3 SP4
Linux on Itanium9.1 TS1M3 SP4
OpenVMS Alpha9.1 TS1M3 SP4
Tru64 UNIX9.1 TS1M3 SP4
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.