Problem Note 62462: Two indexes are not dropped when you use an Oracle database and update SAS® Model Implementation Platform 2.3 or 2.4 to the 3.1 release
 |  |  |  |  |
When you use an Oracle database and migrate SAS Model Implementation Platform 2.3 or 2.4 to the 3.1 release, two indexes are not dropped.
The impact is as follows.
If RUN_EXECUTION_PK is not dropped, you cannot run more than a single attribution analysis.
If RUN_INSTANCE_RESULT_PK is not dropped, you can submit multiple attribution analyses, but the runs do not complete. The runs stop responding and have no forward progress.
To remove the indexes, execute the following DROP statements:
- drop index RUN_EXECUTION_PK;
- drop index RUN_INSTANCE_RESULT_PK;
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 Model Implementation Platform | Windows 7 Professional x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 |
| Windows 7 Professional 32 bit | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Home Premium x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Home Premium 32 bit | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Enterprise x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Enterprise 32 bit | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Std | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Std | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Datacenter | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 for x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 R2 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 10 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro 32-bit | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro 32-bit | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Enterprise x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Enterprise 32-bit | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft® Windows® for x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Ultimate 32 bit | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Ultimate x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Linux for x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
A fix for this issue for SAS Model Implementation Platform 3.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C9P.html#62462
The RUN_EXECUTION_PK and RUN_INSTANCE_RESULT_PK indexes are not dropped when you use an Oracle database and you migrate SAS Model Implementation Platform 2.3 or 2.4 to the 3.1 release.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Financial Analysis |
| Date Modified: | 2018-06-19 16:01:47 |
| Date Created: | 2018-06-13 14:59:02 |