Leave a comment at the end of this page or email contact@krishagni.com
OC FAQs and Errors
This page explains how to solve the errors faced during OC sync. You can download the error csv from the import log page, as shown in the below image.
Go to the OpenClinica Study Configuration page of the study → Click on Import Logs → Download the csv file.
Error importing CRF: PATHOLOGY","java.lang.RuntimeException: Following special characters in form names not allowed: [+-/*(){}%. ]
2. Error importing CRF data. Subject: ABC01, Event: BASELINE. Error: DE form for PATHOLOGY (Path_Data) doesn't seem to be created."
3. Error importing CRF data. Subject: ABC01, Event: SE_WEEK1FU."," com.krishagni.catissueplus.core.common.errors.OpenSpecimenException: Participant 48540 does not exist.
4. Failed to authenticate with the OC server. Check the following: a) auth credentials, b) auth server URL c) server accessibility.
5. Error: Unknown column '<table name>' in 'field list' / Error: Column 'FORM_CTXT_ID' cannot be null
6. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead. Check the manual. You have to change some columns to TEXT or BLOBs.
7. java.lang.RuntimeException: Error retrieving participants of the site: I-Spy2: 400: Error: {"message":"errorCode.studyNotExist","params":{"siteOid":null,"studyOid":"I-SPY2"}}
8. com.krishagni.catissueplus.core.common.errors.OpenSpecimenException: Parent specimen should be either in collected or missed state.
9. No anticipated specimens with labels: EP_017-00-02-07-1
10. com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '4-EP_021-00-04-01-2' for key 'CAT_SPEC_CP_ID_LABEL_UQ'
11. com.krishagni.catissueplus.core.common.errors.OpenSpecimenException: Invalid form data. Reason: COVID_Specimen_Extension.Reason specimen not collected:INVALID_VALUE
12. SQL error: 'com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'DE_A_(n)' at row 1', where n is any number.
13. 502 Bad Gateway Error. An error was encountered when invoking the OpenClinica API. The details are present in the error log file.
14. Specimen label already exists.
Leave a comment at the end of this page or email contact@krishagni.com