Skip to content

Job request: 26463

Organisation:
University of Manchester
Workspace:
openpregnosis_main
ID:
pk4ukj4vrclcjcft
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:
    generate_chronic_conditions_hes_diagnostic_counts
    Status:
    Succeeded
    Job identifier:
    dj3arad3drpdua4f
  • Action:
    generate_chronic_conditions_pc_diagnostic_counts
    Status:
    Succeeded
    Job identifier:
    siqagapla534ltue
  • Action:
    analyse_chronic_conditions_pc_diagnostic
    Status:
    Succeeded
    Job identifier:
    l7gyw7ugxgeisptj
  • Action:
    generate_asthma_pc_data
    Status:
    Succeeded
    Job identifier:
    bdwbkctw52nvsgqf
  • Action:
    generate_epilepsy_pc_data
    Status:
    Succeeded
    Job identifier:
    yalhnak2obdxgoyj
  • Action:
    analyse_chronic_conditions_hes_diagnostic
    Status:
    Succeeded
    Job identifier:
    kvyu3blcr5nl2otl
  • Action:
    generate_asthma_hes_data
    Status:
    Failed
    Job identifier:
    oqkpxwfyij3uolon
    Error:
    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_hes_data
    Status:
    Failed
    Job identifier:
    weeljy7chaweh3g5
    Error:
    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_pre_existing_hypertension_pc_data
    Status:
    Succeeded
    Job identifier:
    zj5n3celfpzlqk6y
  • Action:
    generate_pre_existing_hypertension_hes_data
    Status:
    Succeeded
    Job identifier:
    h5u4pdnjok2uluyi
  • Action:
    generate_pre_existing_diabetes_pc_data
    Status:
    Succeeded
    Job identifier:
    iflzjfvlbgvqqzfi
  • Action:
    generate_pre_existing_diabetes_hes_data
    Status:
    Failed
    Job identifier:
    marlppfatzgwbnmp
    Error:
    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_gestational_diabetes_pc_data
    Status:
    Succeeded
    Job identifier:
    b77n56gzaf7moklm
  • Action:
    generate_gestational_diabetes_hes_data
    Status:
    Succeeded
    Job identifier:
    qrnin7ir22hd2tib
  • Action:
    generate_gestational_hypertension_pc_data
    Status:
    Succeeded
    Job identifier:
    qzyjq66apog7shkr
  • Action:
    generate_gestational_hypertension_hes_data
    Status:
    Succeeded
    Job identifier:
    d4art5chr5xuqpoq
  • Action:
    chronic_conditions_prevalence_sdr_pc_hes
    Status:
    Failed
    Job identifier:
    o65y2ugxkzq42tfn
    Error:
    dependency_failed: Not starting as dependency failed
  • Action:
    clean_episodes_chronic_conditions
    Status:
    Failed
    Job identifier:
    u6qzi42iwxolqpfz
    Error:
    dependency_failed: Not starting as dependency failed

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 13 72.2%
Failed 5 27.8%

18 / 18 (100%) complete

Timeline

  • Created:

  • Started:

  • Finished:

  • Runtime: 06:33:46

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
b47989a
Requested actions
  • generate_chronic_conditions_pc_diagnostic_counts
  • generate_chronic_conditions_hes_diagnostic_counts
  • analyse_chronic_conditions_pc_diagnostic
  • analyse_chronic_conditions_hes_diagnostic
  • 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
  • clean_episodes_chronic_conditions
  • chronic_conditions_prevalence_sdr_pc_hes

Code comparison

Compare the code used in this job request