Endlosschleife bei fehlerhaftem SQL statement
Version:
R: 4.1.0
DIZutils: 0.0.8.9007
DQAstats: 0.1.7
DQAgui: 0.1.6
miRacumDQA: 2.1.2
Durch folgenden Fehler im SQL statement
[Error] Error while trying to get the data for element 'dt.admission'. The sql was 'SELECT b.visit_occurrence_id AS "encounter_identifier_value", a.observation_source_value AS "encounter_hospitalization_admitSource" FROM p21_cdm.visit_occurrence AS b LEFT OUTER JOIN ( SELECT visit_occurrence_id, observation_source_value FROM p21_cdm.observation WHERE observation_type_concept_id = 43542355 AND observation_concept_id IN (4164916, 4194310, 4138807, 4216316, 4079617, 4146925, 4123917)) AS a ON a.visit_occurrence_id = b.visit_occurrence_id'. The error message is: 'Error: Failed to prepare query: ERROR: relation "p21_cdm.visit_occurrence" does not exist
LINE 1: ...e AS "encounter_hospitalization_admitSource" FROM p21_cdm.vi...
^
'. (c5291c15e3)
[Error] Error in value[[3L]](cond): See error above.
gibt es eine Endlosschleife in der GUI, die nicht abgebrochen werden kann. Es erscheint die Oooops Fehlermeldung und die Seite reloaded sich permanent.