IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > SAP Software > Troubleshooting and support
Avoiding stale connection problems in the SAP adapter
Connection related problems can be resolved in WebSphere Adapter for SAP Software using two new properties, connectionRetryLimit and connectionRetryInterval defined in the Managed connection factory of the SAP adapter.
The two properties are used to provide two features during outbound communication of the adapter and are optional.
In the service generation and deployment configuration window explained in the Setting deployment properties and generating the service topic for the appropriate interface,
Procedure
- Click on the Advanced -> Additional connection configuration
- Set the Maximum number of retries in case of system connection failure to the appropriate positive integer
- if the property value is set to 0, then adapter does not perform any EIS connection validation and executes the outbound operation.
If the EIS connection is invalid, the outbound operation fails. Though the subsequent requests get executed successfully provided the SAP system is functional, the current request fails.
- if the property value is set to greater than 0, then during each request the adapter validates that the EIS connection is active/alive .
- If connection is valid then operation is completed. if connection is invalid, the adapter invalidates the current managed connection so that a new managed connection is created (new physical connection).
- If the connection is created successfully, the outbound operation is completed otherwise a ResourceException error is thrown.
- Set the Time interval between retries if connection fails (milliseconds) field with the appropriate integer to indicate time in milliseconds in between retries. This property is enabled only when the connectionRetryLimit property has a value greater than 0.
Results
The two new features take care of connections which are timed out or become stale after the EIS restarts. Even though this option solves most of connection related problems, the adapter is not guaranteed to work 100% error free for connection problems.
Related reference: