Skip to main content
Question

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


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

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!


Forum|alt.badge.img+7
  • Author
  • Sidekick (Employee)
  • 48 replies
  • July 24, 2023

sounds like a good idea...


AmyE
Do Gooder (Employee)
Forum|alt.badge.img+1
  • 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


Forum|alt.badge.img+7
  • 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 .

 

 


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

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings