help with redcap page limits

[Florence Breslin]

I have a redcap problem. I’m trying to upload a randomization chart and I get the error below about the page hitting a limit. Unfortunately, our admin team cannot find where this setting it to modify it, does anyone have insight they can share as to wear this setting is located to modify?

ERROR: REDCap ran out of memory!
The current web page has hit the maximum allowed memory limit (1024MB). Please contact a REDCap administrator to inform them of this issue.

 

[Rick Watts]

This is in your system's php.ini file. As i recall there are two parameters that may need to be increased, but i forget what they are. I can look it up later or perhaps someone else can chip in?

Rick Watts

Team Lead, Research Informatics

rick....@ualberta.ca

T: (780) 248-1170 (Voicemail only)

Women and Children’s Health Research Institute

University of Alberta

5-083 Edmonton Clinic Health Academy (ECHA)

11405 87 Avenue NW Edmonton, AB T6G 1C9

F:  (780) 248-5616

    

WCHRI is a partnership between the University of Alberta and Alberta Health Services, funded by the generosity of the Stollery Children's Hospital Foundation and the Alberta Women's Health Foundation.

The University of Alberta respectfully acknowledges that we are situated on Treaty 6 territory, traditional lands of First Nations and Métis people.

--
You received this message because you are subscribed to the Google Groups "redcap open" group.
To unsubscribe from this group and stop receiving emails from it, send an email to redcap_open...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/redcap_open/11155b89-ff03-4d7b-8f2d-253fd9ee315an%40googlegroups.com.

[Florence Breslin]

thank you for the help, we got the file uploaded...now i get an error: "16137" is not a valid categorical option for the field "record_id" but i get it for every line in the .csv file from 16137 - the end

record_id  is the field we're randomizing (vs study_id which is the redcap 1-million entry id variable name)

The randomization table has ~1 million lines. 

Is this mean this is the most you can have in redcap? It seems weird that you can only random 16,000 entries.

Anyone know what this means or how you would fix it?

Thank you, 

Florence

[Rick Watts]

I'm not aware of there being a hard limit to the number of records, only a practical limit caused by the system slowing down as it processes large numbers of records. If you talk to your system admins they should be able to post a question to the REDCap Consortium's Answerhub site and someone should know the answer.

Rick Watts

Team Lead, Research Informatics

rick....@ualberta.ca

T: (780) 248-1170 (Voicemail only)

Women and Children’s Health Research Institute

University of Alberta

5-083 Edmonton Clinic Health Academy (ECHA)

11405 87 Avenue NW Edmonton, AB T6G 1C9

F:  (780) 248-5616

    

WCHRI is a partnership between the University of Alberta and Alberta Health Services, funded by the generosity of the Stollery Children's Hospital Foundation and the Alberta Women's Health Foundation.

The University of Alberta respectfully acknowledges that we are situated on Treaty 6 territory, traditional lands of First Nations and Métis people.

To view this discussion on the web visit https://groups.google.com/d/msgid/redcap_open/693cd9c3-8d53-4d0a-865d-63278c7edc55n%40googlegroups.com.

[Peter Macisaac (POP)]

Florence,

If you are using excel to manage your data then that could be the problem

Try loading the csv into another spreadsheet program - I have used open office or Mac numbers in the past

There can be hidden characters

Or try loading it into to a line editor and carefully look for hidden characters that may appear

Peter MacIsaac 

To view this discussion on the web visit https://groups.google.com/d/msgid/redcap_open/693cd9c3-8d53-4d0a-865d-63278c7edc55n%40googlegroups.com.

[Luke Stevens]

Hello Florence,

 

My guess is that you are wanting randomisation numbers rather than categorical groups for your randomisation allocation field, and have used Excel to save the project’s data dictionary before loading it. If your randomisation allocation field is named [record_id] and your randomisation schedule has around 1M rows, then that is far too much text to fit into a single cell in Excel (the limit is 32k).

 

That is, rather than something like this:

                1, Intervention | 2, Control

 

You had set up the [record_id] field choices something like this:

                1, 1000001 | 2, 1000002 | 3, 1000003 | … | 1999999, 1999999

 

But Excel has truncated this, I am guessing at this point:

                1, 1000001 | 2, 1000002 | 3, 1000003 | … | 16136, 1016136

 

That means that when you try to upload your randomisation schedule it is failing at 16137, because that is not a valid choice value for your randomisation allocation field.

 

I hope that helps.

 

Regards,

Luke

Luke Stevens
Research Data Systems Manager
Clinical Epidemiology & Biostatistics Unit (CEBU)
Murdoch Children's Research Institute
The Royal Children's Hospital, 50 Flemington Road
Parkville, Victoria 3052 Australia
T   +61 3 9345 6552
E   luke.s...@mcri.edu.au
W  mcri.edu.au

 

 

 

From: redca...@googlegroups.com <redca...@googlegroups.com> On Behalf Of Peter Macisaac (POP)
Sent: Saturday, 25 June 2022 08:50
To: Florence Breslin <fjbr...@gmail.com>
Cc: redcap open <redca...@googlegroups.com>
Subject: [EXTERNAL]Re: help with redcap page limits

 

CAUTION:  External Email. Please be cautious with attachments and clicking links

 

Peter MacIsaac 

Rick Watts

    

 

WCHRI is a partnership between the University of Alberta and Alberta Health Services, funded by the generosity of the Stollery Children's Hospital Foundation and the Alberta Women's Health Foundation.

The University of Alberta respectfully acknowledges that we are situated on Treaty 6 territory, traditional lands of First Nations and Métis people.

 

On Thu, Jun 23, 2022 at 1:32 PM Florence Breslin <fjbr...@gmail.com> wrote:

I have a redcap problem. I’m trying to upload a randomization chart and I get the error below about the page hitting a limit. Unfortunately, our admin team cannot find where this setting it to modify it, does anyone have insight they can share as to wear this setting is located to modify?

 

ERROR: REDCap ran out of memory!
The current web page has hit the maximum allowed memory limit (1024MB). Please contact a REDCap administrator to inform them of this issue.

 

 

 

--
You received this message because you are subscribed to the Google Groups "redcap open" group.
To unsubscribe from this group and stop receiving emails from it, send an email to redcap_open...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/redcap_open/11155b89-ff03-4d7b-8f2d-253fd9ee315an%40googlegroups.com.

 

--
You received this message because you are subscribed to the Google Groups "redcap open" group.
To unsubscribe from this group and stop receiving emails from it, send an email to redcap_open...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/redcap_open/693cd9c3-8d53-4d0a-865d-63278c7edc55n%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "redcap open" group.
To unsubscribe from this group and stop receiving emails from it, send an email to redcap_open...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/redcap_open/6C5C0179-249B-4BA1-8932-0589C9FDF0D1%40macisaacinformatics.org.

This e-mail and any attachments to it (the "Communication") are, unless otherwise stated, confidential, may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Murdoch Children’s Research Institute (MCRI) ABN 21 006 566 972 or any of its related entities. MCRI does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication.