"JRE defective" - it wan't yesterday?

[UncleRobin]

I just tried to run a query in an odb that I last used barely 12 hours ago. Then, it worked fine, no issues or errors. Now, I got this

LibreOffice requires a Java runtime environment (JRE) to perform this task. The selected JRE is defective. Please select another version or install a new JRE and select it under Tools - Options - LibreOffice - Advanced.

I have the latest Java installed, as shown in Tools - Options - LibreOffice - Advanced

What would cause it to suddenly be defective, and what is the optimal fix?

[Wanderer]

@UncleRobin

barely 12 hours ago. Then, it worked fine

Doesn’t matter, like “my car was fine yesterday, Why is it not starting today?”.

@UncleRobin

have the latest Java installed

Whatever that may be, as you didn’t tell anything on your OS. I have worked with Java from Oracle, Amazons Coretto and now a version from Adoptium.net

@UncleRobin

What would cause it to suddenly be defective, and what is the optimal fix?

Some time ago I had problems on Windows, where LibreOffice told me “no Java available” sometimes. It turned out, I had to wait at startup for the spinning wheel (work in progress) to stop, before I should start working. I could do anything not related to Java, but the program would fail later, when I used the reporting engine.
.
The permanet(?) fix was then to switch from Coretto to Adoptium and a re-install of Windows wich seemed to cleanup accumulated stuff.
.
Error messages are often not very precise, but in your case I would start removing and re-installing your Java or providing a second Java-install and try this.
.
Optimal fix? I have no clue. I would be satisfied to have one fix…

[UncleRobin]

Thanks, and apologies for forgetting to provide the OS (Win 10 Pro) and Java (8.461) details. After posting here, I decided to try the latest OpenJDK, and it’s working, for now