Venio Console: Empty Relative File Path

Problem

We have been experiencing some issues with some items on a particular Project that Relative File Path is empty. Consequently, this is affecting our "All Locations Overlay" as the Duplicate File Path is not being populated on these.

These items were were manually moved to a specific ParentID and therefore some additional updates might be needed via SQL

Reference Ticket 13284

Resolution

Please follow the following steps to fix for the specific file ids:

1. Backup project database.
2. Execute query below in project database.

update tbl_ex_FileInfo set IsParent=1,IsEmbedded=0,GroupId=FileId WHERE FileId IN (fileids of the probematic files)


EXEC sp_su_SetMediaSummary <media id of the above fileid>,1,1,1,1