This page explains the case when a user already present gets deleted automatically after adding a new user.
Release | Yes/No |
---|---|
8.3.x |
RDBMS | Yes/No |
---|---|
CSS |
Below is the step-by-step scenario leading to the problem:
- Insert manually a user in VIEWER_USERS table
The impact of the problem on the analysis or the dashboard is:
Missing user from CED
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'
select max(id) from VIEWER_USERS
--1143
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'
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
Impact of the solution on the analysis or the dashboard is:
The user will not be missing from the Dashboard
Ticket # 7641