Problem Note 36580: Too many currencies to set the bits in a long
 |  |  |  |  |
The following error might occur when creating a Read-only Table in Microsoft Excel using the SAS® Financial Management Add-in for Microsoft Excel. Additionally, pink cells might be displayed in the table.
ERROR [QueryManager] Too many currencies to set the bits in a long
java.lang.RuntimeException: Too many currencies to set the bits in a long
at com.sas.solutions.odcs.query.fm.account.RadixTimespanAggregator.setSize(RadixTimespanAggregator.java:437)
at com.sas.solutions.odcs.query.fm.account.RadixTimespanAggregator.setSize(RadixTimespanAggregator.java:409)
at com.sas.solutions.odcs.query.AccountingNode.allocateRTAs(AccountingNode.java:1997)
at com.sas.solutions.odcs.query.AccountingNode.prepareForFactIteration(AccountingNode.java:1967)
at com.sas.solutions.odcs.query.ChunkGraph.addEntries(ChunkGraph.java:167)
at com.sas.solutions.odcs.query.Query.processGraph(Query.java:471)
at com.sas.solutions.odcs.query.Query.execute(Query.java:303)
at com.sas.solutions.odcs.processor.QueryRequest.execute(QueryRequest.java:55)
at com.sas.solutions.odcs.processor.QueryProcessor.execute(QueryProcessor.java:155)
at com.sas.solutions.odcs.dispatcher.ProcessorThread.run(ProcessorThread.java:157)
at java.lang.Thread.run(Thread.java:534)
Beginning with SAS Financial Management 4.4 there is a limit of 61 currencies in a fact set. Having more than 61 currencies will cause this error to be displayed.
Select 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 2000 Advanced Server | 4.4 | |||
| Microsoft Windows 2000 Datacenter Server | 4.4 | |||||
| Microsoft Windows 2000 Server | 4.4 | |||||
| Microsoft Windows 2000 Professional | 4.4 | |||||
| Microsoft Windows Server 2003 Datacenter Edition | 4.4 | 5.1 | 9.2 TS2M2 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 4.4 | 5.1 | 9.2 TS2M2 | |||
| Microsoft Windows Server 2003 Standard Edition | 4.4 | 5.1 | 9.2 TS2M2 | |||
| Microsoft Windows Server 2008 | 4.4 | 5.1 | 9.2 TS2M2 | |||
| Microsoft Windows XP Professional | 4.4 | 5.1 | 9.2 TS2M2 | |||
| 64-bit Enabled AIX | 4.4 | |||||
| 64-bit Enabled Solaris | 4.4 | |||||