We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Missing data in items when downloading a dataset

Dear community,
We are using OpenClinica 3.13 (Version: 3.13 - Changeset: 74f4df3481b6 2017-02-28 15:27 +0000), and we are facing a problem when extracting data.

We are working in a multicentre study (4 sites). We have longitudinal data on 340 subjects (expecting about 500), collected in 4 different events/CRFs. We realised we were not getting all the information from OpenClinica when downloading the dataset corresponding to one of the CRFs.

For this CRF, data has been collected using three versions of the same CRF, so we end up with a file that contains 851 variables. We download from OpenClinica all available CRFs (marked as complete and not marked as complete) in SPSS version. It takes a bit long to generate the file, but it seems to work. However, when we started working with the data, we realised there was some missing information. We could not identify the missingness pattern as it did not depend on the subject nor the CRF version. So we had some observations having empty “age” but with information on “sex” and others.

Alternatively we checked if there was any problem with the age variable, so we downloaded a dataset with this single variable and obtained all ages collected. So, we think that the problem is related to the amount of data we are trying to manage.

Has anyone encountered the same problem before? Any suggestions will be really appreciated.
Tagged:

Answers

  • GerbenRienkGerbenRienk Posts: 820 ✭✭✭
    Hi,
    I know this is a bit late, but: how many items does your dataset contain? Is it more than 3333? If so, you could be looking at https://jira.openclinica.com/browse/OC-3437 and that could be solved by adding
    maxParameterCount="10000000"
    to your server.xml.
    Kind regards,
    Gerben Rienk
Sign In or Register to comment.