SAP Integration

Systems, Applications, and Products (SAP) for data processing is an industry leading enterprise software solution that is widely used in product and process oriented enterprises for finance, operations, HR, and many other aspects of a business.

ESB Micro Integrator leverages the best of both worlds by providing the integration layer that can be used to integrate an existing SAP R/3-based solution of an enterprise with other data/business oriented systems so that you can mix-and-match requirements with minimal effort. As a result, enterprises can keep parts of their systems independent of SAP and extensible for many other systems, solutions, and middleware.

The ESB SAP adapter is shipped with the Micro Integrator and is implemented as a transport. The ESB SAP adapter supports both IDoc and BAPI protocols. It uses the SAP JCO library as the underlying framework to communicate with SAP. This section describes how to set up the Micro Integrator in a SAP environment and install the following: SAP JCo middleware library, SAP Intermediate Document (IDoc), and Business Application Programming Interface (BAPI) adapters.

Installing the SAP Adapter

Follow the instructions below to install and set up the SAP adapter.

  1. Download ESB Micro Integrator.
  2. Download the sapidoc3.jar and sapjco3.jar middleware libraries from the SAP support portal and copy those libraries to the <MI_HOME>/lib directory.

    Info

    You need to have SAP login credentials to access the SAP support portal.

  3. Download the native SAP JCo library and copy it to the system path. You need to select the system path applicable to your operating system as described below.

    OS System Path
    Linux 32-bit Copy the Linux native SAP jcolibrary libsapjco3.so to <JDK_HOME>/jre/lib/i386/server .
    Linux 64-bit Copy the Linux native SAP jcolibrary libsapjco3.so to <JDK_HOME>/jre/lib/amd64 .
    Windows Copy the Windows native SAP jcolibrary sapjco3.dll to <WINDOWS_HOME>/system32 .
  4. Create a directory named sap within <MI_HOME>/conf/ directory and provide access rights to read the properties files you will save in it later.

  5. Copy the following SAP endpoint properties files to the <MI_HOME>/conf/sap/ directory. You need to have two properties files, one at the server-end and the other at the client-end to communicate with an external SAP endpoint using IDoc or BAPI.

    • *.dest : This is where we store SAP endpoint parameters when the Micro Integrator is configured as a client to an external SAP endpoint.
    • *.server : This is where we store SAP endpoint parameters when the Micro Integrator is configured as a server to an external SAP endpoint.

    For details on creating the properties files and defining the relevant properties, see Setting up the Client Configuration File and Setting up the Server Configuration File.

  6. Start the Micro Integrator using the -Djava.library.path switch to specify the location of your SAP jco library.
    For example, you can execute the following command to start the Micro Integrator from the MI_HOME/bin directory:

    ./micro-integrator.sh -Djava.library.path=/usr/lib/jvm/jre1.7.0/lib/i386/server/

Setting up the Client Configuration file

To setup the Micro Integrator as a client to a SAP system you need to create the *.dest properties file and define the relevant properties. The following table lists the properties and the description of each property that should be specified in the *.dest properties file.

