When and how do you clean up application server temp files?


Over time, the temp (temporary) directory may fill up with files on the application server or process server. You may want to clean up these files over time, it is generally safe to delete files over 2 days old. We suggest setting up a cronjob (Linux/Unix) or Scheduled Task (Windows) that deletes temp files owned by the user running the TRIRIGA application, over 2 days old.

As an example, on a Linux environment, the following command can be placed into a shell script file, then run nightly at 1 am.

(1) Shell script file: /path/to/script/cleanTririgaTemp.sh

find -mtime +2 -user tririga -exec rm {} \;

(2) Don’t forget to chmod to make it executable:

chmod u+x /path/to/script/cleanTririgaTemp.sh

(3) Then run crontab -e and set the script to run daily at 1am:

0 1 * * * /path/to/script/cleanTririgaTemp.sh

Continue reading

Why can’t the Cleanup Agent clean large number of records?


I have a problem with a TRIRIGA environment. Due to an inefficient integration, we have a large number of records with a negative Object ID ready to be cleaned by the Cleanup Agent. But it seems that the Cleanup Agent can’t clean that many records.

Can I configure something or execute something into the database to clean everything in parts? I guess that I cannot simply execute a delete into the database, where the object_id < 0, since there must be more things to clean.

No, you should not go into the back end and execute a delete on the database. There is a lot more to clean up. What do you mean the Cleanup Agent cannot clean that many records? Are you getting an exception? The OBJECT_ID must be negative, the OBJECT STATE should be null, and the UPDATED_DATE must be over 24 hours earlier for the Cleanup Agent to pick up the records to delete. It also might take a couple runs of the Cleanup Agent to delete all of the associated records.

[Admin: This post is related to the 02.24.16 post about cleaning up after retiring a record, and the 07.14.15 post about cleaning up millions of workflow instance records. As a side note, starting with version 3.4, the Cleanup Agent name was changed to Platform Maintenance Scheduler.]

Continue reading

Why do “ghost” lease records appear in TRIRIGA?


I found two “ghost” entries for (blank) lease records in TRIRIGA without any Status recorded or ID assigned. When I open the record, I can still see the “Create Draft” button on the record. Has anyone seen this situation?

Typically, these are records that were deleted by some process, but have not been fully removed by the Cleanup Agent yet. Usually, the application filters these out of the query views, but sometimes, for various reasons, they show up in queries as a blank row.

Continue reading

IV89144: CLEAN_TIMEOUT property not working as expected in 3.5.1


With the CLEAN_TIMEOUT property set to 10 minutes, 10 minutes is too low of a setting and not recommended. Typically, it is set to a value to prevent the Cleanup Agent from running too long.

How that property comes into play with the Cleanup Agent is that it runs each cleanup task in order. The cleanup process contains several tasks: cleaning up BO records, workflow instance history, doc tables, etc. Once a task is complete, it looks at the current running time, compares it to the property, and decides whether or not to continue with the next task. With that said, it doesn’t even look like it’s honoring the property at all, based on your logs, because it should have ended at this line:

2016-09-01 22:28:58,117 INFO [com.tririga.platform.dataconnect.JobControlManager](PlatformMaintenanceScheduler) DataConnect Tables Clean up completed at Thu Sep 01 22:28:58 CDT 2016 deleted 0.

Continue reading

How do you clear “Reports To” field when the person is retired?


I have been able to successfully populate this field, but when the manager gets retired, I am having trouble getting the field to be blank…

Because smart sections use references and do not rely on the association alone, you will want to use a Delete Reference workflow task to clear the smart section.  If you only clear the association, then the Cleanup Agent process will detect the reference with the missing association and will restore it.

Continue reading

How do you set the Cleanup Agent to clean data “x” days or older?


How can we change the Cleanup Agent to only clean up data older than “x” days? I saw the CLEANUP_AGENT_SCHEDULED_EVENT_COMPLETE_DAYS property, but this seems to be only scheduled events, rather than all data.

[Admin: This post is related to the 02.24.16 post about executing the Cleanup Agent, including deleting records that are only minutes old.]

Continue reading