Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Web Help Desk (WHD) > java.lang.NullPointerException when clicking on Techs in Setup menu

java.lang.NullPointerException when clicking on Techs in Setup menu

Created by Brendan.McHugh, last modified by MindTouch on Jun 23, 2016

Views: 529 Votes: 0 Revisions: 4

Overview

The following error occurs when clicking Setup > Techs:

We're sorry, an unexpected error occurred:
java.lang.NullPointerException
A bug report has been e-mailed to SolarWinds.


Java.lang.NullPointerException
at com.macsdesign.whd.Tech.icon_tooltip(Tech.java:573)
at sun.reflect.GeneratedMethodAccessor477.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)...

Environment

WHD 12.3.0

Cause 

This occurs when one or more client_ids have the client_type set to NULL rather than 1 or 2 (Admin or Tech).

Resolution

  1. Open pgAdmin3.exe in Program Files\WebHelpDesk\pgsql9\bin\ on the server. 
  2. Go to the Object browser on your WHD database.
  3. Click SQL.
  4. Run the following query to verify if any client_type is NULL by pressing F5 to execute.
    select client_id, first_name, last_name, user_name, inactive, deleted, seat_type, client_type from tech
    where client_type is NULL
    order by client_id
  5. Check if any client_type is NULL.
  6. Update any that are NULL to the correct type.

 

Last modified
04:41, 23 Jun 2016

Tags

Classifications

Public