Unable to insert record in group member table through flow designer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-13-2022 04:16 AM
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:
Actual flow logic:
Please let me know if you could find the issue?
- Labels:
-
flow designer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-13-2022 04:29 AM
Hi,
Did you try to go one more level down to the group and user sysId
Is this happening always?
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-13-2022 04:54 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-13-2022 05:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-13-2022 05:45 AM
So did you try the subflow based solution shared in the KB?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader