Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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

  1. Log in to application.
  2. Navigate to Designer Studio.
  3. Configure a Content Management Interoperability Services (CMIS) to store attachments of a case (in this case, Alfresco).
  4. 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:
  1. Increase the column size to a greater length such that Bytes are not expected for the File Name.
  2. 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

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us