Product(s):	APM Implementation and Performance Management
	Version(s):	7
	Environment:	N/A
	Area:	N/A
	Subarea:	N/A

Problem Description

An APM user with SAP Gateway (CMMS Interoperability) would have most checksheets generating based on SAP Maintenance Orders without issue but noticed that occasionally, 2 standard tasks linked to SAP Maintenance Orders would not generate Checksheets. When trying to manually create checksheets from the standard task directly via the tools menu, it was found that the checksheets took several minutes to generate but did generate successfully.

Solution

It was found that the SAP Gateway External Data Provider has a timeout setting. In this case the setting was set to 120s. Each time an SAP Maintenance Order is used to create a checksheet, this external data provider is engaged. In the case of the two standard tasks that occasionally failed to create checksheets via the Scheduled Action (Create checksheets for Maintenance Orders), it was found when generating the checksheets manually that the creation time was taking slightly longer than the timeout time of 120s. This kept the SAP connect open too long and timed out before creating the checksheet was finished causing it to rollback. Because the generation time was so close to 120s, sometimes it could complete successfully but other times if there was a little more load on the action scheduler service it would result in a timeout.

We resolved the issue by changing the timeout to 300s.