- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-15-2024 11:11 AM - edited 03-15-2024 11:12 AM
Hi everyone,
I am encountering an odd issue. In Flow Designer, I have a simple "Look Up Records" action. This should look up records on the sys_documentation table (where Table = sys_user and Language = English). I have created this flow in the Global scope. The sys_documentation table is also in the Global scope, it is accessible from all applications, and has the can read/write/create checkboxes ticked (and cache cleared).
When I run the flow, I get the error "Scope does not have read access to table sys_documentation" which is odd, since everything is in Global scope. It doesn't create a record to mark as "Allowed" in the application cross-scope access, and I'm not able to create one there since source and target scope cannot be the same.
I'm a little bit lost and can't find anything in KBA or elsewhere in Community. Let me know if you have any thoughts!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-15-2024 09:41 PM
Hi @Anna T_,
You are absolutely right, it still fails even if the records are in the Global scope.
I tried a few things in the PDI but unfortunately, nothing seems to work.
One thing I did notice is that you can query the table with a script in a Flow. Hence I am guessing it's something to do with the Look Up Record/Look Up Records actions.
I would recommend raising a Support case and in the meantime you can use a script to query the table.
Cheers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-15-2024 01:08 PM
Hey @Anna T_,
I think it's because the record in the sys_documenation table is in a different scope. Although the table itself is in the Global scope, the record has different scope. e.g.
So you would need to identify the scope of the records that you are querying and grant the cross-scope access.
Hope it helps, cheers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-15-2024 01:15 PM
Hey @James Chun - thanks for looking into this!
Unfortunately, all the records I'm querying are indeed in the Global scope as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-15-2024 09:41 PM
Hi @Anna T_,
You are absolutely right, it still fails even if the records are in the Global scope.
I tried a few things in the PDI but unfortunately, nothing seems to work.
One thing I did notice is that you can query the table with a script in a Flow. Hence I am guessing it's something to do with the Look Up Record/Look Up Records actions.
I would recommend raising a Support case and in the meantime you can use a script to query the table.
Cheers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2024 01:12 PM
Thanks, James. I'm pursuing that path!
Thanks,
Anna