Support Article
Issue with update query
SA-40691
Summary
User is trying to update a column value in a table, initially it is getting updated and after some time it is getting rollback automatically.
Error Messages
Not Applicable
Steps to Reproduce
1. Execute update query on exposed column in database.
2. Execute the select query after some time.
3. Use can see value old value.
Root Cause
User is executing update query on exposed column in database caused the issue as it’s not updating the value in pzPVStream column.
Resolution
Here’s the explanation for the reported behavior:
Updated value revert back from pzPVStream when you are saving the instance of the work object using Obj-Save method of Pega application.
Published October 5, 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.