02-17-2014 07:11 AM
We are trying to figure out why the knta_users_int tables are not purging in PPM. We set "DAYS_TO_KEEP_INTERFACE_ROWS" to 3 in the administrator console. We also made sure the "Interface Tables Cleanup Service" is running and enabled. Is there any other steps to take? Also, does anyone know where any documentation is for these services?
02-17-2014 10:36 PM
did you make sure that all of the three following settings are set accordingly:
The following tables SHOULD be purged by these services:
Did you make sure that the services are actually running correctly? Make sure whether the way that you have set the cleanup service is case sensitive - I think it should be all caps, thus the value should be TRUE and not True or true... please check that.
02-21-2014 07:28 AM
We are running version 9.14. We have DAYS_TO_KEEP_INTERFACE_ROWS set to 1. The other two configuration parameters you list do not appear in the Server Configuration Report. The service does clean out the contents of the KNTA_USERS_INT table but it has never cleaned out old entries in the KNTA_USER_SECURITY_INT table since we started running ITG release 6.0. We run a script daily to delete old entries with a database query.
Is this fixed in the latest release?
02-21-2014 09:04 AM
Hey Jim :-)
right, so there are three parameters:
You don't see those parameters in the admin console either?
I just checked in one here, I don't see them in there either per default.
Make sure also to understand that the service will include only those records that have been processed. If there is data in the tables that have not yet been processed, these will NOT be purged. Looking at your specific table, I'd most likely test the table columns 'process_phase' or 'process_status' to determine the state.
Let me know how it goes.
Best of luck...
Please solve the thread if this has helped fix the problem.
-- kudos always welcome --
02-21-2014 10:10 AM
This is the entry for the cleanup service in the Services Audit page:
Interface Tables Cleanup Service Enabled Every 195 minutes apsp0694 Feb 21, 2014 10:28:54 AM CST Feb 21, 2014 1:43:52 PM CST
This is the query we are using to delete entries not deleted by this service from the knta_user_security_int table:
delete from knta_user_security_int
where process_phase = 5
and process_status = 7;
02-28-2014 02:19 AM