[RHV] Open VM console fails with "Setting VM ticket failed." error

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content