Problem Note 52591: Custom cell actions that invoke a stored process fail in SAS® Financial Management
 |  |  |  |  |
By default, when you select a data cell and right-click the cell, the Contributing Data action is available. The Contributing Data action enables you to view the data records that make up the selected cell.
You can add custom actions that invoke a stored process that displays its output in a browser window. For example, you might create a custom action that displays the transactions that make up the selected cell.
A problem has been identified, which causes the custom cell action to fail. For example, if you define the custom action View Transactions as documented in the SAS Financial Management 5.4 Customization Guide and you select the custom action while you are in Excel, a stored process runs and should display the results either in Excel or in the portal. Instead, the stored process fails with an error similar to the following:
2014-03-19T12:17:33,449 INFO [00000403] 4:sasdemo@SASBAP - NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 2014-03-19T12:17:33,449 INFO [00000403] 4:sasdemo@SASBAP -139:205 139:106 139:240 2014-03-19T12:17:33,449 INFO [00000403] 4:sasdemo@SASBAP - 03-19 12:17:32,541 [Thread-3][ERROR MultiThreadedModel] - Exception occured: 2014-03-19T12:17:33,449 INFO [00000403] 4:sasdemo@SASBAP - 03-19 12:17:32,543 [Thread-0][ERROR MultiThreadedModel] - Attempting to retrieve file, when an error occured: 2014-03-19T12:17:33,449 INFO [00000403] 4:sasdemo@SASBAP - com.sas.solutions.finance.models.FinanceClientException: com.sas.solutions.finance.models.FinanceServerException: Member : does not exist in dimension type ACCOUNT 2014-03-19T12:17:33,449 INFO [00000403] 4:sasdemo@SASBAP - at com.sas.solutions.finance.models.core.client.SASQueryManagerDelegate. executeQuery(SASQueryManagerDelegate.java:103) 2014-03-19T12:17:33,449 INFO [00000403] 4:sasdemo@SASBAP - at com.sas.solutions.finance.api.Model.executeSingleQueryLocal(Model.java:760)
The SASFinancialManagement5.4 log will contain an error similar to the following:
03-19 12:17:32,395 tomcat-http--48 ERROR SASQueryManagerBean executeQuery() - u:sasdemo - com.sas.solutions.finance.models.FinanceServerException: Member : does not exist in dimension type ACCOUNT at com.sas.solutions.finance.models.core.ejb.SASQueryManagerBean.getQueryArguments (SASQueryManagerBean.java:999) at com.sas.solutions.finance.models.core.ejb.SASQueryManagerBean.executeQuery (SASQueryManagerBean.java:480) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
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 Financial Management | Microsoft Windows 8 Enterprise 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 |
| Microsoft Windows 8 Enterprise x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Pro 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Pro x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Enterprise x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Pro | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Pro 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 Datacenter | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 R2 Std | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 Std | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Enterprise 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Enterprise x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Home Premium 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Home Premium x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Professional 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Professional x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Ultimate 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Ultimate x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| 64-bit Enabled AIX | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| 64-bit Enabled Solaris | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Linux for x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
A fix for this issue for SAS Financial Management 5.4_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/N81.html#52591| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2014-07-17 14:19:31 |
| Date Created: | 2014-03-19 12:27:06 |