Skip to content

Job request: 26456

Organisation:
University of Manchester
Workspace:
openpregnosis_main
ID:
rbsnysz6j7e7ccnb
View repo View project.yaml

This page shows the technical details of what happened when the authorised researcher Paolo Mazzone requested one or more actions to be run against real patient data within a secure environment.

By cross-referencing the list of jobs with the pipeline section below, you can infer what security level the outputs were written to.

The output security levels are:

  • highly_sensitive
    • Researchers can never directly view these outputs
    • Researchers can only request code is run against them
  • moderately_sensitive
    • Can be viewed by an approved researcher by logging into a highly secure environment
    • These are the only outputs that can be requested for public release via a controlled output review service.

Jobs

  • Action:
    export_codelists_for_r
    Status:
    Succeeded
    Job identifier:
    6wuy4mkpkprhyqj6
  • Action:
    generate_asthma_pc_data
    Status:
    Succeeded
    Job identifier:
    mewsfkbosk7rxk3n
  • Action:
    generate_asthma_hes_data
    Status:
    Failed
    Job identifier:
    ii76ma2oju47l7mo
    Status message:
    nonzero_exit: Job exited with an error: Your ehrQL is valid but it produced SQL which is too complex for the database to run; please contact tech-support so we can help you simplify it.
  • Action:
    generate_epilepsy_pc_data
    Status:
    Succeeded
    Job identifier:
    zatthsaof4xlx5tx
  • Action:
    generate_epilepsy_hes_data
    Status:
    Failed
    Job identifier:
    uymgefqetcv7nadp
    Status message:
    nonzero_exit: Job exited with an error: Your ehrQL is valid but it produced SQL which is too complex for the database to run; please contact tech-support so we can help you simplify it.
  • Action:
    convert_asthma_pc_events
    Status:
    Failed
    Job identifier:
    fquydrakxh6vg4mj
    Status message:
    nonzero_exit: Job exited with an error
  • Action:
    generate_pre_existing_hypertension_pc_data
    Status:
    Failed
    Job identifier:
    wicb3kfvwplpe2in
    Status message:
    cancelled_by_user: Cancelled by user
  • Action:
    convert_epilepsy_pc_events
    Status:
    Failed
    Job identifier:
    nl33ho3vwnyvmfai
    Status message:
    nonzero_exit: Job exited with an error
  • Action:
    generate_pre_existing_hypertension_hes_data
    Status:
    Failed
    Job identifier:
    voafuswzbgwk2czh
    Status message:
    cancelled_by_user: Cancelled by user
  • Action:
    generate_gestational_hypertension_pc_data
    Status:
    Failed
    Job identifier:
    3vgj2kbbk7rsevlc
    Status message:
    cancelled_by_user: Cancelled by user
  • Action:
    generate_gestational_hypertension_hes_data
    Status:
    Failed
    Job identifier:
    lpknoxh5aeppvwqf
    Status message:
    cancelled_by_user: Cancelled by user
  • Action:
    convert_asthma_hes_events
    Status:
    Failed
    Job identifier:
    igzenpkm2gvk3m7u
    Status message:
    dependency_failed: Not starting as dependency failed
  • Action:
    convert_epilepsy_hes_events
    Status:
    Failed
    Job identifier:
    lecfqkcuzfcv2pen
    Status message:
    dependency_failed: Not starting as dependency failed
  • Action:
    generate_gestational_diabetes_hes_data
    Status:
    Failed
    Job identifier:
    n5noighzzmgkmzvf
    Status message:
    cancelled_by_user: Cancelled by user
  • Action:
    generate_pre_existing_diabetes_pc_data
    Status:
    Failed
    Job identifier:
    wmnvhygnfzrf2dtw
    Status message:
    cancelled_by_user: Cancelled by user
  • Action:
    generate_gestational_diabetes_pc_data
    Status:
    Failed
    Job identifier:
    6ocjyg4xf4kffnm7
    Status message:
    cancelled_by_user: Cancelled by user
  • Action:
    clean_episodes_chronic_conditions
    Status:
    Failed
    Job identifier:
    gkm7c6f63axr3tc3
    Status message:
    dependency_failed: Not starting as dependency failed
  • Action:
    convert_pre_existing_hypertension_pc_events
    Status:
    Failed
    Job identifier:
    6yvyo3rmd2dg7qgj
    Status message:
    cancelled_by_user: Cancelled by user
  • Action:
    convert_pre_existing_hypertension_hes_events
    Status:
    Failed
    Job identifier:
    ip7owrjx2x7s35lb
    Status message:
    cancelled_by_user: Cancelled by user
  • Action:
    convert_pre_existing_diabetes_pc_events
    Status:
    Failed
    Job identifier:
    isguhjrn4aay3kov
    Status message:
    cancelled_by_user: Cancelled by user
  • Action:
    convert_pre_existing_diabetes_hes_events
    Status:
    Failed
    Job identifier:
    626sma63pggpgecw
    Status message:
    cancelled_by_user: Cancelled by user
  • Action:
    convert_gestational_diabetes_pc_events
    Status:
    Failed
    Job identifier:
    xxc74d6wi6r7flpy
    Status message:
    cancelled_by_user: Cancelled by user
  • Action:
    convert_gestational_diabetes_hes_events
    Status:
    Failed
    Job identifier:
    2sagmalacjry2mdx
    Status message:
    cancelled_by_user: Cancelled by user
  • Action:
    convert_gestational_hypertension_pc_events
    Status:
    Failed
    Job identifier:
    iz6d22blgqotfxbm
    Status message:
    cancelled_by_user: Cancelled by user
  • Action:
    convert_gestational_hypertension_hes_events
    Status:
    Failed
    Job identifier:
    mdtdu7b5z6kztqub
    Status message:
    cancelled_by_user: Cancelled by user
  • Action:
    chronic_conditions_prevalence_sdr_pc_hes
    Status:
    Failed
    Job identifier:
    l4xipeej5iutwhcr
    Status message:
    dependency_failed: Not starting as dependency failed
  • Action:
    generate_pre_existing_diabetes_hes_data
    Status:
    Failed
    Job identifier:
    spxovtudcys3nibn
    Status message:
    cancelled_by_user: Cancelled by user

