Is it a bug in the ETLSyntheaBuilder: all_visits does not exist

[ASEKHARI]

Hi,

Similar to this issue: #188
table all_visits does not exist

I'm using CDM 5.4

ETLSyntheaBuilder::LoadEventTables(connectionDetails = cd, cdmSchema = cdmSchema, syntheaSchema = syntheaSchema, cdmVersion = cdmVersion, syntheaVersion = syntheaVersion)
Connecting using PostgreSQL driver
Running: insert_location.sql
|====================================================================================================================================================================| 100%
Executing SQL took 0.0198 secs
Running: insert_care_site.sql
|====================================================================================================================================================================| 100%
Executing SQL took 0.00703 secs
Running: insert_person.sql
|====================================================================================================================================================================| 100%
Executing SQL took 0.0136 secs
Running: insert_observation_period.sql
|====================================================================================================================================================================| 100%
Executing SQL took 0.0127 secs
Running: insert_provider.sql
|====================================================================================================================================================================| 100%
Executing SQL took 0.0106 secs
Running: insert_visit_occurrence.sql
| | 0%Error in .createErrorReport():
! Error executing SQL:
org.postgresql.util.PSQLException: ERROR: relation "cdm_synthea10.all_visits" does not exist
Position: 1145
An error report has been created at C:/Users/Laptop/Documents/errorReportSql.txt
Run rlang::last_trace() to see where the error occurred.

rlang::last_trace()
<error/rlang_error>
Error in .createErrorReport():
! Error executing SQL:
org.postgresql.util.PSQLException: ERROR: relation "cdm_synthea10.all_visits" does not exist
Position: 1145
An error report has been created at C:/Users/Laptop/Documents/errorReportSql.txt

---

Backtrace:
▆

1. └─ETLSyntheaBuilder::LoadEventTables(...)
2. └─ETLSyntheaBuilder (local) runStep(sql, fileQuery)

3. └─DatabaseConnector::executeSql(conn, sql)
   

4.   └─base::tryCatch(...)
   

5.     └─base (local) tryCatchList(expr, classes, parentenv, handlers)
   

6.       └─base (local) tryCatchOne(expr, names, parentenv, handlers[[1L]])
   

7.         └─value[[3L]](cond)
   

8.           └─DatabaseConnector:::.createErrorReport(dbms, err$message, sqlStatement, errorReportFile)
   

[ASEKHARI]

resolved, missed running a step in the process:
ETLSyntheaBuilder::CreateMapAndRollupTables(connectionDetails = cd, cdmSchema = cdmSchema, syntheaSchema = syntheaSchema, cdmVersion = cdmVersion, syntheaVersion = syntheaVersion)

full steps listed here: https://github.com/OHDSI/ETL-Synthea/blob/main/extras/codeToRun.R