Occasional checksheets miss triggering from properly formatted Solution Packages


 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 Assetwise Interop connection to SAP has noted that occasionally an anticipated checksheet is not being triggered in APM despite the Solution Package having been successfully Received and properly formatted in APM. Review of the complete Solution Package contents shows no issues to prevent it from triggering or any data that would lead to an unanticipated error.

Solution

This was reported as a bug, ADO #991274.

Analysis of the enhanced error logs, at debug level, showed that what was happening is that on some triggerings the transaction was waiting for a lock which wasn't being released in time and this was causing the that PM/Solution Package to fail in triggering a checksheet and rolling back. A second triggering of the Solution Packages should have picked up any failed triggerings of the Solution Package and tried them again. This wasn't happening because there was no identification on the Solution Packages to let the scheduled action know that that solution package needed to be retriggered.

To address these issues we've made 2 changes. Firstly, when a Solution Package is attempted to be triggered and fails causing it to rolls back, the Solution Package will now be marked as needing to be retried. This should ensure that the next triggering catches any missed triggers. The second change is that APM will rerun the triggering action several additional times once the first pass finishes. This will ensure that the triggering happens quickly instead of waiting for the next scheduled trigger.

These changes have been made in release 7.23. In the interim, the workaround is to manually generate checksheets for those missed Solution Packages.