Sybase query error handling

Currently UV is unable to handle sybase errors that are encountered when querying the IMS examination table.

Encountered this issue on case 06305698. When sybase returns this error for one particular row UV will not display any exams at all in search results.

Error handling needs to be improved so it can return requested exams but without the error in question.

See notes from mentioned support case....

Query on Active DB (REPSITEA)

1> select study_dttm, ris_exam_id, exam_ckey from examination where study_dttm > 'Nov 7 2021 7:55PM' and study_dttm < ' Nov 7 2021 8:11PM'

2> go

study_dttm ris_exam_id exam_ckey

------------------------------- -------------------------------- -----------

Nov 7 2021 7:56PM 22-CT-21-028969 4911318

Msg 12308, Level 21, State 8:

Server 'REPSITEA', Line 1:

Internal error : Invalid row id (Row 1, Page 183303186) encountered in the table 'examination' in database 'ims'.

study_dttm ris_exam_id exam_ckey

------------------------------- -------------------------------- -----------

Nov 7 2021 8:06PM 22-CT-21-028962 4911222

Query on REPSITEB (Inactive DB)

1> select study_dttm, ris_exam_id, exam_ckey from examination where study_dttm > 'Nov 7 2021 7:55PM' and study_dttm < ' Nov 7 2021 8:11PM'

2> go

study_dttm ris_exam_id exam_ckey

------------------------------- -------------------------------- -----------

Nov 7 2021 7:56PM 22-CT-21-028969 4911318

Nov 7 2021 8:05PM 89-CT-21-023172 4911355

Nov 7 2021 8:06PM 22-CT-21-028962 4911222