Versions Compared

Key

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

How to fix the errors?

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

Expand
titleClick 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 OC 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.

...

  • Failed to authenticate with the OpenClinica OC server. Check the following: a) auth credentials b) auth server URL c) server accessibility

Expand
titleClick here to view the solution

This error occurs when the configured server URL, Username, or Password is wrong. To fix this check the below details and update if needed in the server configuration

  • Configured URL of OpenClinica OC in REST API Invoker.

  • The username used in the configuration should have access to OpenClinicaOC.

  • Password used in configuration should be in a working state.

To fix these details go to REST API Invoker >> use the ‘PUT' HTTP request >> ‘Resource URL’ as 'ServerURL/rest/ng/or-server-configs/{configured server ID}’

Once you update the necessary host, username and password click on 'Send'. You should get 200 status as a successful result.

How to cleanup mapping tables?

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

...