This is Error Message:
"Java Exception: com.pega.dsm.dnode.api.dataflow.StageException: Exception in stage:"Java Exception: com.pega.dsm.dnode.api.dataflow.StageException: Exception in stage: “Data-Class”
Problem doing a database commit: code: 4021 SQLState: 61000 Message: ORA-04021: timeout occurred while waiting to lock object
This error usually comes when there’s a delay in releasing the lock from another session. Can you check before commit the lock is actually taken?
@SohamM95 Thank you for your reply, But this error occured in a Data flow stage is a class which mapping to table pr_other. I can not find which record is locked.
Can you run the data flow in non business hours and see if it fails?
@SohamM95 Yeah,I run this data flow in development env .It will be correct.
So while users are online, the flow is trying to take action on data which is locked. You need to run it during off-business hours or educate users to close all open work before running the flow.