In this article
Overview
You can use this account type to connect SAP Snaps with data sources that use the SAP Load Balanced JCo account. The SAP Load Balanced JCo Account is used to connect to a message server (MSHOST - Message Server Host). Learn more about SAP Configuration.
Prerequisites
None
Known Issue
In version 4.28 (main14627), the SAP Snap Pack's bundled JCo library was upgraded to 3.1.4. Prior to that, version 3.0.6 was used.
In version 3.0.21 of SAP:
The default login behavior of the JCo library changed.
The default value of property
jco.client.snc_ssowas changed from 0 to 1 (enabled).
The above changes will impact your pipelines if you use a username/password for RFC login. Login would work with the SAP Snap Pack versions before 4.28 but will fail with versions 4.28 or later.
The following workarounds can help mitigate the issues:
Add the
jco.client.snc_ssoJCo property with a value of0(disabled). If the account still fails with a "Name or password is incorrect (repeat logon)" error, even after adding this property, then reach out to the SAP team to enable the option "Permit Password Logon SAP GUI" for that specific user.Select the Permit Password Logon for SAP GUI (User-Specific) checkbox.
The permit password option is effective only if the profile parameter snc/accept_insecure_gui is set to U. (Unsecure login is permitted for specific users).
Account Settings
Asterisk (*): Indicates a mandatory field.
Suggestion icon (
): Indicates a list that is dynamically populated based on the configuration.Expression icon (
): Indicates whether the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.Add icon (
): Indicates that you can add fields in the fieldset.Remove icon (
): Indicates that you can remove fields from the fieldset
Field Name | Field Type | Description | |
Label* Default Value: None | String | Specify a unique and meaningful label for the account instance | |
Username* Default Value: N/A | String | Specify the SAP username for the account. For SAP SNC authentication, Username is not required for authentication through SAP SNC. | |
Password Default Value: N/A | String | Specify a password for the username. For SAP SNC authentication, Password is not required for authentication through SAP SNC. | |
Language* Default Value: N/A | String | Specify the SAP language code. | |
Client* Default Value: N/A | String | Specify the SAP client to use corresponding to jco.client. | |
Message server* Default Value: N/A | String | Specify the SAP message server address corresponding to jco.client.mshost. | |
System ID* Default Value: N/A | String | Specify the SAP system ID of the SAP system corresponding to the jco.client.r3name. | |
Logon group Default Value: N/A | String | Specify the SAP logon group of the load balanced connections which is identifying a set of SAP application servers corresponding to jco.client.group. | |
Peak limit* Default Value: N/A | Integer | Specify the maximum number of active connections that you can create simultaneously for a destination. We recommend you to use a value less than 100 as too many connections may impact the JCC performance. | |
Connection pool capacity* Default Value: N/A | Integer | Specify the maximum number of idle connections to be kept open by the destination. No connection pooling takes place when the value is 0. | |
Router string
| String | Specify the SAP Router string required for making connections to systems that are behind the SAP Router. An SAP router string contains a chain of SAP routers with their port numbers and has the form For more information on router strings, see Router Strings in SAP Help. | |
Enable trace Default Value: Deselected | Checkbox | Activates the JCo traces to get more information that can help analyze the connection-related errors. | |
Reload Metadata on Validate Default Value: Deselected | Checkbox | Select this checkbox to clear the JCo Metadata cache on the Snaplex node before validating the account. | |
Advanced JCo properties | This field set enables you to specify JCo parameters and respective values for SAP Secure Network Communications (SNC) authentication. Only one JCo parameter can be specified in each row. For SAP SNC authentication, leave the Username and Password fields blank while passing their values in the form of JCo properties, as part of SAP SNC authentication. | ||
Property name Default value: None | String/Expression/Suggestion | Specify the name of the JCo parameter to be passed for SAP SNC authentication. Alternatively, select the parameter from the Suggestions drop-down list. | |
Property value Default value: None | Integer/Expression | Specify the value for the JCo parameter needed for SAP SNC authentication. If you have the JCo parameters defined at a Pipeline-level, pass the Pipeline parameter names as expressions. | |
Troubleshooting
Error Reason Resolution The rounding behavior in JCo 3.1.4 allowed processing " Modify the parameter value by rounding or truncating to ensure it fits into the target BCD field before passing it to SAP. Pipeline failed to prepare. Dependent native library not found or could not be resolved. Could not initialize the account <account-name>. Copy the updated native library: For Linux, copy the updated native library For Windows, copy the updated native library Restart all the nodes in the Snaplex. Could not initialize account. Native library Ensure that the required native library is installed on each node of the Snaplex. Caused by: This error might result from using pooling parameters with values that are too low. If you encounter the JCo error, increase the pooling parameters (Peak limit, Connection pool capacity). ZINVENTORY field: ZINV_AMT type: BCD value: 1035.1532177250149, error_detail: Cannot convert value '1035.1532177250149' from type java.math.BigDecimal to type BCD field ZINV_AMT in record ZINVENTORY"}Cannot convert value '1035.1532177250149' from type java.math.BigDecimal to type BCD field ZINV_AMT in record ZINVENTORYinvalid" values by reducing the precision of the value at the back end. However, with JCo 3.1.9, this rounding of the values is not allowed and the value cannot be stored in the BCD field.SnapCcException: Not starting pipeline as pipeline has prepare error. "{57df90cf-a994-43ab-8caa-91b24d3e2300libsapjco3.so file to the /opt/snaplogic/ldlib folder on every node in the Snaplex.sapjco3.dllfile to the C:\opt\Snaplogic\ldlib folder on every node in the Snaplex.
Note: For Snaplexes with multiple nodes, make sure to install the library on every node.[com-snaplogic-snaps-sap-jcoaccount_2-438rc27664]:sapjco3 is an older version. The library found/opt/snaplogic/ldlib/libsapjco3.so has version "753.811", but the required version is at least 753.1324.** com.sap.conn.jco.JCoException: (180) JCO_ERROR_DESTINATION_DATA_INVALID: Destination <sap.domain.com> null was changed. Please refresh the destination instance using the JCoDestinationManager.