Collect phase failed with SQL Error Exception

[PhilippeC.]

Hello

I upgraded to Otter 2.1.2, and I have now many of the servers in error during the Collect phase.

Unhandled exception: System.Data.SqlClient.SqlException (0x80131904): 
La transaction (ID de processus 77) a été bloquée sur les ressources verrou par un autre processus et a été choisie comme victime. 
Réexécutez la transaction.

If I force the Check Configuration it is working fine.

Regards

Product: Otter
Version: 2.1.2

[Alana]

Can you try to defragment your SQL Indexes to see if that helps?

[PhiippeC.]

It solves partially the problem which occurs now for fewer servers (less than 10).

I have only 40 servers.

I forgot to mention that I upgraded from the previous version using the Hub installer.

[Philippe C.]

The problem appears again on many of my servers :(

Previous Otter version was more stable.

I defragmented again, restart Otter Service.
I have a lot of server in error due to various error (various variable are not resolved).
I start again remediation, and now everything is green.

[atripp]

Did the changes from OT-284 help at all? That should have drastically sped up the servers overview page at least. It was in Otter 2.1.3.

[Philippe C.]

Hello
The pb still occurs from time to time.
It seems to happen because I have a high fragmengation of few table.
Even if I defragment regulrly the fragmentation occcurs very fqst.
I will update the post withxthe concern table.
Regards

[atripp]

Good news, thanks to some data from customers enabling our CEIP, we've identified some problems and will fix them ASAP. Please wait for a new version on Friday of this week :)

[Philippe C.]

I will wait :)
Thank you for your fast reaction
Cdt
Philippe