SUPPORT / SAMPLES & SAS NOTES
Problem Note 59785: Updating an Oracle table via the META engine results in a U1335 error
 |  |  |  |  |
Under z/OS, when you try to update an Oracle table using the META engine, a U1335 error might occur. The error in the JES log looks similar to the following:
14.48.12 JOB02726 IEA995I SYMPTOM DUMP OUTPUT 639
639 USER COMPLETION CODE=1335
639 TIME=14.47.20 SEQ=01478 CPU=0000 ASID=003E
639 PSW AT TIME OF ERROR 078D1400 A3911834 ILC 2 INTC 0D
639 ACTIVE LOAD MODULE ADDRESS=2390B000 OFFSET=00006834
639 NAME=SASHOST
639 DATA AT PSW 2391182E - 00181610 0A0D0000 00000000
639 GR 0: 80000000 1: 80000537
639 2: 8004A000 3: 28307FF8
639 4: 23B9F248 5: 280EBE98
639 6: 00000537 7: 00000537
639 8: 23BAE184 9: 23B9F550
639 A: 23B9F550 B: 25583100
639 C: 8004A000 D: 280EBEA8
639 E: A3B9DB58 F: 239117F0
639 END OF SYMPTOM DUMP
639 USER COMPLETION CODE=1335
639 TIME=14.47.20 SEQ=01478 CPU=0000 ASID=003E
639 PSW AT TIME OF ERROR 078D1400 A3911834 ILC 2 INTC 0D
639 ACTIVE LOAD MODULE ADDRESS=2390B000 OFFSET=00006834
639 NAME=SASHOST
639 DATA AT PSW 2391182E - 00181610 0A0D0000 00000000
639 GR 0: 80000000 1: 80000537
639 2: 8004A000 3: 28307FF8
639 4: 23B9F248 5: 280EBE98
639 6: 00000537 7: 00000537
639 8: 23BAE184 9: 23B9F550
639 A: 23B9F550 B: 25583100
639 C: 8004A000 D: 280EBEA8
639 E: A3B9DB58 F: 239117F0
639 END OF SYMPTOM DUMP
The error in the SAS® log looks similar to the following:
NOTE: Traceback called
NOTE: Module Function Offset Line
NOTE: -------- -------- ------ ----
NOTE: SASVM VMZABND 0000A8 0
NOTE: SASVM VMZPGFR 0000B2 0
NOTE: SASVM VMZGMEM 0001C8 0
NOTE: SASVM VMRPC 0006C8 0
NOTE: SASXKERN YMPOOLC 0000C0 0
NOTE: SASIOMET YOEOPEN 0001C8 0
NOTE: SASYOIO YYOOPEN 002B7C 0
NOTE: SASYOIO YOOPEN 000348 0
NOTE: SASSQLP SQLRSLV 001B20 0
NOTE: SASSQLP SQLPREP 0000BE 0
NOTE: SASSQX SQLLOOP 000A22 0
NOTE: Module Function Offset Line
NOTE: -------- -------- ------ ----
NOTE: SASVM VMZABND 0000A8 0
NOTE: SASVM VMZPGFR 0000B2 0
NOTE: SASVM VMZGMEM 0001C8 0
NOTE: SASVM VMRPC 0006C8 0
NOTE: SASXKERN YMPOOLC 0000C0 0
NOTE: SASIOMET YOEOPEN 0001C8 0
NOTE: SASYOIO YYOOPEN 002B7C 0
NOTE: SASYOIO YOOPEN 000348 0
NOTE: SASSQLP SQLRSLV 001B20 0
NOTE: SASSQLP SQLPREP 0000BE 0
NOTE: SASSQX SQLLOOP 000A22 0
The only workaround is to use the Oracle engine rather than the META engine.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Base SAS | z/OS | 9.4_M3 | 9.4_M3 | 9.4 TS1M3 | 9.4 TS1M5 |
| z/OS 64-bit | 9.4_M3 | 9.4_M3 | 9.4 TS1M3 | 9.4 TS1M5 | ||