Problem Note 59332: An "exception has been encountered" error is displayed when you run PROC HPTMINE and use data from Oracle
 |  |  |  |
In SAS® Text Miner and SAS® High-Performance Text Mining, when you run PROC HPTMINE with Oracle data, the following error message might be displayed.
ERROR: An exception has been encountered.
The problem arises when using the KEEPVAR statement to copy a long text variable from the input data set to the document projection data set.
To prevent the error, specify this option in the SVD statement:
Dbmax_text=4000
Using the DBMAX_TEXT option is recommended when text mining with Oracle data. Note that for Oracle data, the maximum value that is supported by this option is 4000 characters.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Text Miner | HP-UX IPF | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 |
| 64-bit Enabled Solaris | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| 64-bit Enabled AIX | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Ultimate x64 | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Professional x64 | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Home Premium x64 | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Enterprise x64 | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Std | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Std | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Datacenter | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 for x64 | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 R2 | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 10 | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro x64 | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro x64 | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Enterprise x64 | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft® Windows® for x64 | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Linux for x64 | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Solaris for x64 | 14.1 | 14.2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
Exception error when running PROC HPTMINE with data from Oracle
| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Data Mining Analytics ==> Text Mining |
| Date Modified: | 2016-11-15 15:47:45 |
| Date Created: | 2016-11-11 16:10:57 |