Abort session from viewpoint query monitor failing with Portlet error “internal error: contact your administrator. Error ID (long hex number)”

Problem:

Abort session from viewpoint query monitor failing with Portlet error internal error: contact your administrator. Error ID (long hex number)

Reason and Solution:

Reason 1:

The rights on the /etc/hosts file must be world readable as the viewpoint application user must resolve the TDPID of the system

# ls -al /etc/hosts

-rw-r----- 1 root root 1303 Nov 25 23:28 /etc/hosts

The correct permission should be:

# ls -al /etc/hosts

-rw-r--r-- 1 root root 1303 Nov 25 23:28 /etc/hosts

Solution:

If the permission it incorrect, change it to correct permission:

chmod 644 /etc/hosts

Reason 2:

The DNS configuration cannot resolve the TD system TDPID from viewpoint server

Solution:

Make sure TDPID for the TD system can be resolved

nslookup <TDPID>

Reason 3:

The user does not have abort session privilege.

Usually if the user doesn’t have abort session privilege then it gives error “No MONITOR Partition sessions available, or this user does not have MONITOR access” but in our case it shows error “internal error: contact your administrator. Error ID (long hex number)”

Solution:

Grant MONITOR privilege to user

To abort any DBS Session/Query via Query Monitor Portlet, the DBS User should have MONITOR privilege. The MONITOR privilege has the following 05 access rights:

To grant MONITOR privilege, use the following SQL: GRANT MONITOR PRIVILEGES TO <<Username>> [WITH GRANT OPTION];

To identify DBS Users with ABORT Session privilege, use the following SQL: SELECT * FROM DBC.AllRights WHERE AccessRight EQ 'AS';

Note: If you grant MONITOR privileges to any user the user not only abort his/her own session the user can abort any other user session.