AHD04022:Login failed for userid error after enabling Multi-Tenancy

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• KNOWLEDGE TOOLS
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

How to address the "AHD04022:Login failed for userid (xxxx); no active tenant found for session type (1)" error?

Why does this error come up on attempt to login after enabling Multi-Tenancy?

 

"AHD04022:Login failed for userid (xxxx); no active tenant found for session type (1)"

Environment

WINDOWSLINUX

Resolution

This error happens as a result of the contact not having the tenant field set on the ca_contact table.  To resolve this, update the tenant\set the tenant field via a SQL script:

 

USE MDB 
UPDATE ca_contact 
SET tenant = '0xAB01E3010A06F143A6668709256E2B8B' 
WHERE UserID = 'xxxxx'

 

Notes:

xxxxx = UserID of the contact getting the error

0xAB01E3010A06F143A6668709256E2B8B = UUID of the tenant

 

Alternatively, you can achieve same result using pdm_extract and pdm_userload commands

Additional Information

https://docops.ca.com/ca-service-management/17-0/en/administering/configure-ca-service-desk-manager/setting-up-multi-tenancy/how-to-implement-multi-tenancy