User was getting the below error while submitting a purchase requisition to the workflow. He has all the required security roles and the worker has assigned to his user account. But, but still getting this error.
Reason: After spending some time, I found that there were multiple worker's created for the same user account. Due to that "DirPersonUser" table has duplicate records for the same user and it is causing the problem.
Solution: Delete duplicate records from the DirPersonUser table. I used the below query to delete the records in DEV environment. And, opened a ticket to Microsoft to run in Production environment.
After deletion of the records, assign the worker to the user account and try again.
delete DPU from DirPersonUser as DPU
inner join DIRPARTYTABLE on DPU.PERSONPARTY = DIRPARTYTABLE.RECID
where DPU.USER_ = 'rahul'-- Add the userid here
@Rahul
No comments:
Post a Comment