OpenClinica FAQs

How to fix the errors?

Error importing CRF: PATHOLOGY","java.lang.RuntimeException: Following special characters in form names not allowed: [+-/*(){}%. ]

Click here to view the solution

The error states that there are specimen characters like +-/*(){}%, whitespaces (space, tab, newline, carriage return, etc) in the CRF name. The OpenClinica connector uses the OID as the form name. These special characters are not allowed in the DE form names, hence the error.

Also when importing the OID mapping CSV file, make sure that the column ‘OS_FORM_NAME’ does not contain any special characters.

For example, a form name can be added as ‘PATHOLOGY_DATA’ and not 'PATHOLOGY DATA'

Fix: Clean up the CRFs to ensure they don't contain special characters mentioned in the log file in the CRF.

Error importing CRF data. Subject: ABC01, Event: BASELINE. Error: DE form for PATHOLOGY (Path_Data) doesn't seem to be created"

Click here to view solution

The error is displayed when the DE form ‘PATHOLOGY’ for the event ‘BASELINE’ is not yet created hence the data cannot be imported. You need to make sure that the form error is fixed and imported.

How to cleanup mapping tables?

You can clean up the Open Clinica mapping tables using the below SQLs

Find the study ID from the table 'os_oc_studies'

//SQL to cleanup the visits mapping table, where 'N' is the study ID

SQL>delete from os_oc_visits where subject_id in (select identifier from os_oc_subjects where study_id = N);

//SQL to cleanup the participant mapping table, where 'N' is the study ID

SQL>delete from os_oc_subjects where study_id = N;