Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

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