opentrials

opentrials copied to clipboard

"ERROR: function set_updated_at() does not exist" when restoring from last dump

1

The last dump on the website is from April 1 2018. When attempting to restore it via ```pg_restore -e -v -O -x --no-owner --clean --if-exists --host=eldamar --dbname=opentrials ~/Downloads/opentrials-api-2018-04-01.dump``` It spends...

javadba

Use "results_references" field of NCT records to link with Pubmed publications

1

As seen [in this query](https://query.opentrials.net/queries/185) we currently collect references to results publications for trials from ClinicalTrials.gov. Out of 15089 `nct` records that have something in the "results_references" field, [14322 have...

georgiana-b

Stats page broken

1

When visiting the [OpenTrials stats page](https://explorer.opentrials.net/stats), both visualisations are broken (see below), suggesting a problem with https://query.opentrials.net 

benmeg

missing ClinicalTrials.gov trials

2

Hello! I've noticed that a couple of trials listed on ClinicalTrials.gov are not appearing in OpenTrials. They were added to ClinicalTrials.gov in February, and we appear to have other trials...

jessflem

Multiple ClinicalTrials.gov entries on trial/discrepancy page (matching issue?)

9

[Immunotherapy With Racotumomab in Advanced Lung Cancer](https://explorer.opentrials.net/trials/e71c001a-42bf-41f4-a843-e251a35667d0) ([discrepancies](https://explorer.opentrials.net/trials/e71c001a-42bf-41f4-a843-e251a35667d0/discrepancies)) The NCTID for this trial appears to be [NCT01460472](https://clinicaltrials.gov/ct2/show/NCT01460472) When one searches for this ID on OpenTrials, [2 results are returned](https://explorer.opentrials.net/search?q=NCT01460472): -...

benmeg

Drug Approval Package for FDA Application BLA761034 wasn't extracted

1

_This task is blocked because of #705_ Notice that on https://www.accessdata.fda.gov/scripts/cder/daf/index.cfm?event=overview.process&ApplNo=761034, we have a Label, Letter, Summary Review and a link to "Review", which goes to the Drug Approval Package...

vitorbaptista

Processors in Airflow are stuck in "Running" state

2

This is an important issue, that is currently breaking our entire data pipeline. For example, https://airflow.opentrials.net/admin/airflow/log?task_id=processor_nct&dag_id=run_all_processors&execution_date=2017-04-12T10:51:51.861748. ``` *** Log file isn't local. *** Fetching here: http://worker-1:8793/log/run_all_processors/processor_nct/2017-04-12T10:51:51.861748 [2017-04-19 19:52:41,451] {models.py:172} INFO...

vitorbaptista

For example, a data dump that happened on 01/May/2017 would be tagged as 01/Apr/2017 (see https://airflow.opentrials.net/admin/airflow/log?execution_date=2017-04-01T00%3A00%3A00&task_id=dump_api_database&dag_id=data_dumps). The fix involves changing this to the correct value: https://github.com/opentrials/opentrials-airflow/blob/ec44992c82d25eb865f25c76adc1cace8bd8815a/dags/data_dumps.py#L60

vitorbaptista

After a scrape of EUCTR has run, the `wharehouse` database still has some trials that haven't updated. For example, the last scrape here started on 5th May and finished on...

frabcus

Publication search for academic journal articles and/or HRA lay summaries

3

Currently the advanced search option 'Publications'...'Trials with publications' appears to return both trials with linked academic journal articles and HRA summaries. It would be useful to separate this out, so...

benmeg