| Issue Number | 5073 |
|---|---|
| Summary | Catch exceptions in SQL queries invoked by filters |
| Created | 2021-11-30 11:38:08 |
| Issue Type | Improvement |
| Submitted By | Kline, Bob (NIH/NCI) [C] |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2021-11-30 11:38:34 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.303346 |
Sometimes the filter module invokes a database query which triggers
an exception. For example, passing NaN as a positional
parameter for a query placeholder which expects an integer (this would
happen if the filter assumed that an attribute contained a required CDR
ID and that attribute were in fact missing). Catch and log such
exceptions and return an empty results set.
Implemented on CDR DEV.
Elapsed: 0:00:00.002022