Symptom
"Access to the path specified by the connection is not permitted. Contact your Administrator" error when using an Import File Server Connection in SAP Analytics Cloud (SAC).
Environment
- SAP Analytics Cloud
- File Server Connection
Reproducing the Issue
- Create whitelist.txt file, which lists all of folder paths used for importing data or exporting models.
- Define the file server whitelist using one of the following two methods
- Add the whitelist location in your Tomcat JVM properties.
In Apache Tomcat 7.0, in the Properties menu, select the Java tab. Under Java Options, add one of these lines:- For import data: -DSAP_CLOUD_AGENT_FILE_SERVER_WHITELIST_PATH=<WhitelistFilepath>
For export model: -DSAP_CLOUD_AGENT_FILE_SERVER_EXPORT_WHITELIST_PATH=<WhitelistFilepath>
- For import data: -DSAP_CLOUD_AGENT_FILE_SERVER_WHITELIST_PATH=<WhitelistFilepath>
- Set the operating system environment variable SAP_CLOUD_AGENT_FILE_SERVER_WHITELIST_PATH or SAP_CLOUD_AGENT_FILE_SERVER_EXPORT_WHITELIST_PATH to the location of the whitelist file.
- Add the whitelist location in your Tomcat JVM properties.
- Restart SAP Analytics Cloud Agent.
- In SAP Analytics Cloud, go to
(Main Menu)>>
System >>
Administration >> System Configuration. - For data import, turn on Allow model import from File Server. For model export, turn on Allow model export to File Server
- Go to >>
(Main Menu) >>
Connection >> Connections >>
(Add Connection) >> Import Data Connection >> File Server. - In the dialog, enter a Connection Name, Description, and the Folder Path.
- The Folder Path should match the path listed in your whitelist file.
- Select Create.
- Notice the Error.
Cause
- Incorrect Java option or environment variable.
- The user who started the tomcat process or service does not have the needed permission:
- For import, read permission is required.
- For export, write permission is required.
Resolution
- Specify the complete path including whitelist.txt in the Java Option -DSAP_CLOUD_AGENT_FILE_SERVER_WHITELIST_PATH or environment variable SAP_CLOUD_AGENT_FILE_SERVER_WHITELIST_PATH.
- Make sure the root folder has "List Folder Contents" permission.
- Make sure that the user who has started the tomcat process or service does have the needed permission.
- More details can be found in Product Help.
See Also
Keywords
EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, tomcat tomcat logs, path pthas paths , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem
Product
SAP Analytics Cloud 1.0
SAP Knowledge Base Article - Public