Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Vendor Approval error - 'GetAssignedUsers' failed because parameter 5 is not allowed to be null

Posted on by Microsoft Employee

I am trying to implement workflow while creating a vendor but I am getting the following error

'GetAssignedUsers' failed because parameter 5 is not allowed to be null.[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'WorkflowInstanceID', table

I have two steps - step 1 is successful but step 2 is giving me this error. When I ran the profiler, I got the following error

 

Msg 6569, Level 16, State 1, Procedure GetAssignedUsers, Line 7

'GetAssignedUsers' failed because parameter 5 is not allowed to be null.

Msg 515, Level 16, State 2, Procedure wfCreateHistoryRecord, Line 8

Cannot insert the value NULL into column 'WorkflowInstanceID', table 'TWO.dbo.WF30100'; column does not allow nulls. INSERT fails.

The statement has been terminated.

I double checked table WF30100 and there is nothing wrong with that too.The instance ID is there. I think someone must have noticed this error but I am unable to fix it. Even I verified the setup tables and they are perfect. I am using 2015 R2.


*This post is locked for comments

  • Gina Chettle Profile Picture
    Gina Chettle 215 on at
    RE: Vendor Approval error - 'GetAssignedUsers' failed because parameter 5 is not allowed to be null

    Hi Kumar,

    I am having the same issue.  Were you able to find the resolution?

    Thank you!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Vendor Approval error - 'GetAssignedUsers' failed because parameter 5 is not allowed to be null

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans