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 | ||||
A fix for this issue for SAS Revenue Optimization 5.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B3R.html#63832A fix for this issue for SAS Size Optimization 3.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D3R.html#63832| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-12-06 13:38:56 |
| Date Created: | 2019-03-12 10:45:57 |