SUPPORT / SAMPLES & SAS NOTES
Problem Note 60100: When you use PRICEBY=POSITION to load cubes and query cubes, the cubes do not load, the queries fail, and a Java exception occurs
 |  |  |  |  |
In SAS® High-Performance Risk, when you are using PRICEBY=POSITION for cubes, a Java exception like the following might occur:
ERROR com.sas.analytics.riskhp.mid.DefaultHpRiskConnectionFactory - java.io.IOException: cube.load.files.failure
java.io.IOException: cube.load.files.failure
at com.sas.analytics.riskhp.mid.ProcConnection.connect(ProcConnection.java:276)
at com.sas.analytics.riskhp.mid.DefaultHpRiskConnectionFactory.handleSocketConnection(DefaultHpRiskConnectionFactory.java:686)
at com.sas.analytics.riskhp.mid.DefaultHpRiskConnectionFactory.doConnectionWork(DefaultHpRiskConnectionFactory.java:527)
at com.sas.analytics.riskhp.mid.DefaultHpRiskConnectionFactory.newConnection(DefaultHpRiskConnectionFactory.java:130)
The problem occurs if the number of threads is not greater than the number of replications. In this situation, the cube does not load in the user interface, and queries to the cube fail.
To work around this issue, set THREADS=1.
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 High-Performance Risk | Microsoft® Windows® for x64 | 3.6 | 3.7 | 9.4 TS1M3 | 9.4 TS1M4 |
| 64-bit Enabled AIX | 3.6 | 3.7 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| 64-bit Enabled Solaris | 3.6 | 3.7 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Linux for x64 | 3.6 | 3.7 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Solaris for x64 | 3.6 | 3.7 | 9.4 TS1M3 | 9.4 TS1M4 | ||