Press "Enter" to skip to content

WHINT MessageMissing Alert for SAP Process Orchestration

4

Functionality

How can we make sure if a message was processed at all with SAP Process Orchestration? Today, no alert means no error.
But what if the sender system did not place the file or send the message? You will find out, when the business will ask for missing data…
WHINT MessageMissing Alert is a solution that runs pro-actively as a job on your system (e.g. every hour during business hours or every month on the first) and checks in the message (performance) monitor if the interface ran or not. In case no message was found, an e-mail will be sent to a receiver.

WHINT MessageMissing Alert (SAP PI/PO)

Prerequisites

  • Works with SAP NetWeaver Process Orchestration (PI single-stack) version 7.3 EHP1 and higher (including 7.50)
    • If you read from more than one Adapter Engine and you enforce SSL, you need to apply SP15 for 7.31 / SP10 for 7.40
  • Activate the performance monitoring in NWA
    • Configuration > Infrastructure > Java System Properties
    • Services > XPI Service: AF Core
    • Properties > profile.performance.runtime = true
    • Configure the interval to keep the last 31 days of the message processing by executing the following URL on your Process Orchestration system: http(s)://host:port/mdt/performancedataqueryservlet?PeriodConfig=DAILY=31
  • Import the TPZ file provided by Whitepaper InterfaceDesign into the ESR
  • Deploy the SCA of WHINT MessageTrigger Job
  • Create a technical user according to our guideline
  • Determine the parameters Authorization and URL:
    • The URL is determined by calling http(s)://<host>:<port>/mdt/performancedataqueryservlet from your browser. It provides you with the component, so you can set the URL like this: http(s)://<host>:<port>/mdt/performancedataqueryservlet?component=<component>.
    • The Authorization is encoded from username and password. You can use any tool (e.g. Postman or https://www.blitter.se/utils/basic-authentication-header-generator/) to convert username & password into the Base64-Encoded representation (Basic <base64string>).

Usage

  • Schedule the job from NWA -> Operations -> Jobs -> Java Scheduler
  • Add Task with Job name MessageTriggerJob
  • The solution is using WHINT MessageTrigger Job which can generically send an XML message to the Process Orchestration runtime.MMA1
  •  Parameters:
    • ScenarioID: WHINT_MMA (actually this value can have any value)
    • ScenarioSender: WHINT_IFM (this value has to match the IntegratedConfiguration/iFlow configuration)
    • ReceiverService: MMA (this value has to match the IntegratedConfiguration/iFlow configuration and is optional)
    • ParamNN: Interface=<the interface name of the message you look for. “*” is the wildcard.>
    • ParamNN: InterfaceNS=<the interface namespace of the message you look for. “*” is the wildcard.>
    • ParamNN: SenderComponent=<the sender system of the message you look for. “*” is the wildcard.>
    • ParamNN: SenderParty=<the sender party of the message you look for. This parameter is optional.>
    • ParamNN: ReceiverComponent=<the receiver system of the message you look for. “*” is the wildcard.>
    • ParamNN: ReceiverParty=<the receiver party of the message you look for. This parameter is optional.>
    • ParamNN: Period=<DAY/HOUR/15MIN>
    • ParamNN: Frequency=<e.g. the amount of hours within the message was processed>. Possible values / Unit:
      • DAY: 1..31
      • HOUR: 1..24
      • 15MIN: 1..4
    • ParamNN: EmailRecipient=<E-Mail Address or list: receiver1@company.com;receiver2@company.com>
    • ParamNN: Action=<enter a text to inform the receiver what to do or STOP or RESTART. This parameter is optional>
    • ParamNN: Min=<a number with a minimum of messages expected, 1 is the default. This parameter is optional>
    • ParamNN: Max=<a number with a maximum of messages expected>
  • The sequence of the parameters is not important.
  • The scheduling should be done according to your business needs (hourly, Mon-Fri between 8:00 and 18:00)
MMA2

Example

Finance data for reconciliation from a payment service provider shall be sent monthly from an SFTP server and posted into SAP accounting. The solution makes sure that the interface is running every month at least once or at a given day.

Another example is that the warehouse interface shall be active during business hours. Stock movement messages should be sent at least once every 30 minutes from SAP ERP to the AS/400 warehouse system. An immediate alert is sent out if no messaging takes place.


Print Friendly, PDF & Email