Symptoms

BLM failed to start and reported the following error in Windows Event Viewer:

Windows Application Event log records the error message:

ERROR: unterminated quoted string at or near EE:\staging\, 858857140224.000000, 0.000000)

LINE 1: ...ations (id, path, max_size, used_size) VALUES (0, EE:\stagi...

(INSERT INTO stage_locations (id, path, max_size, used_size) VALUES (0, EE:\staging\, 858857140224.000000, 0.000000) )

Cause

BLM is using remote PostgreSQL server running in Linux and the backslash for storage path is treated as escape character in Linux

Workaround

Manually update the PostgreSQL database by modifying the referenced table and use quotes around the Windows path.

(INSERT INTO stage_locations (id, path, max_size, used_size) VALUES (0, 'E:\staging\', 858857140224.000000, 0.000000) )