Description

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

Observed in CAST AIP
Release
Yes/No
8.3.x(tick)
Observed on RDBMS
RDBMS
Yes/No
CSS(tick)
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'

    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

 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