CAST Engineering Dashboard - Users and Roles - Existing user get deleted after adding a new user

Description

This page explains the case when a user already present gets deleted automatically after adding a new user.

Observed in CAST AIP

Observed on RDBMS

Step by Step Scenario

Below is the step-by-step scenario leading to the problem:

1. Insert manually a user in VIEWER_USERS table

Impact of the Problem

The impact of the problem on the analysis or the dashboard is:
Missing user from CED

Action Plan

The issue is due to the fact that the table for storing the next available user_id was not synchronized with the max (id) in the table VIEWER_USERS, in fact the id from SERVER_IDS should be equal to the max(id)+1 of VIEWER_USERS, here is an example of unexpected results:

select *
from SERVER_IDS
where id_category = 'Users'

Query result example

–1076;“Users”

select max(id) from VIEWER_USERS

Query result example

--1143

1. In order to fix this please perform the following query :

update SERVER_IDS set next_id = (select max(id)+1 from VIEWER_USERS) where id_category = ‘Users’

   <div class="alert alert-warning" role="alert"><div class="h4 alert-heading" role="heading">Note</div>


Note that you should not insert user with SQL queries, the correct way to add a new user is described in the following page: [CAST Engineering Dashboard - Information - Create new user on dashboard](/export-v2/tg/information-guides/information-guides-by-cast-aip-component/cast-engineering-dashboard-ced/cast-engineering-dashboard-information-create-new-user-on-dashboard/)
</div>


**Impact of the Solution**

Impact of the solution on the analysis or the dashboard is:

The user will not be missing from the Dashboard

**Notes/comments**

**Related Pages**

Ticket # 7641