SUPPORT / SAMPLES & SAS NOTES
Problem Note 63832: The %TKMI_JOB_RO etl_end_service task might generate an "ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded]" error
 |  |  |  |  |
The SAS® Promotion Optimization %TKMI_JOB_RO etl_end_service task might generate the following error:
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 600, SQLState: 60000
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded], [0x2671C75E8], [6], [530300832], [], [], [], [], [], [], [], []
The error occurs after records are deleted from the RPP_PLAN_PROD_METRICS table. The error is generated because there is a hidden cap in Oracle 12c that generates an assert error if the length of a query gets too long.
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 | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.4 | 9.4 TS1M4 | ||
| Linux for x64 | 5.4 | 9.4 TS1M4 | ||||