Hello,

I dig a bit more and did some debugging and that procedure is failing on query that is building subquery based on DeviceGroup table, so now I have question:

table  [OMEssentials].[dbo].[DeviceGroup] - 1972 rows

lot of groups :

DeviceGroupName InternalName
Remote System Update Remote system update task device group query.
Server System Update Server system update task device group query.

table DeviceGroupArchive - 0 rows

how I could Archive some group created automatically for updates ?

or how I could cleanup this table DeviceGroup ?

Thanks,
Kamil

Hi Kamil,

Thanks for the details in the post. This is a known issue in OME 2.2 when tasks/device groups reaches a thresh-hold limit.

Please get in touch with support 800-945-3355 to get the one-off fix for this issue. 

Deleting the executed tasks should also get this behavior corrected.

Thanks,
Vijay

Hi Kamil,

This should be PSE033608

Thanks,
Vijay

Hello,

thank you for hint, do you know maybe how this issue is recorded / named in Dell ? I am in call with support and it's not easy to find resolution

Thanks,
Kamil

ok, thank you, do you know what includes :

attached query (dbo.DeviceGroupToDevice_Update.proc.sql)  ?

it's some better version of this proc ? I not received yet that attachement, only solution description

Thanks,
Kamil

Yes. The solution should be the corrected version of the proc. which you can get from Dell support.

Thanks,
Vijay

Ok, I'll ask probably our email firewall removed attachement .sql from email so I'll try to receive that in other way

Thanks,
Kamil

Thanks. Let us know if this fix from Dell Support resolved the problem.

Regards
Vijay

Thanks for taking time and updating this thread.

Regards
Vijay

Hello,

Finally I received zip archive with file : dbo.DeviceGroupToDevice_Update.proc

I've tested that fix on copy and it was working also applied to production and issues gone

Thanks,
Kamil