3243214 - Unable to acquire data from SBOP BI Universe when using SAP Analytics Cloud Agent (or Simple Deployment KIT) version 1.0.353/1.0.354 and higher

• Unable to acquire data from SBOP BI Universe when using SAP Analytics Cloud Agent (or Simple Deployment KIT) version 1.0.353/1.0.354 and higher
• Error observed in Chrome network trace (HAR file):
  
  • {"result":"{\"status\":\"Error\",\"error\":{\"code\":\"ERROR_IN_DAE_C4AAGENT_SERVICE\",\"rawError\":\"\",\"params\":[]},\"httpStatus\":500}"}
  • {"result":"{\"status\":\"Error\",\"error\":{\"code\":\"ERROR_BAD_REQUEST_TO_C4A\",\"rawError\":\"\",\"params\":[]},\"httpStatus\":400}"}

• SAP Analytics Cloud, Enterprise Edition
• SAP Analytics Cloud Agent 1.0.353 and higher
• SAP Analytics Cloud Agent Simple Deployment Kit 1.0.353 and higher

1. Follow the user guide to install SAP Analytics Cloud Agent or install SAP Analytics Cloud Agent Simple Deployment Kit.
2. Follow the user guide to Configure the Cloud Connector and also Configure SAP Analytics Cloud Agent.
3. Log on to SAC tenant and then try to create import data connection to SAP Universe.

• SAP Cloud agent 1.0.353 and higher bundles SBOP Connection Sever 4.3 which requires additional SAP Crypto libraries that is not available out of box and will require additional manual configuration.
• There is also an installation issue leading to conflicting duplicate JAR files being installed.
• Finally, one of the bundled JAR files is only compatible with BIP 4.3 SP01 and above. If you are using an older BIP release, you should replace the JAR with the one from your BIP installation.

For Windows :

1. In the base directory of the SAC Agent or Simple Deployment Kit ZIP, retrieve the files under "win64_x64"
2. Extract the contents of the directory "tp.sap.cryptolib", and place it under your Apache Tomcat installation folder in the path, for example "tomcat9\lib\"
3. The contents should all reside directly under the indicated directory, for example "tomcat9\lib\sapcrypto.dll", along with the rest of the corresponding files
4. To configure Tomcat:
   
   
   • Through GUI:
     
     
     1. For Apache Tomcat standalone install, start Tomcat configure tool.
     2. If Tomcat configure tool GUI is not available, please manually configure Apache Tomcat accordingly.
     3. For Simple Deployment Kit, navigate to the tools subfolder of the Cloud Agent Kit installation (e.g. \SAP\SACAgentKit\tools) and run the editTomcatServiceConfig script "editTomcatServiceConfig.bat"
     4. In Apache Tomcat configuration tool, click on the "Java" tab. You will enter a line of configuration under "Java Options:"
     5. Set the -Djava.library.path to where the "tp.sap.cryptolib" files are located
     6. Add -Djava.library.path=C:\Program Files\SAP\SACAgentKit\tomcat9\lib
   • Manually or on Linux without GUI: "
      
     

1. 1. 1. 1. Modify catalina.bat or Catalina.sh script
         2. Locate JAVA_OPTS and append the new variable and files path to existing variable inside the double quotes.
            
            • -Djava.library.path=C:\Program Files\SAP\SACAgentKit\tomcat9\lib
         3. Save the file
2. Restart your Cloud agent / Tomcat

For Linux :

1. In the base directory of the SAC Agent or Simple Deployment Kit ZIP, retrieve the files under "linux_x64"
2. Extract the contents of the directory "tp.sap.cryptolib", and place it under your Apache Tomcat installation folder in the path, for example "tomcat9\lib\"
3. The contents should all reside directly under the indicated directory, for example "tomcat9\lib\libsapcrypto.so", along with the rest of the corresponding files
4. To configure Tomcat:
   
   
   • Through GUI:
     
     
     1. For Apache Tomcat standalone install, start Tomcat configure tool.
     2. If Tomcat configure tool GUI is not available, please manually configure Apache Tomcat accordingly.
     3. For Simple Deployment Kit, navigate to the tools subfolder of the Cloud Agent Kit installation (e.g. /SAP/SACAgentKit/tools) and run the editTomcatServiceConfig script "editTomcatServiceConfig.sh"
     4. In Apache Tomcat configuration tool, click on the "Java" tab. You will enter a line of configuration under "Java Options:"
     5. Set the -Djava.library.path to where the "tp.sap.cryptolib" files are located
     6. Add -Djava.library.path=[your SAC agent installation folder]/tomcat9/lib
   • Manually or on Linux without GUI: 
     

1. 1. 1. 1. Modify catalina.bat or Catalina.sh script
         2. Locate JAVA_OPTS and append the new variable and files path to existing variable inside the double quotes.
            
            • -Djava.library.path=C:\Program Files\SAP\SACAgentKit\tomcat9\lib
         3. Save the file
2. Restart your Cloud agent / Tomcat

REMOVE DUPLICATE JARs (all platforms)

In the C4A_AGENT/WEB-INF/lib folder, remove the following files :

• ./org.eclipse.emf-org.eclipse.emf.common.jar
• ./org.eclipse.emf-org.eclipse.emf.ecore.jar
• ./org.eclipse.emf-org.eclipse.emf.ecore.xmi.jar
• ./org.eclipse.osgi-org.eclipse.equinox.common.jar
• ./org.eclipse.osgi-org.eclipse.equinox.registry.jar
• ./org.eclipse.osgi-org.eclipse.osgi.jar
• ./com.sap.components.Connectivity-com.businessobjects.connectionserver.jar
• ./com.sap.components.Connectivity-com.sap.connectivity.foundation.jar

INSTALLING THE JAR FROM BIP (if connecting to a BIP release prior to 4.3 SP01)

In the C4A_AGENT/WEB-INF/lib/standalone/ConnectionServer/java folder, replace the cs_corba.jar with the one found in your BIP install, in the folder {BIP install folder}/SAP BusinessObjects Enterprise XI 4.0/dataAccess/connectionServer\java

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
• Search for SAP Analytics Cloud content using Google or Bing:
  
  • https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add relevant text or warning/error messages to the text search field to filter results.
• Need More Help? Contact Support or visit the solution finder today!

Your feedback is important to help us improve our knowledge base.

AP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, SAC agent, agent, kit, post, installation, configuration, configure, manual, manually, 353, universe, import, acquire, connection , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem