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.