SUPPORT / SAMPLES & SAS NOTES
Problem Note 17553: Error attempting to load tables may be seen when changing marts
 |  |  |  |  |
When using SAS® Spend Analysis and changing from the default mart to other marts, the following errors may be seen:
Error attempting to load totals. Unable to execute query: SQL passthru expression contained these errors: ERROR: The SUM summary function requires a numeric argument. ERROR: Summary functions nested in this way are not supported.
There is no circumvention.
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 Supplier Relationship Management | Microsoft Windows 2000 Server | 3.5 | 3.6 | 9.1 TS1M3 SP3 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Advanced Server | 3.5 | 3.6 | 9.1 TS1M3 SP3 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 3.5 | 3.6 | 9.1 TS1M3 SP3 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 3.5 | 3.6 | 9.1 TS1M3 SP3 | 9.1 TS1M3 SP4 | ||