Who is this article for?

Users who encounter the issue on the desktop application

Application server and Database server access is required to troubleshoot.

Some users report seeing time sheets where lines appear for tasks that have no name. This article explains the cause and provides steps on how to resolve it.

1. Issue
2. Solution

1. Issue

When opening a Time Sheet, you may find that some lines appear with no name.

This occurs after the Delete Audits customisation has been run, normally to purge old data.

During this process, records for audits are deleted but the users' time sheet records remain.  This means that for each line in a time sheet where there is no longer an audit, a blank name must be shown.

2. Solution

To resolve the issue, run the attached script against the database.

This will create a "dummy" audit (that is not visible on the Audits screen), and associate these time sheet rows with that audit.  This will consolidate all 'blank' lines against the dummy audit, making it clearer that the row is for an audit that no longer exists.

To run the script:

1. Stop the Retain Server service (if present).
2. Stop the Ideagen Internal Audit (Aura) robot service.
3. Stop the Pentana application pools.
4. Back up the Pentana database and verify.
5. Back up the Retain database and verify (if present).
6. Run the script.
   It should run without error.
7. Restart the Retain service (if present).
8. Restart the Pentana app pools.
9. Restart the Ideagen Internal Audit (Aura) robot service.
10. Verify effect of change.