Skip to main content

Hi,

I’m trying to call a custom API from an IAL in IFS Cloud.  The procedure is in a custom ‘develop on the inside’ utility package written and deployed from IFS Developer and works fine when called from projections.  The IAL also works fine if a standard IFS API procedure is called.

I have added IFSAPP. prefix to the procedure call in the IAL query and as a result of this Community question I’ve also tried the @AO.. prefix (although that seems to apply to APPS10).

Either of these result in the background job getting stuck in ‘Executing’ with progress shown as ‘Copying data’.

I have also granted execute privilege on the package to IFSINFO.

Is there something else I need to do to get the IAL to populate?

 


 

Hi ​@MMcK,

Even in IFS Cloud version you have to use &AO.. prefix when using any object in IFSAPP schema in the IAL view.

Can you login to the DB as IFSINFO user and try to execute the same IAL view and see whether it returns data?
How about using the IAL in “live data” mode? Does that work for you?

BR,

Subash   

Hi Subash

Many thanks for your reply.  We got round the problem using more complex SQL to replace the custom API calls.

TBH, I’m not sure how I can log in to the DB as IFSINFO.  We don’t have a documented password and there’s no option to set it in IFS.

Best regards,

MMcK

​@MMcK the IFSINFO password should be in your ifscloud-values.yaml
Custom values yaml example - Technical Documentation For IFS Cloud

The other issue outside of ​@subashfestus suggestion of using `&AO..` and `&IAL..`

could have been access issue for IFSINFO

Row Level Security can cause it not to have access to views. If that is a requirement, you can add IFSINFO to the company and site.

This is because all views use `...WHERE EXISTS (SELECT 1 FROM user_allowed_site_pub...`

 

Reply


Terms & ConditionsCookie settings