Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
julian_jimenez
Active Contributor
SAP Analytics Cloud (previously known as SAP BusinessObjects Cloud) requires a few steps to allow you to acquire data from your internal network. The intention of this guide is to help you follow some steps to find out what is not working.

 

I presume that you have already checked this blog that will guide you step-by-step to configure your system: Enable SAP Analytics Cloud for data acquisition from on-premise systems

Remember that the product's documentation is always up-to-date and you will find there the information that you need to configure the software.

  1. Problems installing or configuring SAP Cloud Platform Connector

  2. Problems with Tomcat or SAP Analytics Cloud Agent (C4A_AGENT)

  3. Errors in SAP Analytics Cloud tenant

  4. Errors connecting to specific Data Sources


1. Problems installing or configuring SAP Cloud Connector


1.1. You can't even install SAP Platform Cloud Connector.


You may get the following error: There is a problem with this Windows Installer package. A DLL required for this install to complete not be run. Contact your support personnel or package vendor.



Big Problem, easy solution:

You need to install Microsoft Visual Studio C++ 2013 runtime libraries (vcredist_x64.exe).

1.2. You can start the new service SAP Cloud Connector but the page http://localhost:8443 doesn't respond


You may get the following error: ERR_CONNECTION_REFUSED

You have probably selected Oracle JVM during installation of SAP Cloud Connector (SCC).

Install SAP JVM as indicated in the product's guide. You can download SAP JVM directly from this link: https://tools.hana.ondemand.com/#cloud

1.3. I don't know the username/password to log in


The default credentials are:

user: Administrator

password: manage

1.4. My SAP Analytics Cloud URL is eu1 but I don't see that Region Host


EU1 = hana.ondemand.com

Because Europe is the center of the HANA Universe


1.5. I must have configured something wrong as I see Subaccount Name


This is a unique name for your SAP Analytics tenant. It is something similar to a11f22c3c. It is given by Cloud Operations.

If you are really curious, you can get the complete explanation here:

https://blogs.sap.com/2016/10/21/part-1-understanding-hcp-global-accounts-sub-accounts-concept-means...

Your configuration should look like this:



Note: Your Region Host may be different. Use the one indicated by Cloud Operations.

We leave the Location ID empty.

1.6. After saving, I get error 417




Verify that the information is correct and matches the information provided for your tenant.

Try to connect to this URL using your S-user and password:

https://account.hana.ondemand.com

If you get an error, you should Open a ticket with SAP Product Support using the component  LOD-ANA-BI adding the following information:

  • The URL of your SAP Analytics Cloud

  • S-User ID used

  • Account Name


1.7. Status shows error


An error occurred when trying to connect - see logs details (unless log level is 'Off'): 

Unable to connect: A different cloud connector instance is already connected to this subaccount



SCC logs shows the following line
Invalid status of handshake response: 409 Conflict

Probably you installed two different servers with SAP Cloud Connector and you left one connected. Disconnect the first server installed.

 

2. Problems with Tomcat or SAP Analytics Cloud Agent (C4A_AGENT)


Installing SAP Cloud Connector and configuring your Subaccount only opens the channel between your SAP Analytics Cloud tenant and your network. You need to install drivers for the different data sources that you want to connect to. That is the job of the C4A_AGENT.war deployed in Tomcat.

2.1. Installing the correct version of Tomcat and JAVA


If you don't know what version to install, go for a stable version: http://tomcat.apache.org/download-80.cgi#8.0.45

You can use the standard Oracle JVM. I would recommend the latest 8 available.

2.2. Users and roles in Tomcat


Verify that you have the following roles created and assigned to your account in the file tomcat-users.xml
<role rolename="sap.fpa.admin"/>
<role rolename="Services"/>
<user username="AgentName" password="AgentPassword" roles="Services,sap.fpa.admin" />

Note: the sap.fpa.admin role is only required for acquisition of Active Directory users, but it doesn't hurt.

2.3. How to test the Tomcat user and verify the version of the Agent


Remember to change the port, if the default port was changed. If the server is responding, check the following URL:

http://localhost:8080/C4A_AGENT/deploymentInfo

You will be prompted for a username/password. Use the one created in tomcat-users.xml.

After authenticating, you will display a simple line like this:
{"version":"1.0.67"}

 

2.4. Tomcat is not responding or the user doesn't work


Verify the Tomcat logs in your <TOMCAT_INSTALL>/logs/ folder to identify possible conflicts of ports.

Check that the tomcat-users.xml information is not commented. The whole section is commented by default.

 

2.5. SAP Analytics Cloud Agent incorrectly deployed


