Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Web Help Desk (WHD) > Java.lang.NullPointerException error when upgrading to 12.5.1

Java.lang.NullPointerException error when upgrading to 12.5.1

Updated July 25, 2017

Overview

The following error is displayed when upgrading to WHD v12.5.1:

java.lang.NullPointerException 
The following error is also found in the whd-spring.log file: 

[ApplicationManager-8] ERROR c.s.w.s.a.i.WhdApplicationManagerImpl - Failed to start WHD application. Reason: DB_INIT_FAILED
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "dbo.JOB_TICKET" because it does not exist or you do not have permissions.

Environment

WHD 12.5.1

Cause 

The WHD database from the MS SQL Server is not using the default schema [dbo], causing the database upgrade to fail. 

Resolution

Run the following query to change the WHD database schema from the MS SQL Server to default [dbo]:

ALTER Schema dbo Transfer whd. <table name>

Examples:

ALTER Schema dbo Transfer whd. PLUGIN_PREFERENCE
ALTER Schema dbo Transfer whd. PREFERENCE
ALTER Schema dbo Transfer whd. PRIORITY_TYPE
 

 

Last modified

Tags

Classifications

Public