Hi All
SCA Import was Failed recently, i found below error on Import log
Can you please check the failed error which is on Redmark and let me know why did the error occurred…
<img src="/uploads/default/original/2X/d/dd792db3b7206a5471f24ca44d3c2d64801d9ffa.jpg" width=“690” height="349
I would suggest open a PMR. This is not a common error, could be something in your environment that is causing that the import fails.
I agree you should open a PMR. But I don’t think it’s certain that the error is on the line you have highlighted.
In this debug output, it looks like it’s just showing what SQL statements will execute. We see it creating a variable @result of type integer, execute a stored procedure to lock the ActionSite (sp_getapplock ‘SiteLock_ActionSite’), and if that fails raise an error message. That does not necessarily mean that the error actually occurred, unless you’re seeing somewhere else the message 'Site lock request failed: ’ (which is the message that this check would have raised).
Check further down that log to see what error is actually occurring.
I’d also note that if you’re importing the SCA content every two hours, that’s probably more frequently than you should. We can see that the duration of each import averages a little over one hour, so you’re basically hammering your BigFix server 50% of the day. Your checklist results shouldn’t need to be updated that frequently.
I wonder if you are running into an issue where the imports are overlapping each other and the previous has a lock on the import. That is just a big guess.
As the others are saying, a PMR is probably in order.