The problem behaviour is as follows:

• When launching a file, you get the message "Document Is Unavailable".
• A full error message appears, containing the two messages within the error text:

• For the affected file, the Filename field is blank.

This issue can appear as a result of a temporary problem with the main service, where the service attaches the file successfully but does not properly record its name.

Solution

The problem can be fixed using the script Ideagen Internal Audit (Aura) - Populate missing DocumentInfo.FileName from Attachment or Report title.sql.

To run:

• stop the Ideagen Internal Audit (Aura) robot service
• stop the Pentana application pools
• if Retain is used, stop the Retain Server service
• back up the Pentana database and verify
• if Retain is used, back up the Retain database and verify
• run this script - it should run without error
• restart the Pentana app pools
• restart the Ideagen Internal Audit (Aura) robot service
• if Retain is used, restart the Retain service
• verify effect of change

Root cause and further investigation

This issue can appear as a result of a temporary problem with the main service.

The issue is cleared after a restart of the service’s application pool, but there may be additional  issues  that need investigating – more information here:  Ideagen Internal Audit (Aura): Logged error "Could not fetch business rules because query of type Behavior could not be executed"