How can I confirm that the expected updates to the MDB were made after having run setupmdb for a cumulative patch?

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

Question:

After I applied a cumulative patch to my CA Service Desk Manager environment, I ran the corresponding setupmdb command, as per the patch's post-installation instructions, in order to apply the required schema changes to the MDB database.

How can I confirm that the expected updates to the MDB were made?

 

Answer: 

To verify that the changes that should have been made to the MDB were successful, you could follow these steps:

  1. Review the detailed output file that is generated when the setupmdb command is run. 

    The name of the file is "install_MDB.log". That file may be found in the same directory that contains the setupmdb.exe command that is packaged in the patch.  For example, you may find it in "C:\Program Files (x86)\CA\Service Desk Manager\Patches\cum1".

    Specifically, check the log for any message that indicates that there has been an possible error.   There are 3 types of messages: INFO, WARN,  and ERROR.  You may want to check both WARN and ERROR messages.

    If there are errors, then this indicates that the MDB may not be at a level that meets the requirements of the cumulative patch.  The requirements must be met in order for CA Service Desk Manager to operate correctly.
     
     
  2. Because the successful changes that were attempted by setupmdb are logged in the mdb_schema_information table, you could run the following SQL query and compare the results to the table that follows:  

    SELECT FileName, FileStatus, FileType, FileLocation, FileVersion, FileTimestamp, InstalledTimestamp, SchemaName FROM mdb_schema_information ORDER BY InstalledTimestamp DESC

    The results from the SQL command should return a block of rows at the top that are similar to the rows shown in one of the tables below.  Note that each table is particular to a specific version of CA Service Desk Manager and a particular cumulative patch.

CA Service Desk Manager 12.9 Cumulative patch #1:

FileName                                                                            

 FileStatus  

FileType   

 FileLocation   

FileVersion  

FileTimestamp                       

InstalledTimestamp         

SchemaName 

Service_Desk

Installed

driver

Local

 5.0

2015-02-25T10:20:00+0000

2015-06-08 17:49:55.730

Service Desk

usp_lrel_attachments_nr[service_desk_ro_group].xml

Installed

permission

Local

 5.0

2015-02-25T09:56:08+0000

2015-06-08 17:48:01.570

Service Desk

usp_lrel_attachments_nr[service_desk_admin_group].xml

Installed

permission

Local

 5.0

2015-02-25T09:55:49+0000

2015-06-08 17:48:01.550

Service Desk

crwf[service_desk_ro_group].xml

Installed

permission

Local

 5.0

2015-02-25T09:49:43+0000

2015-06-08 17:48:01.527

Service Desk

crwf[service_desk_admin_group].xml

Installed

permission

Local

 5.0

2015-02-25T09:48:56+0000

2015-06-08 17:48:01.503

Service Desk

usp_lrel_attachments_nr.xml

Installed

table

Local

 5.0

2015-02-25T09:55:30+0000

2015-06-08 17:48:01.477

Service Desk

crwf.xml

Installed

table

Local

 5.0

2015-02-25T09:46:53+0000

2015-06-08 17:48:01.400

Service Desk

wftpl.xml

Upgradedtable

Local

 5.0

2015-03-16T12:41:32+0000

2015-06-08 17:47:52.740

Service Desk

usp_caextwf_start_forms.xml

Upgradedtable

Local

 5.0

2015-03-04T16:50:41+0000

2015-06-08 17:47:51.763

Service Desk

prob_ctg.xml

Upgradedtable

Local

 5.0

2015-03-04T16:46:40+0000

2015-06-08 17:47:50.550

Service Desk

attached_sla.xml

Upgradedtable

Local

 5.0

2015-02-25T08:55:15+0000

2015-06-08 17:47:48.700

Service Desk

 

CA Service Desk Manager 14.1 Cumulative patch #1 (14.0.1):

 

 FileName                             

 FileStatus  

FileType   

 FileLocation   

FileVersion  

FileTimestamp                       

InstalledTimestamp         

SchemaName 

 Service_Desk

Installed

driver

Local

 5.0

2013-10-14T09:27:24+0000

2015-06-16 16:13:47.143

Service Desk

 usp_servers.xml             

Patched

table

Local

 5.0

2014-02-06T11:14:52+0000

2015-06-16 16:13:12.213

Service Desk

 usp_resolution_method.xml

Upgraded

table

Local

 5.0

2014-04-18T09:10:29+0000

2015-06-16 16:13:11.267

Service Desk

 usp_resolution_code.xml

Upgraded

table

Local

 5.0

2014-04-18T09:06:58+0000

2015-06-16 16:13:11.163

Service Desk

 evt.xml

Upgraded

table

Local

 5.0

2014-04-14T10:51:58+0000

2015-06-16 16:12:56.547

Service Desk

 

Additional Information:

If you applied additional CA Service Desk Manager test patches for which you ran the setupmdb command as part of the post installation steps of the test patch, then the results of the query may be slightly different than that shown in the tables.  The tables above only include the additions to the mdb_scheme_information table that have been made after you have run the setupmdb with the mdb package that is included in the cumulative patch.

For more information on how to run the setupMDB update, please see TEC617177:  How to use SetupMDB to upgrade the backend MDB database for SQL Server