Skip to main content
Question

The table IAM_LOGIN_EVENT_DETAIL_TAB - is there a cleanup routine? This is growing alarmingly

  • July 20, 2023
  • 5 replies
  • 351 views
R
Sidekick (Employee)
Forum|alt.badge.img+7

 

The table IAM_LOGIN_EVENT_DETAIL_TAB which is probably new to IFSCloud has about 4372232 (4.3 million rows and growing) and customer has been live for less than a month.

I don’t know if there is a cleanup routine for this table in the Application - if so, can you tell us what needs to be run if the above table needs a cleanup or is supposed to be cleaned up?

 

If you do a count in the 22R1 TECH LKP db, the total count of rows is 1143511. 

So if there is no cleanup in the Application yet, is there one in the works?

5 replies

Charith Epitawatta
Ultimate Hero (Employee)
Forum|alt.badge.img+31
  • Charith Epitawatta
  • Ultimate Hero (Employee)
  • 1094 replies
  • July 21, 2023

Hi @Roy Almeida,

I checked the system parameters and scheduled database tasks, but there appears to be none that will cleanup this table. There are no appropriate methods in the Iam_Login_Event_Detail_API either. I think it is best to report this through a case so that it can be directed to R&D.

Hope this helps!

Charith - https://charith.pro
R
Sidekick (Employee)
Forum|alt.badge.img+7
  • Roy Almeida
  • Author
  • Sidekick (Employee)
  • 48 replies
  • July 24, 2023

sounds like a good idea...

AmyE
Do Gooder (Employee)
Forum|alt.badge.img+1
  • AmyE
  • Do Gooder (Employee)
  • 6 replies
  • August 14, 2023

Hi Roy,

In 23R1 there is an API in the Default Batch Queue for IAM_EVENT_UTIL_API.CLEAR_IAM_EVENTS:

 

 

There is also a System Parameter in the Security category for - Cleanup age limit in Days for IAM Events Log.  In our environment that is set for 3 days.

 

Hope that helps!!

Amy

R
Sidekick (Employee)
Forum|alt.badge.img+7
  • Roy Almeida
  • Author
  • Sidekick (Employee)
  • 48 replies
  • September 19, 2023

IAM_EVENT_UTIL_API.CLEAR_IAM_EVENTS did not have a provision to remove rows from IAM_LOGIN_EVENT_DETAIL_TAB.

 

It only removes/cleans up rows from

iam_login_event_tab

iam_admin_event_tab

 

 

Per the latest from R&D:

i.e. the fix is in 22R1 SU20 .

 

 

R
Sidekick (Employee)
Forum|alt.badge.img+7
  • Roy Almeida
  • Author
  • Sidekick (Employee)
  • 48 replies
  • September 19, 2023

The JIRA link is

 

https://ifsdev.atlassian.net/browse/PACZSECA-5619


Terms & ConditionsCookie settingsAccessibility statement