ADS_ADSGroup_Update Frozen

I have a Problem,

this was already reported to support and we traced around.

We are building a complete new IAM plattform. We allready have our DEV and Stage envoirment. We have 28K AD groups and around 12K users. Now, sometimes a mass updates starts the job ADS_ADSGroup_Update. The problem, inside this job there is a where statement and that ends in Freezing because of intrusion detection.

How can I deactivate that?

Parents Reply Children
  • Sorry, It is 8.2 and the where clause, which is causing the issue:

    2022-02-03 07:11:09.4607 ERROR (ObjectLog a6a0e585-bced-4caa-83dd-74596175c5d7) :         SQL injection by brute force attack detected in WHERE clause: 

    (UID_DPRNamespace in (select UID_DPRNamespace from DPRNamespace where (Ident_DPRNamespace = N'ADS') or (AdditionalSystemTypes like N'%ADS%'))) and (ObjectKeyBase = '<Key><T>ADSGroup</T><P>ce061c1b-586f-4cc4-9949-d5df4374658c</P></Key>')

    This is generated by the Identity Manager, nothing we build or I´m not aware of.

  • You can contact support to either help you with the tuning of the SQL injection detection or ask for a hotfix for VPR#35356 (which is not ready currently but should be available soon).