Requests to the External API that involve metadata (api/event/metadata or api/event?withmetadata=true) return error HTTP 500 with migrated data

Steps to reproduce

Steps to reproduce:
1. You need an 4.0 Opencast system with migrated data from a 3.x version. If you don't have one, you can simulate the situation by emptying the mh_assets_properties table.
2. Make a call to any External API event endpoint that involves getting metadata (api/event/metadata or api/event?withmetadata=true).
3.

Actual Results:
The call returns an error 500

Expected Results:
The call should succeed

Workaround (if any):
Run a workflow on the events which contains at least an "snapshot" operation. From then on, that event will not cause an exception.

Status

Assignee

Unassigned

Reporter

Rubén Pérez

Severity

Incorrectly Functioning With Workaround

Tags (folksonomy)

None

Components

Fix versions

Affects versions

4.0

Priority

Blocker
Configure