Property Description
jco.client.client Client logon
jco.client.user User logon
jco.client.alias_user Alias user name
jco.client.passwd Logon password
jco.client.lang Logon language
jco.client.sysnr R/3 system number
jco.client.ashost R/3 application server
jco.client.mshost R/3 message server
jco.client.gwhost Gateway host
jco.client.gwserv Gateway service
jco.client.r3name R/3 name
jco.client.group Group of application servers
jco.client.tpname Program ID of external server program
jco.client.tphost Host of external server program
jco.client.type Type of remote host (3=R/3, E=External)
jco.client.codepage Initial code page for logon
jco.client.use_sapgui Use remote SAP graphical user interface
jco.client.mysapsso2 Use the specified SAP cookie version 2 as the logon ticket
jco.client.grt_data Additional data for GUI
jco.client.use_guihost Host to which the remote GUI is redirected
jco.client.use_guiserv Service to which the remote GUI is redirected
jco.client.use_guiprogid Progid of the server that starts the remote GUI
jco.client.snc_partnername SNC partner name (for example, CN=B20, O=SAP-AG, C=DE\) snc_mode
jco.client.snc_mode SNC mode (0 or 1)
jco.client.snc_qop SNC level of security (1-9)
jco.client.snc_myname SNC name; overrides default SNC partner
jco.client.snc_lib Path to the library
jco.client.Dest R/2 destination
jco.client.saplogon_id SAPLOGON string on 32-bit Windows
jco.client.extiddata Data for external application (PAS)
jco.client.extidtype Type of external authentication (PAS)
jco.client.x509cert Use the specified X509-certificate as the logon ticket
jco.client.msserv R/3 port number of message server
jco.client.profile_name Profile name used for shared memory communication
jco.client.idle_timeout Idle timeout for the connection
jco.client.ice Ignore RFC library character conversion errors (1 or 0)
jco.client.logon Enable or disable logon check at open time (1 or 0)
jco.client.trace Enable or disable RFC trace (1 or 0)
jco.client.abap_debug Enable ABAP debugging (1 or 0)
jco.client.getsso2 Get or do not get a SSO ticket after logon (1 or 0)
jco.client.toupper Enable or disable uppercase character conversions for logon

Info

You can obtain the values for these properties from your SAP system administrator.

The *.dest properties file should be named <SAP-GWHOST>.dest. For example, if the name of your SAP gateway is SAPSYS, the name of the file should be SAPSYS.dest.

Following is a sample configuration for the *.dest properties file:

jco.client.client=800
jco.client.user=wso2_user
jco.client.passwd=wso2pass14
jco.client.lang=en
jco.client.ashost=/H/217.116.29.154/S/3299/H/10.100.5.120/S/3200
jco.client.gwserv=3300
jco.client.sysnr=00
jco.client.idle_timeout=300
jco.client.logon=0
jco.client.msserv=3600
jco.client.trace=0
jco.client.getsso2=0
jco.client.r3name=CPT

Setting up the Server Configuration File

To setup the Micro Integrator as an IDoc server, you need to create the *.server properties file and define the relevant properties. The following table lists the properties and the description of each property that should be specified in the *.server properties file.

Property Description
jco.server.gwhost Gateway host
jco.server.gwserv Gateway service
jco.server.progid Program ID of the server
jco.server.trace You can enable or disable the RFC trace
jco.server.repository_destination Name of the .dest file. For example, if the .dest file is SAPSYS01.dest , set this to SAPSYS01 .
jco.server.params Arbitrary parameters for RFC library
jco.server.snc_myname SNC name
jco.server.snc_qop SNC level of security (1-9)
jco.server.snc_lib Path to the SNC library
jco.server.profile_name Name of the profile file used during start-up
jco.server.unicode Determines whether or not you connect in unicodemode (1=true, 0=false)
jco.server.max_startup_delay Maximum server start-up delay time in seconds
jco.server.connection_count Number of SAP to Micro Integrator connections
jco.server.name Name of the server configuration. This needs to be the same name provided in the SAP configuration.

Info

You can obtain the values for these properties from your SAP system administrator.

This file should be named <SAP-GWHOST>.server. For example, if the name of your SAP gateway is SAPSYS , the name of the file should be SAPSYS.server.

Following is a sample configuration for the *.server properties file:

jco.server.gwhost=/H/217.116.29.154/S/3299/H/10.100.5.120/S/3200
jco.server.gwserv=3300
jco.server.progid=IGS.CPT
jco.server.repository_destination=IGS.CPT
jco.server.name=IGS.CPT
jco.server.unicode=1

Configuring ESB SAP Adapter

Go to the required tab for detailed steps based on how you need to configure ESB SAP Adapter.

ESB SAP adapter can be used with IDoc, which is a synchronous interface used when exchanging data with the SAP system. ESB Micro Integrator can be configured for Sending IDocs or Receiving IDocs when using the SAP adapter.

Sending IDocs

