Unable to insert record in group member table through flow designer

Toshu
Tera Contributor

I have a flow designer developed for AD integration with Servicenow through AD spoke

While trying to add user to group in Servicenow instance after adding the users to the AD group I am getting an error that says "Error occurred while inserting record : null"

I have referred to the KB article available but they do not provide a clear fix as expected

I have already referred to these KBs: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0827213

And related KBs to this error but unable to find a fix

 Below is the flow with error execution:

 

find_real_file.png

Actual flow logic:

find_real_file.png

Please let me know if you could find the issue?

 

21 REPLIES 21

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

Did you try to go one more level down to the group and user sysId

Is this happening always?

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hello Ankur, Thankyou for looking into this query

I have tried using the sys_id here but no luck

In fact the funny part is that when I try to do the same activity in another branch without testing a if condition "SAM account name is not empty" in that case it works perfectly fine

In addition to this if I just chose the user but remove the group field while creating the record, A record gets created in the group member table without the group reference but just the user record

Here is the screenshot of the user and group record sys_id getting passed while execution:

find_real_file.png

 

So did you try the subflow based solution shared in the KB?

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader