Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Database migration

I am trying to move my Web Help Desk DB from my old DB server SQL 2012 to my new SQL 2019. I pull a backup from old server to new but when I try to connect the helpdesk server to it tries to build a new instance on the DB then errors out with "EvaluateExpression failed: <com.webobjects.jdbcadaptor.microsoftplugin$microsoftexpression: "alter="" table="" action_rule="" alter="" column="" description="" nvarchar(max)"="" withbindings:="">: Next exception:SQL State:S0001 -- error code: 4902 -- msg: Cannot find the object "ACTION_RULE" because it does not exist or you do not have permissions."

I tried to reach out to solar winds help but I was told they cant help me. I tried to delete the database from new server again let help desk build a fresh copy and it ran fine until I tried to bring in old data.

Find more posts tagged with

Accepted answers

dustin.jeffers

I reached out to support again but this time with the database down. It ended up being a schema issue. My original DB had solarwinds. for the schema. Support gave me script to update and it corrected the issues.

All comments

percyplant

can you setup a new blank WHD DB on your SQL 2019 server to see if that's working okay?

dustin.jeffers

Yes that's in my original post a new db works fine

percyplant

Is the server collation set to case insensitive ?
Have you modify the default schemas?

Prepare the Web Help Desk database (solarwinds.com)

Are you using the same WHD application version on both?

dustin.jeffers

I'm restoring a backup form old server I dont have much I could have changed. I found that Collation was set to insensitive so I changed that but same results. Still using the same helpdesk install to access the DB.