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

Open the Pulse component for any Service Order.
Attach any content to the newly created Pulse message.
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.