Invalid Column Name in Select Query [CMM000191] When Opening the DSM Explorer after Upgrading from 12.5 SP1 to 12.8.

Document ID : KB000029112
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

Invalid Column Name in Select Query [CMM000191] When Opening the DSM Explorer after Upgrading from 12.5 SP1 to 12.8.

DB error: invalid column name in select query [CMM000191]

the detail tab shows these messages: 

ADO Version 6.1 - ExecuteCommandPointer [] -COM Error:  ErrorCode:-2147217865,WordErrorCode:3127,

IDispatch error #3127,    Invalid object name 'dsm_hm_alerts'., Microsoft SQL Server Native Client 10.0, (null)

 

Verification:

dsm_hm_alerts is one of the new Health Monitoring tables.

This error occurs if the dsm_hm_alerts table was not created when you upgraded and is missing from the MDB database. 

In most cases if this table did not get created, you might be missing all the HM alert tables.

  • dsm_hm_alertprops_loc_de
  • dsm_hm_alertprops_loc_en
  • dsm_hm_alertprops_loc_fr
  • dsm_hm_alertprops_loc_jp
  • dsm_hm_alerts

 

To verify we can run a SQL query

use mdb

select * from dsm_hm_alerts 

 

Or look in SQL under <Server name>Databases>mdb>Tables>

tables.jpg

 

Cause:

This problem can occur if there is a problem during the MDB upgrade and the schema is not upgraded, resulting in the new tables not getting created. This is also commonly seen when the MDB is on a remote SQL Server and the MDB schema is not upgraded prior to upgrading the Application server.

 

Solution:

To resolve this error, stop CAF on the Domain Manager, run setup from the 12.8 Client Automation DVD directly on the SQL server and select to install MDB only.  This will initiate the upgrade and create the missing tables. Once complete, start CAF on the Domain Manager and verify that the problem is resolved.