Problem Note 15898: ApplicationException and Export failure occurs due to a row limitation to Excel files
 |  |  |  |
Exports to Excel exceeding 65,535 records will cause failures in the SAS® Campaign Studio application. The problem is due to an Excel limitation in which a single worksheet can contain no more than 65,535 rows. When updating counts on the export node, you might not notice an error unless you are looking through the SAS® log, or you might recieve an error dialog stating:
Failed to export
When executing a communication node that performs an export, you might receive an application exception with this error text:
Stored Process failure on node xxx, System Error Code:1012,
Error Message: , MA Error Code:
at com.sas.analytics.crm.flow.ejb.MANode.updateFromResults
(MANode.java:3255)
...
See also SAS Note 41233 "'File error: data may have been lost' error when opening an Excel spreadsheet which has been created by a SAS Customer Intelligence Export".
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Campaign Studio | Microsoft Windows Server 2003 Standard Edition | 4.3 | 9.1 TS1M3 SP3 | ||
| Microsoft Windows XP Professional | 4.3 | 9.1 TS1M3 SP3 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 9.1 TS1M3 SP3 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 9.1 TS1M3 SP3 | ||||
| Microsoft Windows 2000 Server | 4.3 | 9.1 TS1M3 SP3 | ||||
| Microsoft Windows 2000 Advanced Server | 4.3 | 9.1 TS1M3 SP3 | ||||
| Microsoft Windows 2000 Datacenter Server | 4.3 | 9.1 TS1M3 SP3 | ||||
| Microsoft Windows 2000 Professional | 4.3 | 9.1 TS1M3 SP3 | ||||
| Type: | Problem Note |
| Priority: | low |
| Date Modified: | 2005-08-09 10:42:58 |
| Date Created: | 2005-08-09 10:42:58 |