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

How do you set the Cleanup Agent frequency to every “x” records?


Our client is having issues where the Oracle undo tablespace is filled up when the TRIRIGA Cleanup Agent is running. At the moment, the solution has been to continually increase the size of the undo tablespace. But we are wondering if there is a way to set the Cleanup Agent to commit to the database every “x” records? At the moment, it only seems to commit once the agent has finished running.

[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

How do you unretire and return records to a null state in bulk?


How do I do a mass-change of status from “Retired” to “Unretire” (Active), so that I can delete, i.e. change TRIRECORDSTATESY to “null”?

What happened was that I added Action Type (System Delete), Action Name (Delete) to my navigation item. However, when I used that “Delete” function after selecting multiple records on my query, the records just went from “Active” to “Retired”, which left it as TRIRECORDSTATESY = triRetired. I reviewed the state transition for that business object, and the transition can go from Null > triActive > triRetired.

Do I have to add a custom action to my navigation item to “Unretire” the records? And then add another custom action to my navigation item to set the TRIRECORDSTATESY to “null”? What value do I put in the Action Name?

[Admin: This post is related to the 02.24.16 post about executing the Cleanup Agent (a.k.a. Platform Maintenance Scheduler) after retiring a record, and the 04.13.16 post about moving a record to the null transition state.]

Continue reading