Error when opening plugin and/or WUA Versions tab

[Cubert]

We changed several things in how we build the queries. We also added in a new debugger that you can turn on and off via the plugin.


#1 run this query in SQLYog? how long does it take to return data? Does it fail to return data?

Code: Select all

SELECT c.ComputerID as ID, IF(c.LastContact > date_add(now(),interval -5 minute),'Yes','No') As `Online`,(c.flags & 1024) as reboot, c.`Name` as Name, m.`Name` as Client, a.WUAVersion, a.OS as OS FROM plugin_sw_patch_remedy_wua a LEFT JOIN computers c on c.ComputerID = a.ComputerID LEFT JOIN clients m on c.ClientID = m.ClientID  Where a.WUAVersion Not IN (Select Distinct max(WUAVersion) FROM plugin_sw_patch_remedy_wua GROUP BY OS) and a.ClientID IN (Select ClientID FROM `plugin_sw_patch_remedy_config` Where MasterSwitch = 1)

Next
Find the small grey "?" and whild holding down the CTRL key click this. It should pop up a box that says debug is ON. Doing the same thing but holding the Shift key should turn it off.

Capture.PNG (57.39 KiB) Viewed 18791 times

Close and reopen Patch Remedy, do you get any popup boxes with errors?

If so post them here

[tsuky1]

Running the query on the server takes about 35 seconds. No errors are returned. here is the screen shot.

4-20-2016 8-28-41 AM.gif (55.26 KiB) Viewed 18791 times

I only have 64% of my clients selected based on the last tab. I have been adding them slowly in small batches.

Turned the debug mode on. It took a while for the plugin to come up (over 1 minute) but no pop up error.

[Cubert]

I think that is the problem, MySql is timing out after 30 seconds inside of LabTech. Lets try this. Unselect (50%) of your clients from PM and then rerun the query above. What will happen is that query will see less clients to muddle through and should complete quicker. When we get query down to an average of 15 to 20 seconds reopen PM and see if it now loads. This will tell us if it is LT dropping the query after 30 sec.

[tsuky1]

So i dropped the agents down to 21% re ran the query and it still takes a while to complete. It does not feel like it made any difference.
Its down to 224 rows now from original 499
Console still takes a while to open up. but no error

[Cubert]

How long did query take to run in SQLYog? I am trying to disprove my theory, Is it still over 30 sec?

[tsuky1]

it looks like around 37 seconds. just like it did the first time i ran it earlier. definitely over 30.

[Cubert]

And this is in SQLYog, not just opening the plugin right... just making sure I am clear.

[tsuky1]

Yes running your query. Here is a print screen.

4-20-2016 2-30-44 PM.gif (57.17 KiB) Viewed 18789 times

[Cubert]

Wow , it actually went up with less clients? was at like 37 now at 44 seconds?

OK lets dump the tables and rerun a scan on only 25% of your clients. Once scan has run once let's rerun the query and see what time we get. If SQL is running normally we should see about 6 to 10 seconds per 1000 agents.

With a clean set of tables and only 25% of clients scanned should put us well below that number. If we are still high then we need to look at why the DB is so slow to return data. This would have to be affecting everything you do in LabTech.

I am hoping it's just a bad piece of data in the tables causing it to chug for some reason.

to dump tables run queries

Code: Select all

DELETE FROM plugin_sw_patch_remedy_wua

this will clear all WUA data from table. allow scan to repopulate based on the new 25% you set and the table should have aprox 400 records in it. 400 records is one per agent if 25% of your agents = 400


Rerun previous SQL query and post the return here so I can see the time query took to run

[tsuky1]

OK, just purged the table. It said 2055 rows affected. checked the table and its empty now. The scans are set to run every 12 hours. Will check tomorrow morning and see what it looks like. I have 3125 Labtech agents with about another 100-150 to be installed within next month.
Ideally i would love to use patch remedy for the entire environment making sure windows are patched properly.