top of page

Implementation

Error Handling

Worksheet Errors

This section lists the errors that a Worksheet could have.  

  • The Worksheet does not have the expected number of columns. 

  • The Worksheet Header column names do not have the expected number of columns.

  • The number of rows in the Worksheet matches the expected number of rows GalaxyeClinical derived from the CDASHIG PDF.

  • A Worksheet column contains a null value when CDASHIG PDF says the column should contain a string or number.

  • The length of the data in a Worksheet column is out of range according to the rules that GalaxyeClinical defined for Worksheet columns after reviewing the CDSAHIG PDF.

If the App detects a worksheet error, it: ​

  • Logs the exception.

  • Sends an email containing details about the error to cdashig@galaxyeclinical.com.

  • Redirects the user to an "Error" page.

The "Error" page asks the user to forward a copy of the logs to cdashig@galaxyeclinical.com to troubleshoot.

Third-Party Code

Third-party code that reads Excel Worksheets or performs operations on the database requires particular attention to reduce the risk of errors.  

​

To reduce risks, the eClinical MDR App wraps calls to third-party code, which performs operations on Excel spreadsheets and the database, in try/catch blocks.

​

If an error occurs, the code in the catch block logs the error, sends an email to cdashig@galaxyeclinical.com, and redirects the user to an "Error" page.

​

bottom of page