34649 - An abend occurs when you run SAS® 9.1.3 with the Oracle 10.2 patch B6864066

Usage Note 34649: An abend occurs when you run SAS® 9.1.3 with the Oracle 10.2 patch B6864066

Either an S0C6 or a U2096 abend occurs when you run SAS 9.1.3 in the z/OS environment and you have applied the Oracle 10.2 patch b6864066.

For example, if you attempt to open, in succession, two Oracle tables that are allocated via a metadata server, the following exception occurs:

   com.sas.wadmin.viewdata2.ViewDataException: com.sas.workspace.WsAppServerFailExc
    eption: sam.S235.ex.msg: An exception was thrown while reading a packet header f
    rom the socket.
            at com.sas.wadmin.viewdata2.impl.MetadataConnectionManager.init(Metadata
    ConnectionManager.java:181)
            at com.sas.wadmin.viewdata2.impl.PhysicalTableBrowseFactory.createConnec
    tionManager(PhysicalTableBrowseFactory.java:100)
            at com.sas.wadmin.viewdata2.ViewDataAbstractFactory.createDefaultConnect
    ionManager(ViewDataAbstractFactory.java:69)
            at com.sas.wadmin.viewdata2.impl.PhysicalTableBrowseFactory.isDatasetEdi
    table(PhysicalTableBrowseFactory.java:260)
            at com.sas.wadmin.viewdata2.impl.PhysicalTablePanel.createFactory(Physic
    alTablePanel.java:289)
            at com.sas.wadmin.viewdata2.ViewDataPanel.initializeImpl(ViewDataPanel.j
    ava:184)
            at com.sas.wadmin.viewdata2.ViewDataPanel$1.run(ViewDataPanel.java:169)
    Caused by: com.sas.workspace.WsAppServerFailException: sam.S235.ex.msg: An excep
    tion was thrown while reading a packet header from the socket.
            at com.sas.workspace.WsAppServer.submitSASCode(WsAppServer.java:1430)
            at com.sas.workspace.WsAppServer.assignLibref(WsAppServer.java:2107)
            at com.sas.workspace.LibraryUtil.interactiveAccessPath(LibraryUtil.java:
    313)
            at com.sas.workspace.LibraryUtil.interactiveAccessPath(LibraryUtil.java:
    179)
            at com.sas.wadmin.viewdata2.impl.MetadataConnectionManager.initAppServer
    (MetadataConnectionManager.java:357)
            at com.sas.wadmin.viewdata2.impl.MetadataConnectionManager.init(Metadata
    ConnectionManager.java:172)
          ... 6 more

