Know more about instances of pr_data_file
We see many entries in pr_data_file with file extension of jpg,jpeg & png , seems to be the instances are creating while file is being uploaded in portal using pxUploadFile control but it's not getting deleted later ,Hence the file is being ended up in two tables like pr_data_file & pc_data_workattach.
When system should supposed to be deleted these files from pr_data_file ?
Is there any issue if we remove them by running script in database .
Updated: 27 May 2025 13:32 EDT
Capgemini
FR
In Pega, files uploaded via the pxUploadFile control are temporarily stored in the pr_data_file table during processing. These entries should be automatically deleted once the file is successfully attached to a work item and moved to the pc_data_workattach table (associated with Data-WorkAttach-File). However, orphaned entries in pr_data_file may persist due to an incomplete file attachment process (e.g., exceptions during upload/attachment).
I recommend to investigate root causes first before going into manual deletion by auditing the file attachment workflows for unhandled exceptions
If you think that manual deletion is unavoidable, test extensively in non-production environments first