We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

SAP Connection

r-m
New Contributor
New Contributor

Hello,

I'm trying to connect to SAP ERP using the SAP connector. 

We are setting the following parameters to establish the connection to a single SAP application server: MESSAGESERVER as false, JCO ASHOST, JCO SYSNR, JCO CLIENT, JCO LANG, USER and PASSWORD with the appropriate values. 

When saving & testing the connection we get the following error, with no further detail: "Error While Test connection: Connection Failed"

The logs, visible in the file attached, give no further indication of the error that might be happening.

Is there any parameter that we might be missing? 

10 REPLIES 10

rushikeshvartak
All-Star
All-Star

Please add below fields

  • MESSAGESERVER
  • JCO_ASHOST
  • JCO_SYSNR
  • JCO_USER
  • PASSWORD
  • JCO_LANG
  • TABLES
  • SYSTEMNAME
  • CREATEACCOUNTJSON
  • PROV_JCO_ASHOST
  • PROV_JCO_SYSNR
  • PROV_JCO_CLIENT
  • PROV_JCO_USER
  • PROV_PASSWORD
  • PROV_JCO_LANG
  • PROV_JCO_R3NAME
  • PROV_JCO_MSHOST
  • PROV_JCO_MSSERV
  • PROV_CUA_ENABLED

https://saviynt.freshdesk.com/support/solutions/articles/43000539903-sap-integration-guide 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Hello,

Although we are not planning on doing any type of provisioning in SAP, I've updated the mentioned attributes according to the examples and descriptions provided in the documentation.

The connection test still fails and no explanation for the error is provided. Logs are attached.

Is there any other configuration that is required for a SAP connection? Or any known reason as to why the connector might be failing without providing any logs of the error? 

Are there other logs somewhere else which might provide more information regarding the connection error?

Thank you

Is this first time you created SAP connection in environment ? check saplib jar exist or try restarting server


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Hi,

It is indeed the first time we are creating this type of connection. We are implementing Saviynt on-premises.

When we first tested the connection, it was failing with the following errors: "Error getting the version of the native layer: java.lang.UnsatisfiedLinkError: no sapjco3 in java.library.path" and "Could not initialize class com.sap.conn.jco.JCO.

When checking the Application server, the file sapjco3.jar was in "/opt/tomcat/apache-tomcat-8.5.29/webapps/ECM/WEB-INF/lib" and in "/opt/java/jdk1.8.0_162/lib". However, some support files, such as libsapjco3.so, were only present in "/opt/java/jdk1.8.0_162/lib". We added the following line to the catalina.sh file: JAVA_OPTS="$JAVA_OPTS -Djava.library.path=/opt/java/jdk1.8.0_162/lib".
After restarting the service, the JCO related errors appeared to be solved but the connection was still failing when tested.

Could this be causing the issue? Could you provide some more information on which files should be where for the saplib jar to function properly? 

Thank you!

It will be great if you share screenshot of connection. seems some parameter is placed in wrong location


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Hi, 

Please find attached the connection details.

Thank you!

what is SAP version?

try language as EN or E

SNC should be = FALSE

TERMINATED_USER_ACTION = ENDDATE

PROV_JCO_LANG = EN / E


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Hi, 

Tried those attributes but nothing changed in the errors.

I believe the SAP version is SAP ERP – ECC 6.0 EHP7.

Thank you!

Manu269
All-Star
All-Star

Hello,

Please check following pre requisite for setting up SAP Connection : 

1. The SAP connector uses SAP Java Connector (JCo) to integrate with the SAP ABAP application. So cross check with Saviynt Professional services saplib jar is available.

2. To establish a secure connection between SSM and SAP applications, enable SNC protection for the integration.

3. Match the name of the SAP endpoint defined in EIC with the logical system name defined in SAP CUA, if you are using a CUA connection.

4. Open firewalls between SSM and the SAP application server.

5. Create a Saviynt System ID in SAP and grant access to the BAPI function modules

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

r-m
New Contributor
New Contributor

Hi,

We are not using CUA or SNC but points 4 and 5 have been ensured.

As for point 1 we are trying to confirm with Saviynt if the changes we made, explained in the previous post, are correct but as stated the JCO errors are no longer appearing.

Thank you!