SUPPORT / SAMPLES & SAS NOTES
Problem Note 34495: Export to Excel might fail in SAS® Markdown Optimization
 |  |  |  |  |
In SAS Markdown Optimization, Export to Excel might fail with the following error message in the log:
ERROR Worker-1 com.sas.solutions.di.studio.export.XlsExportingJob - [Export to Excel Format] The task "Export to Excel Format" did not complete successfully. java.lang.NullPointerException at com.sas.solutions.di.studio.export.XlsExportingJob.export(XlsExportingJob.java:334) at com.sas.solutions.di.studio.export.XlsExportingJob.exportSheet(XlsExportingJob.java:139 at com.sas.solutions.di.studio.export.XlsExportingJob.writeData(XlsExportingJob.java:103) at com.sas.solutions.di.studio.export.AbstractExportingJob.execute(AbstractExportingJob.java:75) at com.sas.solutions.di.studio.jobs.AbstractJob.internalExecute(AbstractJob.java:404) at com.sas.solutions.di.studio.jobs.AbstractJob.run(AbstractJob.java:378) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58)
This is due to null values present in the underlining data being exported.
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 Markdown Optimization | Microsoft® Windows® for x64 | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Windows Vista | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled AIX | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||