Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

11. com.krishagni.catissueplus.core.common.errors.OpenSpecimenException: Invalid form data. Reason: COVID_Specimen_Extension.Reason specimen not collected:INVALID_VALUE

Expand

When the OC field has any value that is not configured in the OS then this error occurs. Eg: In the ‘Clinical Diagnosis’ dropdown field has PV values like 10 weeks gestation, 13 weeks gestation, etc. but these values are not available in OS for the mapped field then the data for these subjects won’t sync.

To resolve this add the same values in the OS dropdown as OC.

12. SQL error: Data truncation: Data too long for column 'OIDS_MAPPING' at row 1. Please report this error to the system administrator. (COMMON_SQL_EXCEPTION)

Expand

When you try to add a huge number of fields in the OID mapping sheet, and the max data limit exceeds, this error occurs. The max data it can store is 64 KB.

Execute below DDL. This will ensure you can store up to 16 MB.

Code Block
alter table os_oc_studies change oids_mapping oids_mapping mediumtext;

Or else you can add only the required field as include in the OID mapping sheet. Refer to https://openspecimen.atlassian.net/wiki/spaces/CAT/pages/1919779095/OC+Study+Setup#Exclude-and-Include-CRFs for steps to import the mapping csv.