Tools

"Cannot find the object "CHECKLIST_ITEM" because it does not exist or you do not have permissions." error during a Web Help Desk upgrade

During the database upgrade phase of the Web Help Desk upgrade, the upgrade does not complete, and the logs show the following error: "Cannot find the object 'CHECKLIST_ITEM' because it does not exist or you do not have permissions."

First published date

5/21/2026 3:48 PM

Last published date

5/21/2026 3:48 PM

Overview

The database upgrade phase of the Web Help Desk is failing. Checking the logs, and it shows the following error:

2026-05-05 12:10:32.232 [ApplicationManager-2]  INFO c.s.c.WhdPersistenceComponentConfig - Initializing DB: MICROSOFT on jdbc:sqlserver://whddbsample.local:1433;Databasename=chd;SelectMethod=direct;logging=true
2026-05-05 12:10:32.232 [ApplicationManager-2]  INFO c.s.c.WhdPersistenceComponentConfig - Max number of active DB connections is set to 25
2026-05-05 12:10:32.392 [ApplicationManager-2]  INFO c.s.c.WhdPersistenceComponentConfig - Database is not up to date, current database version: 12.7.9, expected version: 12.8.0
2026-05-05 12:10:32.392 [ApplicationManager-2]  INFO c.s.c.WhdPersistenceComponentConfig - Database needs to be updated to version 12.8.0
2026-05-05 12:10:32.394 [ApplicationManager-2]  INFO c.solarwinds.config.DatabaseUpgrader - Upgrading to database version: 12.7.10
2026-05-05 12:10:32.397 [ApplicationManager-2] ERROR c.solarwinds.config.DatabaseUpgrader - Error occured when executing statement: ALTER TABLE CHECKLIST_ITEM ALTER COLUMN NAME VARCHAR(250)
2026-05-05 12:10:32.397 [ApplicationManager-2] ERROR c.solarwinds.config.DatabaseUpgrader - SQL State code:S0001
2026-05-05 12:10:32.399 [ApplicationManager-2] ERROR c.solarwinds.config.DatabaseUpgrader - SQL Error code:4902
2026-05-05 12:10:32.399 [ApplicationManager-2] ERROR c.solarwinds.config.DatabaseUpgrader - SQL Error message com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "CHECKLIST_ITEM" because it does not exist or you do not have permissions.

Product section

Web Help Desk

Cause

The cause of failure is that the following tables are assigned to db_owner schema instead of dbo:

CHECKLIST
CHECKLIST_ITEM
CHECKLIST_TEMPLATE
CHECKLIST_TEMPLATE_AUDIENCE
CHECKLIST_TEMPLATE_ITEM
CONDITION_ARG_DICTIONARY
CONDITION_ARG_NAME
CONDITION_ARG_TYPE
OBJECT_EDITING
PASSWORD_RESET

Resolution

1) Stop the WHD service.

2) Run the following SQL queries in the database:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

ALTER SCHEMA dbo TRANSFER db_owner.CHECKLIST
ALTER SCHEMA dbo TRANSFER db_owner.CHECKLIST_ITEM
ALTER SCHEMA dbo TRANSFER db_owner.CHECKLIST_TEMPLATE
ALTER SCHEMA dbo TRANSFER db_owner.CHECKLIST_TEMPLATE_AUDIENCE
ALTER SCHEMA dbo TRANSFER db_owner.CHECKLIST_TEMPLATE_ITEM
ALTER SCHEMA dbo TRANSFER db_owner.CONDITION_ARG_DICTIONARY
ALTER SCHEMA dbo TRANSFER db_owner.CONDITION_ARG_NAME
ALTER SCHEMA dbo TRANSFER db_owner.CONDITION_ARG_TYPE
ALTER SCHEMA dbo TRANSFER db_owner.OBJECT_EDITING
ALTER SCHEMA dbo TRANSFER db_owner.PASSWORD_RESET

3) Restart the WHD service and access the UI to proceed with the upgrade.