Error:"-SQL Execute failed: [Microsoft OLE DB Provider for SQL Server] [ SQL Code=207 SQL State=42S22] Invalid column name 'server_type'" When Running pdm_configure to 12.9 or later

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Problem: 

 

After upgrading Service Desk Manager (SDM) to 14.1 and running pmd_configure, we get the following error message in the logs:

SQL Execute failed: [Microsoft OLE DB Provider for SQL Server] [ SQL Code=207 SQL State=42S22] Invalid column name 'server_type'

-select local_host from usp_servers where server_type = 0

 

Environment: 

Microsoft SQL Server all versions

 

Cause:

The server_type column in table usp_servers does not exists in SDM 12.7. However, it does exists in 12.9 and 14.1 so that means the database upgrade process was not completed successfully and for some reason the server_type column was not added to the usp_servers table.

 

Resolution:

Perform an upgrade of the database from 12.7 to a later release. Ex: 14.1

1) Run setup.exe from <disc drive of 14.1>\products\SDM\setup.exe
2) Product Installs
3) CA MDB
4) Follow the Wizard to upgrade the database to 14.1.

This should add the "server_type" in the usp_servers column among other updates in the database.

Environment

Release: SDMU0M99000-14.1-Service Desk Manager-Full License
Component: