SAP Connection

[r-m]

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? 

[rushikeshvartak]

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 

[r-m]

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

[rushikeshvartak]

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

[r-m]

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!

[rushikeshvartak]

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

[r-m]

Hi, 

Please find attached the connection details.

Thank you!

[rushikeshvartak]

what is SAP version?

try language as EN or E

SNC should be = FALSE

TERMINATED_USER_ACTION = ENDDATE

PROV_JCO_LANG = EN / E

[r-m]

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]

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

[r-m]

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!