Hi,
I have a workspace where I use the oracle database connections as a variable. This works fine. When a runs the workspace a published parameter determines which connection is used.
But when I publish this on fme server. I get an authorisation failure:
FME Server error: `Unauthorized request by user due to lack of proper permissions for connection: **@**. Please see: http://fme.ly/zn8'
Connections in fme server are available as in the variable.
The error message indicates that the database connection hasn't been shared with the user running the workspace. Is that possible?
I was looking into that and found that it works when I enter the connection manually. But only when running the workspace directly from fme server. When I launch it with an app I get the same error. So is there something different when using a fme server app?
I was looking into that and found that it works when I enter the connection manually. But only when running the workspace directly from fme server. When I launch it with an app I get the same error. So is there something different when using a fme server app?
Look in the FME job log after being executed by the automation, and search for "FME_SECURITY_USER" and "FME_SERVER_RUNTIME_USER_ID". The username specified for this parameter must have explicit access to the database connection.
Found the solution in token management. Did not realize the app is using deparate permissions.
Look in the FME job log after being executed by the automation, and search for "FME_SECURITY_USER" and "FME_SERVER_RUNTIME_USER_ID". The username specified for this parameter must have explicit access to the database connection.
Found it. Thanks for your replies.