Problem Note 53950: An exception might be generated when you attempt to export the Benefit Tracking table to Excel
 |  |  |  |  |
In SAS® Regular Price Optimization, an exception similar to the following might be generated when you attempt to export the Benefit Tracking table to Excel:
java.lang.IllegalArgumentException: PS item 'BACK PAGE' not found at com.sas.solutions.di.studio.rpo.benefittracking.BenefitTrackingReportWrapper.findPsItem(BenefitTrackingReportWrapper.java:236) at com.sas.solutions.di.studio.rpo.benefittracking.BenefitTrackingReportWrapper.getPSAttributeValue(BenefitTrackingReportWrapper.java:102) at com.sas.solutions.di.studio.rpo.benefittracking.BenefitTrackingReportWrapper.getItemValue(BenefitTrackingReportWrapper.java:187) at com.sas.solutions.di.studio.rpo.benefittracking.BenefitTrackingReportWrapper.sumAllWeeks(BenefitTrackingReportWrapper.java:127) at com.sas.solutions.di.studio.rpo.benefittracking.BenefitTrackingReportWrapper.getItemValue(BenefitTrackingReportWrapper.java:170) at com.sas.solutions.di.studio.rpo.benefittracking.BenefitTrackingComposite$BenefitTrackingCellValueProvider.getCellValue(BenefitTrackingComposite.java:341) at com.sas.solutions.di.commons.ui.table.internal.TableHelper.getTableContentAsString(TableHelper.java:139) at com.sas.solutions.di.commons.export.CsvExportingJob.export(CsvExportingJob.java:136) at com.sas.solutions.di.commons.export.CsvExportingJob.writeData(CsvExportingJob.java:106) at com.sas.solutions.di.commons.export.AbstractExportingJob.execute(AbstractExportingJob.java:78) at com.sas.solutions.di.commons.jobs.AbstractJob.internalExecute(AbstractJob.java:454) at com.sas.solutions.di.commons.jobs.AbstractJob.run(AbstractJob.java:420) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55) ...
This exception occurs when there is a promotion support entry in the Benefit Tracking table that has missing data.
There is no workaround for this issue.
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 Regular Price Optimization | Microsoft® Windows® for x64 | 5.2_M3 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
| Linux for x64 | 5.2_M3 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 | ||
A fix for this issue for SAS Size Optimization 3.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P21.html#53950A fix for this issue for SAS Revenue Optimization 5.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P20.html#53950| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-11-05 09:33:09 |
| Date Created: | 2014-08-19 14:36:09 |