
SamuelBaughan asked a question.
Update pushes through SMACC working intermittently
Dear specialists,
I am having trouble regularly when pushing updates (agent or files) through the Inventory SMACC.
Often, the push never starts and I have to recreate it, several times in a row in some cases, before it eventually starts.
Has anyone faced this issue before?
This is annoying considering that I have to re-create those pushes every few weeks because the target collections do not update dynamically according to Gert/Martin
P.S.: I have asked Snow Support over a week ago but got no answer yet (CS0037401)
We found a solution to this long running problem! At first our update pushes were intermittent, eventually they stopped working completely. We were unable to push any updates from our inventory console, which became a big problem and was seriously holding us back.
But we have identified the problem. The stored procedure stored [inv].[AttachTargets] in the Snow Inventory database performs very badly. In our environment it takes several minutes to work and therefore times out. That prevents the push from targeting the computers.
Snow have created a problem record for this, but there's no release date for a fix yet. But we have pointed out the exact bit of SQL code that needs optimization, and it is not very difficult to change.
I thought I'd post an update in case anybody else has a similar problem. Larger organisations may well have this same issue. Hope that helps!