B2B Integration

 View Only
  • 1.  Any standard or custom process to find active vs inactive interface in B2Bi

    InnerCircle
    Posted Wed April 21, 2021 12:53 AM
    Edited by Pranjit Biswas Wed April 21, 2021 12:54 AM
    Hi All,

    Hope you all are doing good in this pandemic time.

    In various situation, we keep getting req to list out the active vs inactive interfaces in B2B integrator. But as per my understanding, we either tend to the historical communication session related info (ACT_SESSION) or historical data transfer details to reach our objective though there are caveats to that as there might be partners who send / receive data only on quarterly,half yearly or yearly basis. And our historical log may not cover older data.

    Hence we may end up flagging those partners as inactive causing more issues going forward to reinstate them.

    Can anyone shed some light that they might have followed to fulfill such requirement ?

    ------------------------------
    Pranjit Biswas
    ------------------------------


  • 2.  RE: Any standard or custom process to find active vs inactive interface in B2Bi

    Posted Wed April 21, 2021 02:59 AM
    Hi,

    I believe you are looking for an option to identify  User Logins  are Active / Inactive.

    Keeping the more data ACT_SESSION impacts the performance of the system , we need to maintain the lifespan of visibility data as less as possible.

    If you want to achieve the Active / Inactive userlogins or filetransfer activities then have to go for a custom solution.

    Implement the UserExits available in B2Bi , build the DB design according to your requirement and store the needed info in that custom DB that you designed.

    Thanks,
    RadhaKrishna Gajula.

    ------------------------------
    Radhakrishna Gajula
    ------------------------------



  • 3.  RE: Any standard or custom process to find active vs inactive interface in B2Bi

    InnerCircle
    Posted Fri April 23, 2021 01:15 AM
    Thank you all for the response to my query..

    ------------------------------
    Pranjit Biswas
    ------------------------------



  • 4.  RE: Any standard or custom process to find active vs inactive interface in B2Bi

    Posted Wed April 21, 2021 03:06 AM
    Hi Pranjit,

    Yes, you are correct, to check whether the interface is active/inactive, you can verify ACT-SESSION, workflow_context, audit reports etc. but since we use to keep limited period data in SI, so its difficult. In few customer scenario, I found that they created some custom table and use to keep some reference for latest transaction (& use to clean old data), few customer take the reference from backend applications.

    Regards,
    Shreekant

    ------------------------------
    Shreekant Prasad
    ------------------------------



  • 5.  RE: Any standard or custom process to find active vs inactive interface in B2Bi

    InnerCircle
    Posted Thu April 22, 2021 08:43 AM

    One solution, depending on your configuration.  If your partner logins are tied to a virtual root mailbox, you can use the last modification time on the mailbox to determine activity levels and act accordingly.  If you segregate partner mailboxes from other routing mailboxes, you can adjust the SQL query where clause below as needed.

    SELECT mm.PATH, mm.LAST_MODIFICATION
    FROM MBX_MAILBOX mm
    JOIN MBX_MATCH_MBX mmm on mm.MAILBOX_ID = mmm.MAILBOX_ID
    JOIN MBX_RULE mr on mmm.RULE_ID = mr.RULE_ID
    JOIN MBX_RULE_DESCR mrd on mr.RULE_ID = mrd.RULE_ID and mrd.DESCRIPTION in ('NameOfYourRoutingRule')
    WHERE DATEDIFF( MM, mm.LAST_MODIFICATION, GETDATE() ) > 6
    ORDER BY FORMAT(mm.LAST_MODIFICATION,'YYYYMMDD') desc, mm.PATH

    Highlighted parts above may need to be adjusted for your database type and the name of your Sterling mailbox Routing Rule.  You also need the following property set in customer_overrides.properties and a Sterling restart to enable the last_modification value.

    $SI_HOME/properties/customer_overrides.properties
    mailbox.updateMailboxLastModification=true



    ------------------------------
    Michael Geier
    IT Engineer 3
    Enterprise Holdings, Inc
    St. Louis MO
    ------------------------------