Skip to main content

Error - 'Conversion failed when converting the varchar value 'XXXX' to data type smallint' when clicking the documents tab in LIMS

This error is likely to have occurred because the Document is being instructed to show on the Web Kiosk / Web portal.
​
The setting which controls this is a flag against the Document type of the File in the Documents tab. For example, if your documents are PDF's then:

  1. Click System Admin, Setup, Document Types

  2. Scroll to the document type for PDF's

  3. The option to 'Show on Portal' will be set to Yes

  4. Change this to No to resolve the error

  5. Click Apply.

Did this answer your question?