Pipeline

Show project.yaml
This file is too large to render, try viewing it on GitHub .

Job statistics

Status Count Percentage
Pending 0 0%
Running 0 0%
Succeeded 3 11.1%
Failed 24 88.9%

27 / 27 (100%) complete

Timeline

  • Created:

  • Started:

  • Finished:

  • Runtime: 26:07:42

These timestamps are generated and stored using the UTC timezone on the TPP backend.

Job request

Status
Failed
Backend
TPP
Workspace
openpregnosis_main
Requested by
Paolo Mazzone
Branch
main
Force run dependencies
No
Git commit hash
d813045
Requested actions
  • export_codelists_for_r
  • generate_asthma_pc_data
  • generate_asthma_hes_data
  • generate_epilepsy_pc_data
  • generate_epilepsy_hes_data
  • generate_pre_existing_hypertension_pc_data
  • generate_pre_existing_hypertension_hes_data
  • generate_pre_existing_diabetes_pc_data
  • generate_pre_existing_diabetes_hes_data
  • generate_gestational_diabetes_pc_data
  • generate_gestational_diabetes_hes_data
  • generate_gestational_hypertension_pc_data
  • generate_gestational_hypertension_hes_data
  • convert_asthma_pc_events
  • convert_asthma_hes_events
  • convert_epilepsy_pc_events
  • convert_epilepsy_hes_events
  • convert_pre_existing_hypertension_pc_events
  • convert_pre_existing_hypertension_hes_events
  • convert_pre_existing_diabetes_pc_events
  • convert_pre_existing_diabetes_hes_events
  • convert_gestational_diabetes_pc_events
  • convert_gestational_diabetes_hes_events
  • convert_gestational_hypertension_pc_events
  • convert_gestational_hypertension_hes_events
  • clean_episodes_chronic_conditions
  • chronic_conditions_prevalence_sdr_pc_hes

Code comparison

Compare the code used in this job request