Assistance Required: SQLX_OFFLINE Compilation Error in OpenADR VTN

[ramancero]

Dear sir,

I hope you are doing well.

I am working with the OpenADR VTN open-source project for academic purposes and have been impressed with its code structure and quality. I successfully installed it on an Ubuntu server with the latest Rust version and was able to run all the required commands. However, I encountered an issue during compilation.

Error Message:
error: SQLX_OFFLINE=true but there is no cached data for this query,
run cargo sqlx prepare to update the query cache or unset SQLX_OFFLINE

--> openleadr-vtn/src/data_source/postgres/event.rs:160:32
let MaybePgId { id } = sqlx::query_as!(
r#"
SELECT business_id AS id FROM program WHERE id = $1
"#,
program_id
)
^

Your insights would be greatly appreciated. Looking forward to your response.

[pohlm01]

Hi @ramancero,
I'm happy to help you here. To understand the error a little better, please provide more context on how you got there. For example: Did you start the database and apply the migrations? Which directory do you run which command in? Which component do you try to compile (the whole workspace, the VTN, the VEN)?

Normally, the following commands should bring up a VTN instance:

docker compose up -d db # starting up the database in Docker compose
cargo sqlx migrate run  # creating the DB schema
cargo run --bin openleadr-vtn # starting the VTN

All these commands must be executed in the root directory of the repository.

[pohlm01]

Duplicate of #158