Support Article
Unable to save attachments from Pega to different table
SA-31732
Summary
User has created a separate table to store attachments. The table contains pyAttachStream and WOAttachment columns of type blob.
An error occurs when connecting to the table stating these are unsupported.
Error Messages
Class Org-Data-AttachmentData is mapped to table ATTACHMENTS in database PegaRULES, which has column PYATTACHSTREAM of unsupported type BLOB.
Class Org-Data-AttachmentData is mapped to table ATTACHMENTS in database PegaRULES, which has column WOATTACHMENT of unsupported type BLOB.
Steps to Reproduce
- Create a custom Attachments table with pyAttachStream and WOAttachment columns of type blob.
- Map the Org-Data-AttachmentData class to the Attachments table.
- Test the connection.
Root Cause
An issue in the custom application code or rules. Custom blob columns are not supported.
The product is only able to read and write data to the internal pzPVStream blob column.
Resolution
User will need to write custom code to write the blob column in the external table.
One option would be to use a java step or function to execute a custom PreparedStatement to insert and read the data, including the blob column.
Published December 27, 2016 - 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.