Sunday, 21 February 2021

SysWorkflow - Submit SysWorkflowDocument-assertPermission SysWorkflowDocument-assert user not found error while submitting the purchase repulsition to the workflow Dynamics 365 finance

 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

Adding a newline into a string in C# and X++

Below is the sample code we can use for  adding a newline after every occurrence of "@" symbol in the string in C#   using System...