Follow the instructions below to configure the Micro Integrator as an IDoc client using the SAP adapter.

  1. Uncomment the following line in MI_HOME/conf/deployment.toml file to enable the IDoc transport sender.

    [transport.sap]
    sender.idoc.enable=true
    sender.idoc.class="org.wso2.carbon.transports.sap.SAPTransportSender"
  2. Create IDocSender proxy service with the following configuration:

    <proxy xmlns="http://ws.apache.org/ns/synapse" 
       name="IDocSender"
       transports="http" 
       startOnLoad="true" 
       trace="enable" 
       statistics="enable">
    <target>
        <inSequence>
            <log level="full"/>
            <property name="OUT_ONLY" value="true"/>
            <send>
                <endpoint name="sapidocendpoint">
                    <address uri="idoc:/SAPSYS"/>
                </endpoint>
            </send>
        </inSequence>
        <outSequence/>
    </target>
    <parameter name="serviceType">proxy</parameter>
    <description/>
    </proxy>

    Info

    • If you set the property shown below (use the Property mediator before the Send mediator in the above sequence), any business-level error messages that are sent back from the SAP endpoint will be successfully passed through the out flow sequence. Without this property, the business-level errors from SAP can get detected as faulty messages and passed to the Fault sequence.

      <property name="sap.escape.error.handling" scope="axis2" value="true"/>

    • The SAP endpoint client properties file SAPSYS.dest should be in Mi_HOME/conf/sap folder .

  3. Start the Micro Integrator using the -Djava.library.path switch to specify the location of your SAP jco library.
    For example, you can execute the following command to start the Micro Integrator from the MI_HOME/bin directory:

    ./micro-integrator.sh -Djava.library.path=/usr/lib/jvm/jre1.7.0/lib/i386/server/
    You can now send IDocs using the configured ESB SAP adapter.

Receiving IDocs

Follow the instructions below to configure the Micro Integrator as an IDoc server using the SAP adapter.

  1. Uncomment the following line in the MI_HOME/conf/deployment.toml file to enable IDoc transport receiver.

    [transport.sap]
    listener.idoc.enable=true
    listener.idoc.class="org.wso2.carbon.transports.sap.SAPTransportListener"
  2. Ensure the server configuration file SAPSYS.server is available in MI_HOME/conf/sap folder.

  3. Create the IDocReceiver proxy service with the following configuration:

    <proxy xmlns="http://ws.apache.org/ns/synapse" 
           name="IDocReceiver"
           transports="idoc" 
           statistics="enable" 
           trace="enable" 
           startOnLoad="true">
       <target>
         <inSequence>
             <log level="full"/>
             <drop/>
        </inSequence>
        <outSequence/>
      </target>
      <parameter name="transport.sap.enableTIDHandler">enabled</parameter>
      <parameter name="transport.sap.serverName">SAPSYS</parameter>
      <description/>
    </proxy>

    Info

    • The SAP endpoint server properties file SAPSYS.server should be in the MI_HOME/conf/sap folder.
    • Additional proxy level listener parameters that can be defined in the proxy configuration are listed in Proxy Service Listener Parameters.
  4. Start the Micro Integrator using the -Djava.library.path switch to specify the location of your SAP jco library.
    For example, you can execute the following command to start the Micro Integrator from the MI_HOME/bin directory:

    ./micro-integrator.sh -Djava.library.path=/usr/lib/jvm/jre1.7.0/lib/i386/server/

    ESB SAP adapter is now ready to receive IDoc messages.

ESB SAP adapter can be used with BAPI, which is a synchronous interface used when exchanging data with the SAP system. The Micro Integrator can be configured for Sending BAPIs or Receiving BAPIs when using the SAP adapter.

Sending BAPIs

Follow the instructions below to configure the Micro Integrator as a BAPI client using the SAP adapter.

  1. Uncomment the following line in MI_HOME/conf/deployment.toml file to enable the BAPI transport sender.

    [transport.sap]
    sender.bapi.enable=true
    sender.bapi.class="org.wso2.carbon.transports.sap.SAPTransportSender"
  2. Create the BAPISender proxy service with the following configuration:

    <proxy xmlns="http://ws.apache.org/ns/synapse" 
           name="BAPISender" 
           transports="https,http" 
           startOnLoad="true" 
           trace="disable">
        <target>
            <inSequence>
                <send>
                    <endpoint name="sap_bapi_endpoint">
                        <address uri="bapi:/SAPSYS"/>
                    </endpoint>
                </send>
            </inSequence>
            <outSequence>
                <log level="full"/>
                <send/>
            </outSequence>
        </target>
    </proxy>

    Info

    • If you set the property shown below (use the Property mediator before the Send mediator in the above sequence), any business-level error messages that are sent back from the SAP endpoint will be successfully passed through the out flow sequence. Without this property, the business-level errors from SAP can get detected as faulty messages and passed to the Fault sequence.

      <property name="sap.escape.error.handling" scope="axis2" value="true"/>

    • The SAP endpoint client properties file SAPSYS.dest should be in the MI_HOME/conf/sap folder .

  3. Start the Micro Integrator using the -Djava.library.path switch to specify the location of your SAP jco library.

    For example, you can execute the following command to start the Micro Integrator from the MI_HOME/bin directory:

    ./micro-integrator.sh -Djava.library.path=/usr/lib/jvm/jre1.7.0/lib/i386/server/

Receiving BAPIs

Follow the instructions below to configure the Micro Integrator as a BAPI server using the SAP adapter.

  1. Uncomment the following line in the MI_HOME/conf/deployment.toml file to enable BAPI transport receiver.

    [transport.sap]
    listener.bapi.enable=true
    listener.bapi.class="org.wso2.carbon.transports.sap.SAPTransportListener"
  2. Create the BAPIReceiver proxy service with the following configuration:

    <proxy xmlns="http://ws.apache.org/ns/synapse" 
           name="BAPIReceiver"
           transports="bapi" 
           statistics="enable" 
           trace="enable" 
           startOnLoad="true">
       <target>
         <inSequence>
             <log level="full"/>
             <drop/>
        </inSequence>
        <outSequence/>
      </target>
      <parameter name="transport.sap.enableTIDHandler">enabled</parameter>
      <parameter name="transport.sap.serverName">SAPSYS</parameter>
      <description/>
    </proxy>

    Info

    • The SAP endpoint server properties file SAPSYS.server should be in the MI_HOME/conf/sap folder .
    • Additional proxy level listener parameters that can be defined in the proxy configuration are listed in Proxy Service Listener Parameters.
  3. Start the Micro Integrator using the -Djava.library.path switch to specify the location of your SAP jco library.
    For example, you can execute the following command to start the Micro Integrator from the MI_HOME/bin directory:

    ./micro-integrator.sh -Djava.library.path=/usr/lib/jvm/jre1.7.0/lib/i386/server/

Additional configuration parameters

This section describes additional parameters that can be used when configuring ESB SAP adapter.

Proxy service listener parameters

Following are descriptions of the proxy level listener parameters that can be defined in a proxy configuration when using the Micro Integrator as a SAP server:

Parameter Description
transport.sap.serverName The name of the server containing the JCO server configuration.
transport.sap. enableErrorListener Set this to enable the default error listener. If this is used together with the transport.sap. customErrorListener parameter, the custom error listener will be used.
transport.sap. enableTIDHandler Set this to enable the transaction handler to handle transactions that are received from a SAP system. Transactional applications must provide a custom implementation using the transport.sap. customTIDHandler parameter.
transport.sap. customTIDHandler The fully qualified class name for the custom TID handler implementing JCoServerTIDHandler .
transport.sap.connections The number of registered connections managed by the server instance. The default value is 1 and the maximum value is 100 .
transport.sap. customErrorListener The fully qualified class name for the custom error listener implementing JCoServerErrorListener .
transport.sap. customExceptionListener The fully qualified class name for the custom exception listener implementing JCoServerExceptionListener .

Troubleshooting

Given below are general troubleshooting guidelines.

How to handle the Server unknown error

An example of this error message is as follows:

