search

Research-IT-Swiss-TPH / redcap-device-tracker

Device Tracker is a REDCap External Module to cover the case for cross-project multi-device tracking.
https://research-it-swiss-tph.github.io/redcap-device-tracker/
MIT License
0 stars 0 forks source link

Module AJAX request error for device_tracker_v2.0.1 #19

Closed tertek closed 7 months ago

tertek commented 8 months ago

image

Please note: The initial error message "Uncaught Syntax Error" is related to a defect language file and has no effect on this issue. This has been checked locally and on the Prod, as the exact same Module Ajax Request error could be replicated also without having the broken language file enabled.

tertek commented 8 months ago

Issue could be partially reconstructed on local environment:

redcap_v14.0.13 device_tracker_v2.0.0 german_v12.4.12 exact copy of prod project import of 300 rows into device data at least 3 tracking fields per page (the issue does not appear to exists with one tracking field, hence 1 ajax request)

It is suspected to be a problem with concurring mysql queries on larger data sets.

There error message on local is different from prod error: Locally: Mysql gone away error: image

PROD: Unknown REDCap Error.

tertek commented 8 months ago

Possible Workaround: set timeout on subsequent ajax requests, so that database does not get too many requests at once.

tertek commented 8 months ago

https://github.com/vanderbilt-redcap/external-module-framework/issues/619

tertek commented 7 months ago

Fixed in https://github.com/vanderbilt-redcap/external-module-framework/pull/621