Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > Change Web Help Desk Schema on MSSQL

Change Web Help Desk Schema on MSSQL

Updated July 25, 2017

Overview

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

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.x

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