In addition, the system console log contains the following:


   IEA995I SYMPTOM DUMP OUTPUT 269
      USER COMPLETION CODE=2096
     TIME=17.36.45  SEQ=34815  CPU=0000  ASID=013F
     PSW AT TIME OF ERROR  078D1000   9A0E6FD4  ILC 2  INTC 0D
       ACTIVE LOAD MODULE           ADDRESS=1A0E0B48  OFFSET=0000648C
       NAME=SASHOST
       DATA AT PSW  1A0E6FCE - 00181610  0A0D0000  00000000
       AR/GR 0: 00000000/00000000_80000000   1: 00000002/00000000_80000830
             2: FFFFFFFF/00000000_1A2AC000   3: FFFFFFFF/FFFFFFFF_00000000
             4: FFFFFFFF/FFFFFFFF_1A14CAA8   5: FFFFFFFF/FFFFFFFF_1A14C7C8
             6: FFFFFFFF/FFFFFFFF_8000301F   7: FFFFFFFF/FFFFFFFF_0000000E
             8: FFFFFFFF/FFFFFFFF_1B1257B8   9: FFFFFFFF/FFFFFFFF_FFFFBFFF
             A: FFFFFFFF/FFFFFFFF_1A2ADD48   B: FFFFFFFF/FFFFFFFF_00000001
             C: FFFFFFFF/FFFFFFFF_8001D000   D: 00000000/00000000_1B11F700
             E: 00000000/00000000_9A14C9C0   F: 00000000/00000000_1A0E6F90
     END OF SYMPTOM DUMP
    BPXP018I THREAD 1A374D5000000006, IN PROCESS 33556754, ENDED 270 WITHOUT BEING
    UNDUBBED WITH COMPLETION CODE 80000830, AND REASON CODE 00000000.
    IEA995I SYMPTOM DUMP OUTPUT 271
    SYSTEM COMPLETION CODE=0C4  REASON CODE=00000011
     TIME=17.36.45  SEQ=34816  CPU=0000  ASID=013F
     PSW AT TIME OF ERROR  078D2000   99FEF3F4  ILC 4  INTC 11
       ACTIVE LOAD MODULE           ADDRESS=19FB35F0  OFFSET=0003BE04
       NAME=TKL4SAS
       DATA AT PSW  19FEF3EE - 1299A784  00075800  900C1200
       AR/GR 0: 00000000/00000000_00000100   1: 00000000/00000000_19AE0450
             2: FFFFFFFF/FFFFFFFF_19B15488   3: FFFFFFFF/FFFFFFFF_19AE3AD0
             4: FFFFFFFF/FFFFFFFF_19FF1060   5: FFFFFFFF/FFFFFFFF_19FEF310
             6: FFFFFFFF/FFFFFFFF_1A000530   7: FFFFFFFF/FFFFFFFF_19ADF6A0
             8: FFFFFFFF/FFFFFFFF_1A0AA230   9: FFFFFFFF/FFFFFFFF_1A7ECE34
             A: FFFFFFFF/FFFFFFFF_19ADFF80   B: FFFFFFFF/FFFFFFFF_19FF1360
             C: FFFFFFFF/FFFFFFFF_00017C90   D: 00000000/00000000_19ADFFA8
             E: 00000000/00000000_99FEF3D6   F: 00000002/00000010_00000000
     END OF SYMPTOM DUMP
    IEA989I SLIP TRAP ID=X13E MATCHED.  JOBNAME=DWATEST3, ASID=013F.
    BPXP018I THREAD 1A47D5E00000000E, IN PROCESS 33556754, ENDED 273 WITHOUT BEING
    UNDUBBED WITH COMPLETION CODE 040C4000, AND REASON CODE 00000011.
    IEA989I SLIP TRAP ID=X13E MATCHED.  JOBNAME=DWATEST3, ASID=013F.
    BPXP018I THREAD 1A498AB00000000D, IN PROCESS 33556754, ENDED 275 WITHOUT BEING
    UNDUBBED WITH COMPLETION CODE 040C4000, AND REASON CODE 00000011.
    IEA989I SLIP TRAP ID=X13E MATCHED.  JOBNAME=DWATEST3, ASID=013F.
    BPXP018I THREAD 1A466C600000000C, IN PROCESS 33556754, ENDED 277 WITHOUT BEING
    UNDUBBED WITH COMPLETION CODE 040C4000, AND REASON CODE 00000011.
    IEA989I SLIP TRAP ID=X13E MATCHED.  JOBNAME=DWATEST3, ASID=013F.
    BPXP018I THREAD 1A4612000000000B, IN PROCESS 33556754, ENDED 279 WITHOUT BEING
    UNDUBBED WITH COMPLETION CODE 040C4000, AND REASON CODE 00000011.
    IEA989I SLIP TRAP ID=X13E MATCHED.  JOBNAME=DWATEST3, ASID=013F.
    BPXP018I THREAD 1A45E4D00000000A, IN PROCESS 33556754, ENDED 281 WITHOUT BEING
    UNDUBBED WITH COMPLETION CODE 040C4000, AND REASON CODE 00000011.
    IEA989I SLIP TRAP ID=X13E MATCHED.  JOBNAME=DWATEST3, ASID=013F.
    IEA995I SYMPTOM DUMP OUTPUT 283
    SYSTEM COMPLETION CODE=0C4  REASON CODE=00000011
     TIME=17.36.45  SEQ=34822  CPU=0000  ASID=013F
     PSW AT TIME OF ERROR  078D1000   99B2386C  ILC 6  INTC 11
       ACTIVE LOAD MODULE           ADDRESS=19AF1460  OFFSET=0003240C
       NAME=SASTK
       DATA AT PSW  19B23866 - A0545820  4090D503  30002000
       GR 0: 803FC21E   1: 0002B560
          2: 19AFD018   3: 1A334818
          4: 19B238E8   5: 19B23310
          6: 1A928FC8   7: 99FEF3F4
          8: 803FC217   9: 19AE3AD0
          A: 1A211008   B: 1ABA61F8
          C: 0002BC90   D: 1ABC5CC0
          E: 99B23492   F: 0002BC90
     END OF SYMPTOM DUMP
    BPXP018I THREAD 1A417B2000000009, IN PROCESS 33556754, ENDED 284 WITHOUT BEING
    UNDUBBED WITH COMPLETION CODE 940C4000, AND REASON CODE 00000011.
    IEA989I SLIP TRAP ID=X13E MATCHED.  JOBNAME=DWATEST3, ASID=013F.
    BPXP018I THREAD 1A36201000000007, IN PROCESS 33556754, ENDED 286 WITHOUT BEING
    UNDUBBED WITH COMPLETION CODE 040C4000, AND REASON CODE 00000011.
    IEA989I SLIP TRAP ID=X13E MATCHED.  JOBNAME=DWATEST3, ASID=013F.
    BPXP018I THREAD 1A35200000000005, IN PROCESS 33556754, ENDED 288 WITHOUT BEING
    UNDUBBED WITH COMPLETION CODE 040C4000, AND REASON CODE 00000011.
    BPXP018I THREAD 1A3401D000000004, IN PROCESS 33556754, ENDED 289 WITHOUT BEING
    UNDUBBED WITH COMPLETION CODE 940C4000, AND REASON CODE 00000011.

The actual error that you receive can vary.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS/ACCESS Interface to Oracle	z/OS	9.1 TS1M3 SP4	9.2 TS1M0

* 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.

Type:	Usage Note
Priority:
Topic:	Data Management ==> Data Sources ==> External Databases ==> Oracle

Date Modified:	2009-09-23 13:26:52
Date Created:	2009-01-30 12:54:44

Support

Usage Note 34649: An abend occurs when you run SAS® 9.1.3 with the Oracle 10.2 patch B6864066

Operating System and Release Information