search

OHDSI / Perseus

[under development] Tools for ETL into OMOP CDM and deployment of OHDSI toolstack
Apache License 2.0
32 stars 8 forks source link

(Med-High Prio) Bug: Request to "Convert to CDM" breaks, path missing #4

Closed Zwky26 closed 2 years ago

Zwky26 commented 2 years ago

After connecting to an Azure SQL database, clicking the "Convert to CDM" and sending the actual request runs into error. It seems like part of requests go through, and server receives them as activity spikes, but no changes are actually finished and pushed to server. Full error message is below image

image

Creating CDM database... Warning: CDM database exists Warning: CDM schema exists Warning: CDM tables exists CDM tables truncated Loading locations... Locations was loaded Loading care sites... Care sites was loaded Loading providers... Providers was loaded Saving lookups... Lookups was saved CMSPlaceOfService - Loading ... DONE - 73 ms | KeysCount=260 CMSPlaceOfService - Uploading to File Manager... CMSPlaceOfService - Uploading DONE Could not find a part of the path '/app/ETL/Common/Scripts/PostgreSQL/DropChunkTable.sql'.

bradanton commented 2 years ago

@Zwky26 I have added fix, please try now.

Zwky26 commented 2 years ago

Tried and got a new message. This seems to be related to my postgres syntax and not any tech issue, and I am working on it. I will update if any other issues related to connections arise image