[RHV] Open VM console fails with "Setting VM ticket failed." error
Issue
Open VM console fails with Setting VM ticket failed.
In the engine.log
is possible to see following error
2022-09-28 07:30:25,366+01 ERROR [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector] (default task-25) [5138be99] EVENT_ID: VM_SET_TICKET_FAILED(165), User admin@internal-authz failed to initiate a console session for VM test
and in server.log
2022-09-28 07:30:25,366+01 INFO [org.springframework.jdbc.core.metadata.CallMetaDataContext] (default task-25) Unable to locate the corresponding parameter value for 'v_updated' within the parameter values provided: [v_console_cur_user_name, v_console_user_id, v_vm_guid, v_guest_cur_user_name]
The following error is in the postgresql log
2022-09-28 07:30:25,366 UTC ERROR: column "v_updated" does not exist at character 74
2022-09-28 07:30:25,366 UTC STATEMENT: select vm_guid,console_user_id,guest_cur_user_name,console_cur_user_name,v_updated from vm_dynamic
Environment
- Red Hat Virtualization 4.5.0.7
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.