Problem Note 67065: The SAS® Viya® 3.5 File microservice fails and a warning is generated in the log
 |  |  |  |  |
In SAS Viya 3.5, the File microservice fails, and the following error is displayed in the log:
2020-09-10 13:22:29.218 ERROR 92906 — [auto-1-exec-176] com.sas.commons.rest.ExceptionLog : FS100638 [56455306ddd9f1d6] caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "file_meta" violates foreign key constraint "file_meta_fk01"
Detail: Key (content_id)=(c3de1148-7366-41c7-beb3-7dbd9d7b609a) is not present in table "file_content".
When the File microservice tries to update content and to patch file metadata concurrently, the software creates a new content ID. As a result, the current content ID becomes obsolete, and the failure occurs.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya | Linux for x64 | 3.5 | 2020.0.6 | Viya | Viya |
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2020-12-14 08:59:33 |
| Date Created: | 2020-12-09 15:42:27 |