Windows build of core-keeper fails due to missing SQL files #5261
Description
🐞 Bug Report
Affected Services [REQUIRED]
The issue is located in: core-keeper (Windows build)
Is this a regression?
n/a – not sure if this was working in earlier versions on Windows.
Description and Minimal Reproduction [REQUIRED]
I built core-keeper on a Windows machine and tried running it with:
.\core-keeper.exe --cd ".\res"The service starts, but immediately fails when trying to create the Postgres client because it cannot find the SQL migration files (sql\idempotent\00-utils.sql).
It looks like the binary is expecting the sql folder alongside, but it is not present after building.
Questions:
- Is the Windows build of core-keeper officially supported and tested?
- Should the SQL migration scripts be bundled automatically, or do they need to be copied manually?(i tried and put along side with res , but it failed)
🔥 Exception or Error
PS C:\Users\avesta-test\Desktop> .\core-keeper.exe --cd ".\res"
level=INFO ts=2025-09-24T09:49:55.8848763+01:00 app=core-keeper source=config.go:752 msg="Loading configuration file from res\\configuration.yaml"
level=INFO ts=2025-09-24T09:49:55.8859461+01:00 app=core-keeper source=config.go:361 msg="Private configuration loaded from file with 0 overrides applied"
level=INFO ts=2025-09-24T09:49:55.8864717+01:00 app=core-keeper source=clients.go:87 msg="Using REST for 'security-proxy-auth' clients @ http://localhost:59842"
level=WARN ts=2025-09-24T09:49:55.9410064+01:00 app=core-keeper source=database.go:159 msg="couldn't create database client: postgres client creation failed -> TableManager failed to run SQL scripts -> core-keeper failed to execute idempotent sql scripts: failed to read sql file sql\\idempotent\\00-utils.sql: open sql\\idempotent\\00-utils.sql: file does not exist"
🌍 Your Environment
Deployment Environment: Windows 10
EdgeX Version [REQUIRED]: v4.0.0 (built from main branch)