Support Article

pxFeed Pulse entry with attachment not saved.

SA-83288

Summary



Unable to attach an attachment in the context of any case.


Error Messages



Error message in the Tracer (Step 17), pzSavePostMessage (Pega-Social:07-10-35):

Cannot write property pyFileSize to a decimal column--its value, "0 B", is not a decimal: code: SQLState: Message:


Steps to Reproduce

  1. Open the Pulse component for any Service Order.
  2. Attach any content to the newly created Pulse message.
  3. Post a message. The message is not created.


Root Cause



A defect in Pegasystems’ code or rules.

The pyFileSize is of Decimal type. However, while uploading documents from Pulse, the pxUploadFile activity has a step to store the file size as MB, KB, or Bytes. The conversion is implemented and the value is manipulated as a string (for example, 198.23 KB ). 
Hence, while retrieving the pyFileSize property, SQL displays an exception while parsing. This is because the pyFileSize property is stored as a string.

The error occurred because an incorrect value is set for pyFileSize - temporary page UploadedFilePage (Data-WorkAttach-File). The calculated value is equal to 0 when the file size is greater than 0.

The value 'B' is added to the calculated size. Since, the pyFileSize is of type Double, it must not contain letters.
Later in the process, when the POST is committed, SQL generated the error since the value is incompatible with the column type in the database system.


Resolution



Apply HFix-54092.

Published July 2, 2019

Have a question? Get answers now.

Visit the Pega Support Community to ask questions, engage in discussions, and help others.