SUPPORT / SAMPLES & SAS NOTES
Problem Note 43939: A Details Table analysis runs successfully but produces an error if the analysis contains a date variable without a corresponding table entry
 |  |  |  |  |
In SAS® Warranty Analysis, a Details Table analysis might generate the following error:
Error during task (1):java.lang.ClassCastException: java.sql.Timestamp
at
com.sas.analytics.mfg.warranty.coreapi.dview.client.DecimalInputFieldValidator.f
ormatValue(DecimalInputFieldValidator.java:113)
at
com.sas.analytics.mfg.warranty.core.persistence.sql.table.TableReader.loadPage(T
ableReader.java:219)
at
com.sas.analytics.mfg.warranty.core.persistence.sql.table.TableReader.loadPage(T
ableReader.java:167)
at
com.sas.analytics.mfg.warranty.core.persistence.sql.table.TableReader.readPage(T
ableReader.java:85)
at
com.sas.analytics.mfg.warranty.core.table.FetchTablePageTask.doExecute(FetchTabl
ePageTask.java:86)
at
com.sas.analytics.mfg.warranty.core.persistence.cmd.BaseSqlTask.execute(BaseSqlT
ask.java:82)
at com.sas.analytics.mfg.queue.task.Task.run(Task.java:523)
at
com.sas.analytics.mfg.queue.jobmgmt.ExecutionQueue$TaskRunner.runTaskCode(Execut
ionQueue.java:797)
at
com.sas.analytics.mfg.queue.jobmgmt.ExecutionQueue$TaskRunner.run(ExecutionQueue
.java:624)
at java.lang.Thread.run(Thread.java:595)
Despite the error, the analysis completes successfully. This issue is like to occur when a date variable that does not have an entry in the parmsl.dataselectionattributes table is selected in a Details Table analysis.
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 Warranty Analysis | Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 for x64 | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2008 | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| 64-bit Enabled AIX | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| 64-bit Enabled Solaris | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| HP-UX IPF | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Linux for x64 | 4.3 | 6.1 | 9.2 TS2M3 | 9.4 TS1M2 | ||