CAST Engineering Dashboard - Views - Errors - An error occurred during process

This page provides the solution to a known problem of the Engineering Dashboard which causes the dashboard to stop working and prevents the user to work/access it. Following is the screenshot of the error that will explain the problem which is faced while accessing the dashboard:

This error does not come up after logging in, but occurs while working on the dashboard. After 2-5 minutes of working, this above error occurs and then does not allow the user to work on the dashboard.

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

1. Open the dashboard.

2. Login into the dashboard.

3. Start working on it and navigate between the different pages of the dashboard.

4. After 2-5 minutes, the dashboard shows the error "An error occurred during process".

The impact of the problem on the analysis or the dashboard is: This error prevents the user to work on the dashboard for long time and once the error comes up, logging out and logging into the dashboard also does not help the user to access it.

This problem happens with the application because there are 2 sites present in one central base for this application. Following are the queries to check the same and fix the issue.

To fix the problem, proceed as follows :

1. Run the below query on the Central Base to know if there are 2 or more sites present.

   select *
   from viewer_sites

   It will return something similar as shown below :

   Query result example

   408875661;"";"fr_ag2rlm_trea_local";"operator";"GKGMIMMIDOCSFNKL";"fr_ag2rlm_trea_local";"org.postgresql.Driver";"postgresql";"//localhost:2280/postgres";1;"fr_ag2rlm_trea_local";"";""

   0;"";"Empty";"Empty";"AF";"Empty";"DataSource";"";"Empty";1;"Empty";"";""

   The first row is a valid entry because 408875661 is the site ID and for this SITE ID there is a local base configured with the name  "fr_ag2rlm_trea_local". And this local base is present in the "//localhost:2280/postgres".

   Whereas the 2nd row, which has a SITE ID=0 is the invalid entry in the table. It does not have anything configured because everything is written "empty". So we need to remove this invalid entry from the table in order to fix the problem.

   
   

2. Run the following query to remove the invalid entry :

   NOTE: Before running the below mentioned query, please ensure that you take a backup of the Central base.

   delete 
   from viewer_sites
   where id = 0

   
   

3. The ID=0 is to delete only the 2nd Row. Please make sure that you only delete the invalid entry.

Impact of the solution on the analysis or the dashboard is: The dashboard will open and users will be able to work on it without any errors.