[2010-10-25 19:53:00,405] ERROR - DefaultErrorListener Exception occured on :
JCOSERVER01 and connection : null
com.sap.conn.jco.JCoException: (129) JCO_ERROR_SERVER_STARTUP: Server startup
failed at Mon Oct 25 19:53:00 IST 2010.
This is caused by either a) erroneous server settings, b) the backend system has been shutdown,
c) network problems. Will try next startup in 1 seconds.
Could not start server: Connect to SAP gateway failed
Connect parameters: TPNAME=JCOSERVER01 GWHOST=cynthia GWSERV=sapgw00
ERROR service 'sapgw00' unknown
TIME Mon Oct 25 19:53:00 2010
RELEASE 720
COMPONENT NI (network interface)
VERSION 40
RC -3
MODULE nixxsl.cpp
LINE 184
DETAIL NiSrvLGetServNo: service name cached as unknown
COUNTER 2
at com.sap.conn.jco.rt.DefaultServer.openConnection(DefaultServer.java:1168)
at com.sap.conn.jco.rt.DefaultServer.openConnections(DefaultServer.java:1057)
at com.sap.conn.jco.rt.DefaultServer.adjustConnectionCount(DefaultServer.java:1004)
at
com.sap.conn.jco.rt.DefaultServerManager$DispatcherWorker.run(DefaultServerManager.java:
299)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.sap.conn.jco.JCoException: (129) JCO_ERROR_SERVER_STARTUP: Could
not start server: Connect to SAP gateway failed
Connect parameters: TPNAME=JCOSERVER01 GWHOST=cynthia GWSERV=sapgw00
ERROR service 'sapgw00' unknown
TIME Mon Oct 25 19:53:00 2010
RELEASE 720
COMPONENT NI (network interface)
VERSION 40
RC -3
MODULE nixxsl.cpp
LINE 184
DETAIL NiSrvLGetServNo: service name cached as unknown
COUNTER 2
at
com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcServer.accept(MiddlewareJavaRfc.java:2135)
at com.sap.conn.jco.rt.ServerConnection.accept(ServerConnection.java:380)
at com.sap.conn.jco.rt.DefaultServer.openConnection(DefaultServer.java:1149)
© 2012 WSO2
.. 4 more
Caused by: RfcException: [null]
message: Connect to SAP gateway failed
Connect parameters: TPNAME=JCOSERVER01 GWHOST=cynthia GWSERV=sapgw00
ERROR service 'sapgw00' unknown
TIME Mon Oct 25 19:53:00 2010
RELEASE 720
COMPONENT NI (network interface)
VERSION 40
RC -3
MODULE nixxsl.cpp
LINE 184
DETAIL NiSrvLGetServNo: service name cached as unknown
COUNTER 2
Return code: RFC_FAILURE(1)
error group: 102
key: RFC_ERROR_COMMUNICATION
at com.sap.conn.rfc.engine.RfcIoControl.error_end(RfcIoControl.java:255)
at com.sap.conn.rfc.engine.RfcIoControl.ab_rfcaccept(RfcIoControl.java:43)
at com.sap.conn.rfc.api.RfcApi.RfcAccept(RfcApi.java:41)
at
com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcServer.accept(MiddlewareJavaRfc.java:2121)
... 6 more

The solution to overcome this is to add your SAP server names to the /etc/services file with the relevant ports. For example, the following lines can be added if we consider the example error given above.

sapgw00 3300/tcp
sapgw01 3301/tcp

How to handle connection to message server host failed error

An example of this error message is as follows:

Connection parameters: TYPE=B DEST=SAPSYS01 MSHOST=SAPSYS01 MSSERV=3600 R3NAME=ERD GROUP=PUBLIC PCS=1
ERROR Group PUBLIC not found
TIME Fri Jan 24 15:48:53 2014

This indicates that that the username (i.e. wso2-user) used in the above configuration is not assigned to the 'public' user group. The solution to overcome this is to add wso2-user to the user group named public in your SAP system. If such a group does not exist, a user group named 'public' needs be created and the above user needs to be added to that group.

Top