'Packageid WSE3_0' in pending status in al_cdb_componentinstallstate after upgrade from ITAM 17.2 to ITAM 17.2.0.2

Products

• CA IT Asset Manager
• CA IT Asset Manager Asset Portfolio Management
• ASSET PORTFOLIO MGMT- SERVER

Issue/Introduction

After upgrading from ITAM 17.2 to 17.2.02, the 'Packageid WSE3_0' component is in pending status in the al_cdb_componentinstallstate MDB table

Run query:

select * from mdb.dbo.al_cdb_componentinstallstate where machinename like '%<ITAM_SERVER>%' and installationstate not in ('complete','Applied')

Output shows packageid='WSE3_0' in pending status

Environment

ITAM 17.2

All Supported Operating Systems

Resolution

1.  Verify if the task ‘WSE3_0' is installed successfully or is really in a pending state.

1. Via ADD/REMOVE PROGRAMS on the ITAM server, verify that ‘WSE 3.0 Runtime´ is installed with the correct installation date
2. Via the ITAM install log ' CA_Asset_Portfolio_Management_DATE_0_WSE3_0', locate the following message which indicates that WSE3_0 is installed successfully

Product: Microsoft WSE 3.0 Runtime -- Installation operation completed successfully.

2.  After verifying that WSE3_0 is indeed installed successfully, run the following query to update the status correctly in the MDB

update al_cdb_componentinstallstate set  installationstate='complete'  where packageid='WSE3_0' and  installationstate= ‘pending’.

3.  Run IISRESET to restart IIS

4.  Verify that the ITAM application is running correctly.

Moving forward, this behavior will not occur when installing any newer ITAM release on top of the current release after updating the MDB via the query in step #2 above.