ColinHardie asked a question.
Hi, I was wondering if anyone has used the v9.14 SLM installer currently available for FTP download?
I have just attempted to build 2 separate environments with it. All appears to go well until I tried the DUJ, whereupon nothing appear to be processed. When checking the logs (tblJobLogMetrics, tblJobLog, tblErrorLog), the job appears to have run fine but there are hardly any steps....When looking at the SQL Agent Jobs, also appear to be missing all the jobs that are usually there (the ones prefixed with inv. and slm.)...
vs
I thought these are were generated on first DUJ run following an upgrade/install of SLM 9?
I also noted an error in the tblErrorLog showing the following...
Error #1088 line 1. [Cannot find the object "o365.ReadModelUsersPerSubscriptionPlan" because it does not exist or you do not have permissions.]
The timing of this is at installation time though, not when the DUJ run. The object in question does actually exist.
This is the first time I have used the full installer, in the past it is usually taking an older available installer and SUS-ing up to the latest version.
I have seen the DUJ steps not being created before and normally comes down to permissions on new SQL installs.
Check this article as it may assist:
Data Update Job (DUJ) 2.0 stuck on step JobInventoryGetInventoryData and never completes. (snowsoftware.com)
If it's not that you can run the Stored Procedure manually that add's the job steps in and it should work fine from there.
Thanks Joe, really useful article, I'll give it a go and post my results. 👍
Hmmm, so followed the article but already had relevant select/roles applied to LicenseManagerUser for msdb.
Attempting to run the DUJ SP step manually returns a result straight away....
...but nothing more processed, nor any job steps created.
Hi Colin - Wrong SP :-)
This is from an article here: https://community.flexera.com/s/feed/0D51r00008OrDZECA3
Use SnowLicenseManager exec JobRemove
use SnowLicenseManager exec JobAdd 'LicenseManagerUser'
Use SnowLicenseManager UPDATE dbo.tblInventoryDatabase SET NewRowVersion = 0x0 , NewSequenceNumber = 0
Its how to remove the DUJ master job and get it recreated. Then force a full run of all data tasks.
Ran the JobRemove and JobAdd and as far as I can tell it successfully re-creates the 'License Manager Data Update' job. However running this job still does not create all the additional jobs.
Interestingly I have no record in the tblInventoryDatabase table....
Quick update, found the cause....hadn't enabled the Inventory Source....
This Active column defaults to False, had to go into SMACC and set it to true. Once I done that and ran the DUJ, everything got generated and started processing.