Patch Windows Inventory Installed Date is missing or has the date format is incorrect, swapping the day and month

book

Article ID: 159057

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

Software inventory returns an error in log and table Inv_SW_Patch_Windows will not be populated with 'Installed Date'.

Also the date format may be incorrect, swapping the day and the month to make it look like the date is in the future.

Source: DataClassRowCollection.SetColumn
Description: Invalid column [c3] value [date] (fixed [[NULL()]]) for
resource (GUID): 'Patch Windows' (672caca3-d1d8-
493f-a876-17e3cd83b2f6)"
 

Cause

This is a defect.

Resolution

  1. Log on to the SMP Server as the Application Identity.
  2. Retrive files from the archive to the NS hard drive.
  3. Click on PFinstaller.exe
  4. Click install files button
  5. From Windows Task Scheduler run NS.Package Distribution Point Update Schedule and NS.Package Refresh.
  6. Upgrade Inventory Solution plugin via Inventory plugin upgrade policy for non-site servers. New inventory plugin version 7.5.3308

Attachments

3766322_IS_7.5_SP1_HF5.7z get_app