Verify that you have correctly deployed the file C4A_AGENT.war file




  1. Stop Apache Tomcat

  2. Remove the temporary folder <Tomcat_Installation>\work\catalina\localhost\C4A_AGENT

  3. Remove the deployed <Tomcat_Installation>weapps\C4A_AGENT folder

  4. Verify that you have agent war file: <Tomcat_Installation>weapps\C4A_AGENT.war

  5. Start Tomcat


The deployment should start automatically.


2.6. What version of SAP Analytics Cloud Agent should I be using?


The answer is: depends. As mentioned, the Agent is middleware connecting to your data sources, depending on your data sources, you will need a different version. My recommendation: download the latest version available.

For more information, visit the System Requirements and Technical Prerequisites page and the section: SAP Analytics Cloud Agent

 

3. Errors in SAP Analytics Cloud tenant


If something does't work in this section, you will get an error like this when testing your configuration:
"Failed to call SAP Analytics Cloud agent. 
Please contact your administrator to ensure that SAP Analytics Cloud agent is running,
is configured correctly, and is reachable from the SAP HANA Cloud Connector.
HTTP Status: /deploymentInfo"



There are multiple possibilities:

  • You typed incorrectly the username/password. It should be the ones used in tomcat-users.xml

  • There is something incorrectly configured in SAP Cloud Connector:

    • Missing /C4A_AGENT/ application

    • Not added path and subpaths

    • Incorrect hostname or port for Tomcat

    • The Location ID in SAP Cloud Connector contains a value. You should leave it empty



  • Verify if there is communication in the section Logs in your SAP Cloud Connector


 

4. Errors connecting to specific Data Sources


What we have seen so far are the most common errors. However, you may experience problems using your own Database JDBC drivers or connecting to specific BW systems.

To enable debug in Tomcat you need to modify the file lo


${catalina.base}/conf/logging.properties

1catalina.org.apache.juli.FileHandler.level = FINE

Can be set to SEVERE, WARNING, INFO, CONFIG, FINE, FINER, FINEST or ALL

More details about Apache Tomcat Troubleshooting and Diagnostic documentation can be found at:

https://wiki.apache.org/tomcat/FAQ/Troubleshooting_and_Diagnostics

4.1. Connecting to BW


The type of errors that you will find are similar to this one:

Connection to BW system failed: Connect to SAP gateway failed ERRNO TEXT  WSAETIMEDOUT: Connection timed out

 

In this example, the BW system did not respond. Verify that the application name used is correct.

4.2. Connecting to an SQL Databases:


You can find similar errors connecting to SQL Server when the port or the server name are incorrect:

Unable to connect to SQLServerName:1433. Ensure that the connection details are correct.

Check network connectivity between the your database server and the server hosting the SAP Analytics Agent.

 

4.3. Connecting to a File store


BOC is also responsible to connect to your internal file system. To configure the Tomcat JAVA parameter correctly check the documentation.

You can find errors in the usual menu: System > Monitor > Traces


A typical error would be:


Access to the specified path is denied by the file system.


You need to verify the rights assigned to the shared folder. If it is Windows or the rights for the NFS or other filesystem mounted.


Verify that the file system is listed in the file you used for this parameter: DSAP_CLOUD_AGENT_FILE_SERVER_WHITELIST_PATH


The Apache Tomcat will log an error like this:


Aug 01, 2016 3:46:14 PM com.sap.fpa.cloud.internal.DAException logException


SEVERE: ACCESS_DENIED: [\\servername.yourdomain.com\share_folder\]


 

3.4 Connecting to SAP ERP

The Apache Tomcat log ("tomcat7-stderr.<YYYY-MM-DD>.log") will show and an error like this:

 

<Date> <Time> com.sap.fpa.cloud.rest.cs.service.ValidateLogonService execute


SEVERE: Initialization of destination CS_DEST-<ERP CONNECTION DETAILS> failed: Connect to SAP gateway failed


Connection parameters: TYPE=A DEST=CS_DEST-<ERP CONNECTION DETAILS>


 

LOCATION CPIC (TCP/IP) on local host with Unicode


ERROR partner '<ERPHOST>:<ERPPORT>' not reached


TIME <DATE> <TIME>


RELEASE <VERSION>


COMPONENT NI (network interface)


VERSION <##>


RC -10


MODULE nixxi.cpp


LINE 3283


DETAIL NiPConnect2: 10.1.102.3:3302


SYSTEM CALL connect


ERRNO 10060


ERRNO TEXT WSAETIMEDOUT: Connection timed out


COUNTER 2


Check if the <ERPPORT> is blocked by firewall by using the following command: telnet <ERPHOST> <ERPPORT>

 

If telnet fails then work with your firewall Administrator to open the port.
27 Comments