Support Article
Obj-Open & lookup ignores mili-seconds value in object key
SA-33953
Summary
The user has a use case where they need to copy the attachments from one case to another. All the attachments are committed with pxAttachKey varying only in a few miliseconds. If the user uses Obj-Open in an activity as source on a Data Page, wrong attachment is opened which is seems to be because Pega is not considering milliseconds in Obj-Open.
Error Messages
Not Applicable
Steps to Reproduce
- Create a case and add two attachments such that the pxAttachKey varies only in terms of milliseconds
- Create an activity with Obj-Open to open the attachment.
- Add this activity as a source of a data page with pxRefObj and pxAttachKey as the parameters to the activity and run the data page to test.
Root Cause
Support for Timestamp column for oracle is introduced in Pega 7.1.8 version but all existing Out Of The Box datetime properties are mapped to DATE columns in their corresponding tables. This is the reason why pxAttachKey column is mapped to Date column in table pc_data_workattach which inturn causes the issue.
Resolution
Run the alter scripts to change the column type of pxAttachKey to TimeStamp.
alter table <schema name>.pc_data_workattach MODIFY PXATTACHKEY TIMESTAMP
For example:
alter table pegadata.pc_data_workattach MODIFY PXATTACHKEY TIMESTAMP;
Published February 21, 2017 - 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.