OHDSI/Perseus

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

Zwky26 opened this issue · 2 comments

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'.

@Zwky26 I have added fix, please try now.

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