Pentana Audit: Error opening attachment: "Document Is Unavailable" and Filename is blank
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:
EXCEPTION: Exception message: An error occurred during the Open File workflow |
EXCEPTION: UnauthorizedAccessException message: Access to the path 'C:\Users\[user name]\AppData\Local\Vision\Pentana (6013)\Docs\Downloads\6a89151c-4098-4fa7-8ec6-e409c01aea6c' is denied. |
- 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 Pentana Audit - Populate missing DocumentInfo.FileName from Attachment or Report title.sql.
To run:
- stop the Pentana Audit 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 Pentana Audit 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: Pentana Audit: Logged error "Could not fetch business rules because query of type Behavior could not be executed"