SUPPORT / SAMPLES & SAS NOTES
Problem Note 64746: "The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook" error occurs in SAS® Risk and Finance Workbench
 |  |  |  |  |
You might encounter the following error when running a Preview Landing Area Data report for a large data set in SAS Risk and Finance Workbench:
ERROR com.sas.stress.rest.services.ReportService - Exception while running report: Preview Landing Area Data (LE_package_test)com.sas.stress.exception.StressException: The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook
at com.sas.risk.output.generators.PackageReportGenerator.generate(PackageReportGenerator.java:166)
at com.sas.stress.rest.services.ReportService.generateReport(ReportService.java:238)
at com.sas.stress.rest.services.ReportService$ReportGenerationRunnable.runInTransaction(ReportService.java:405)
at com.sas.stress.runnable.TransactionalRunnable$1.doInTransaction(TransactionalRunnable.java:63)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)
at com.sas.stress.runnable.TransactionalRunnable.run(TransactionalRunnable.java:55)
at com.sas.stress.rest.services.ReportService$ReportLauncherThread.run(ReportService.java:316)
Caused by: java.lang.IllegalStateException: The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook
at com.sas.risk.output.generators.PackageReportGenerator.generate(PackageReportGenerator.java:166)
at com.sas.stress.rest.services.ReportService.generateReport(ReportService.java:238)
at com.sas.stress.rest.services.ReportService$ReportGenerationRunnable.runInTransaction(ReportService.java:405)
at com.sas.stress.runnable.TransactionalRunnable$1.doInTransaction(TransactionalRunnable.java:63)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)
at com.sas.stress.runnable.TransactionalRunnable.run(TransactionalRunnable.java:55)
at com.sas.stress.rest.services.ReportService$ReportLauncherThread.run(ReportService.java:316)
Caused by: java.lang.IllegalStateException: The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook
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 Risk and Finance Workbench | Microsoft® Windows® for x64 | 3.1 | 9.4 TS1M5 | ||
| Linux for x64 | 3.1 | 9.4 TS1M5 | ||||