Background: This guide is a running compilation of the most common questions our team receives concerning the AoU-EHR-File-Check script.
In particular, we will add to this a list of the most common issues that have arisen while the script has been run, and provide some solutions. For the general SOP, which includes the requirements and the procedure to run the script please see follow this link.
- What are the minimum requirements needed?
- The two requirements are (1) Python 3 (download from here and install) and (2) Pip (download get-pip.py and run python get-pip.py)
- Error: Invalid Timestamp format for SQL Server date-time2 fields.
- Solution: This is caused by the SQL Server date-time2 fields having a greater fractional second precision (7 digits) then is allowed in BigQuery (6 digits). Please convert date-time fields to a format with 6 fractional second digits. Additional information here.
- Error: Charmap Encoding Error
- Solution: This issue is caused by how the local machine saves files. Although we formerly had a separate branch for sites who were running into this issue, this fix has now been incorporated into the most recent version of the main branch.
- Error: Encoding UTF-8
- Solution: See the above response
- Error: Indices Type
- Solution: A fix for this has now been incorporated in the main branch as well.
- Error: Measure Time field is needed