+15Hi,
I’m having an issue with an event where it seems to not be able to access CUSTOMER_ORDER_LINE.
Is there a certain account which needs access whilst going through an event action?
Custom RMB: Works Fine
However the event action doesn’t work...
I’m assuming this is something permission related - but cannot seem to figure it out.
IFSPRINT and IFSSYS have been granted select on CUSTOMER_ORDER_LINE.
Thanks, Callum
Best answer by Harley
As you are seeing the email being generated, the code would appear to be running without error. I am therefore wondering whether this may indicate a potential issue with site access. Try running the code without the where clause to see if data is returned into the part_no variable when the entire view is queried.
+19It's this a custom event? What is the table this action triggers on?
+5Hi Callum,
may be “command_sys.mail” need an “ifsapp.” ? I am not sure but i guess it worths to try.
regards
+9As you are seeing the email being generated, the code would appear to be running without error. I am therefore wondering whether this may indicate a potential issue with site access. Try running the code without the where clause to see if data is returned into the part_no variable when the entire view is queried.
+15It's this a custom event? What is the table this action triggers on?
Custom Event Action - Triggered from standard IFS PDF_REPORT_CREATED Event
Hi Callum,
may be “command_sys.mail” need an “ifsapp.” ? I am not sure but i guess it worths to try.
regards
Won’t be this as still receiving the emails through
As you are seeing the email being generated, the code would appear to be running without error. I am therefore wondering whether this may indicate a potential issue with site access. Try running the code without the where clause to see if data is returned into the part_no variable when the entire view is queried.
Spot on! - I commented out the site check in CUSTOMER_ORDER_LINE and the data pulled through.
Next step was to figure out which user needs access which turned out to be IFSCONNECT - I never knew this account needed site access for anything!
+22Hi
Check your Print formatter settings and see if the Execute As is set to System. That could be the reason why you need to grant access to IFSCONNECT.
Changing it to Initiator should do the trick :)
Cheers!
+15Hi
I was unable to find a window in IEE.
Thank you.
+22Hi
I was unable to find a window in IEE.
Thank you.
Hi
Probably you already found the solution.
Here’s how you can change the report formatter settings
In Apps10
Apps 9
Cheers!
Damith
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
