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

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

Article Id: 33537

Status: Published

Updated On: 14-02-2018 08:19

Legacy Id: TEC1653544

Products:

SUPPORT AUTOMATION- SERVER , CA Service Desk Manager - Unified Self Service , KNOWLEDGE TOOLS , 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: