We’re in the process of setting up a local instance of OMOP using Synthea data in Postgresql for reference purposes.
We are currently using the instructions/guidance outlined on the OHDSI/ETL-Synthea github page and the synthea wiki at the links below:
The R script we are running is shown below. It looks like the concept tables load and most of the other tables load but we are getting the errors shown below. The entire script is attached (we renamed to .xml, it’s really a .Rmd file). The entire error report is also attached.
What should we be doing differently?
— ERROR MESSAGE -----------------------
Executing SQL took 0.071 secs
| | 0%Error: Error executing SQL:
org.postgresql.util.PSQLException: ERROR: value
too long for type character varying(50)
An error report has been created at C:/_WORKSPACES/_ECLIPSE_WORKSPACE/workspace/OMOP-Synthia/omop-synthea-etl/errorReportSql.txt
rlang::last_error() to see where the error occurred.
SYNTHEA_ETL.Rmd.xml (1.8 KB)
errorReportSql.xml (2.4 KB)