Unable to open archive file

Unity version: 2022.3.22f1
Addressables version 1.21.21
Folder Structure:

  • C:\Work\Code\Code Project
  • C:\Work\Art Project
  • C:\Work\Scene Depot

Art project creates an asset bundle containing an entire scene. The load and build paths are set as ../Scene Depot/. Remote catalog option is enabled.
Code project loads the catalog via the same string which works fine. However when attempting to load the scene I get errors saying that the bundle archive cannot be opened. The location in the error is ../Scene Depot/. However in that case this will resolve to C:\Work\Code as opposed to C:\Work\Scene Depot. I tried setting the Internal Asset Naming mode to all of the options and the same error persist.
How can I fix this issue?

This took me way too long to figure such an obvious thing but I’m posting the answer in case anyone runs into a similar issue. With relative paths, make sure that the load path is relative to the project doing the loading.
With the folder structure I posted above the build path should remain as it is: ../Scene Depot/ but the load path should be ../../Scene Depot/ as this will correctly go up twice from the Code Project.

Alternatively you can create your own transform function to convert relative paths to static ones.
More info here: Transforming resource URLs | Addressables | 1.19.19