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 | ||
A fix for this issue for SAS High-Performance Risk 3.6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z08.html#60100A fix for this issue for SAS Risk Dimensions Server Component 6.6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z06.html#60100
In SAS® High-Performance Risk, when you use PRICEBY=POSITION for cubes, if the number of threads is not greater than the number of replications, the queries fail.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Financial Analysis |
| Date Modified: | 2018-06-25 09:36:00 |
| Date Created: | 2017-03-09 09:12:49 |