Problem Note 42488: An error occurs in SAS® Fair Banking when you try to sort a task list by the CRA Qualified field
 |  |  |  |  |
If you try to sort a task list by the CRA Qualified field, the following error might appear:
SAS® Fair Banking has encountered an unexpected error.
Please contact an administrator if the problem persists.
Check the SAS Fair Banking log for additional error information, such as a stack trace that begins with the following:
java.lang.RuntimeException: java.sql.SQLException: Unable to execute for an undetermined reason.
SQL passthru expression contained these errors: ERROR: Unresolved reference to table/correlation name v.
at com.sas.solutions.fairbanking.cds.service.CDSManagementDao.getOrderedRecordKeys(CDSManagementDao.java:290)
at com.sas.solutions.fairbanking.cds.service.CDSManagementService.getOrderedRecordKeys(CDSManagementService.java:86)
at com.sas.solutions.fairbanking.cds.web.action.SearchSortAction.execute(SearchSortAction.java:44)
. . .more error statements. . .
To work around this problem, set the value of the REF_TABLE_NM column to null for the row in the CDS.CDS_SEARCH_RESULT_COLUMN table where COLUMN_NM is QUALIFIED_FLG.
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 Fair Banking Server | 64-bit Enabled Solaris | 4.1 | 4.1 | 9.2 TS2M0 | 9.2 TS2M0 |
A fix for this issue for SAS Fair Banking 4.1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A25.html#42488
An error occurs in SAS® Fair Banking when you try to sort a task list by the CRA Qualified field.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2011-04-25 10:09:32 |
| Date Created: | 2011-02-23 07:55:51 |