AnsweredAssumed Answered

accesses internal tables workflow

Question asked by Loumer Joseph Morales on May 28, 2019
Latest reply on May 28, 2019 by Boris Lekumovich



I am trying to migrate the workflows from 7.0.1 to 7.1.1 and added a two SQL Select for Manual Account Activities Workflow. Then I copied the SQL query from 7.0.1 to 7.1.1 and it gives me warning that Accesses internal tables.


SQL Select 1 contains:

select TECHNICAL_OWNER from avuser.t_applications where NAME = ${access_request_cri_app_name}


SQL Select 2 contains:

select entitled_id as OtherTechnicalOwners from avuser.t_av_security_values where (reference_key = 'APP_OTO' AND reference_id =(select ID from T_APPLICATIONS where NAME = ${access_request_cri_app_name}))


For additional details please refer at the images below:


This is the error/warning message when I clicked save.



The two SQL Select Nodes became yellow that indicates something went wrong.


What causes this error and how can I fix it? Thank you in advance.