WillieW
Tera Expert

Hi,

 

I see the following from running your script in my PDI

Time: 0:00:00.132 id: dev309441_1[glide.3] primary_hash=763426233 (connpid=78167) for: SELECT sys_restricted_caller_access0.`description`, sys_restricted_caller_access0.`target_scope`, sys_restricted_caller_access0.`source`, sys_metadata0.`sys_updated_on`, sys_metadata0.`sys_class_name`, sys_restricted_caller_access0.`rca_type`, sys_metadata0.`sys_id`, sys_metadata0.`sys_updated_by`, sys_metadata0.`sys_created_on`, sys_restricted_caller_access0.`target_table`, sys_metadata0.`sys_name`, sys_metadata0.`sys_scope`, sys_metadata0.`sys_created_by`, sys_restricted_caller_access0.`target_type`, sys_metadata0.`sys_mod_count`, sys_restricted_caller_access0.`source_type`, sys_restricted_caller_access0.`target`, sys_metadata0.`sys_package`, sys_metadata0.`sys_update_name`, sys_restricted_caller_access0.`source_scope`, sys_restricted_caller_access0.`operation`, sys_restricted_caller_access0.`source_table`, sys_restricted_caller_access0.`status`, sys_metadata0.`sys_policy` FROM (sys_restricted_caller_access sys_restricted_caller_access0  INNER JOIN sys_metadata sys_metadata0 ON sys_restricted_caller_access0.`sys_id` = sys_metadata0.`sys_id` )  WHERE sys_restricted_caller_access0.`source_scope` = 'global' AND sys_metadata0.`sys_scope` = sys_restricted_caller_access0.`target_scope` ORDER BY sys_restricted_caller_access0.`sys_id` /* dev309441002, gs:F53F6DA6479EAE106B3ABB30116D43BC, tx:9cd0792e479aae106b3abb30116d4367, hash:763426233 */ 
Source descriptor is empty while recording access for scope ServiceNow Key Management Framework: no thrown error
Security restricted: Read operation on scope 'ServiceNow Key Management Framework' from scope 'Global' was denied because the source could not be found. Please contact the application admin.
Source descriptor is empty while recording access for scope ServiceNow Key Management Framework: no thrown error
Security restricted: Read operation on scope 'ServiceNow Key Management Framework' from scope 'Global' was denied because the source could not be found. Please contact the application admin.
*** Script: Total: 503 Found: 0

Seems some Cross-scope access is needed.