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

Hi,

 

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.

Outcomes