AHD03075:Required attribute manager_flag is missing from group member object

Products

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

Issue/Introduction

When customer will perform some edition in group member, he receives the error:

AHD03075:Required attribute manager_flag is missing from group member 

Environment

Service Desk Manager all releases

Cause

This problem occurs when the manager_flag is value NULL in the table instead of '0' or '1'. This may occurs when you load data via pdm_load. 

Resolution

To fix this behavior, you can change the value NULL to '0' in manager_flag column, using pdm_load. 

To do it, you can do the following procedure: 

IMPORTANT: before continue, please perform a BACKUP of MDB database!

1. Run a pdm_extract on the table: 

>pdm_extract -f "select * from Group_Member where manager_flag is NULL" > grpmem.txt 

This way, you will extract only the rows where the manager_flag is NULL 

2. Notepad the grpmem.txt and replace all the manager_flag value from NULL to 0. 

3. Run pdm_load to change the values: 

>pdm_load -f grpmem.txt -u 

-u is for update only