Support Article
Unable to delete file with special characters stored in alfresco
SA-71262
Summary
Unable to delete files stored in Alfresco from the Manager portal.
Error Messages
Not Applicable
Steps to Reproduce
- Log in to application.
- Navigate to Designer Studio.
- Configure a Content Management Interoperability Services (CMIS) to store attachments of a case (in this case, Alfresco).
- Delete the attachment after adding it to the case.
Root Cause
When the file is uploaded and deleted, a database error occurs during a commit of an SQL Query which inserts the file details in to the PR_HISTORY table. A column is (ACTION) present which stores the file name (which is the complete String specified from the UI) in to the database. The size for this column is 64 bytes.
By default, Pega adjusts the data input from UI text field to 63 characters and adds a '+' symbol by truncating the file name such that it is saved in the database to be added to a 64 character VARCHAR Column. This works until ASCII characters are used where the 'I' character is equal to 1 Byte and for the 64 byte column, 64 character string can be saved.
Resolution
Perform the following local-change:
- Increase the column size to a greater length such that Bytes are not expected for the File Name.
- Restrict the File Name on the UI by introducing a Validation check such that not more than 20 characters can be entered.
Published March 8, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.