B2B Integration

 View Only
  • 1.  Schedule_PurgeService Error

    Posted Wed May 20, 2020 08:15 AM
    Hi all,
    I get the following message in execution purge service, this BP take more than 15 hour to execute and fail, whats happen?


    Purging Started at : Tue May 19 09:01:04 BRT 2020
    This purge cycle exceeded the MAX_PURGE_SERVICE_CYCLE_TIME

    797263 Document on Disk entries added to Purge List:
    /purge_dod_list.txt.20200519

    Table Purges:
    ==============
    FS_INBOUND_HISTY 0
    EB_EVENT 0
    MSGMDNDUP 0
    DOCUMENT_EXTENSION 315118
    WEBX_MINED_DATA 0
    EB_TRX 0
    DOCUMENT 798658
    EDI_COMPLIANCE_RPT 0
    WORKFLOW_DATA 0
    DATA_TABLE 0
    GENERIC_ACK 0
    DOC_EDIT_MSGS 0
    EDI_DOCUMENT_STATE 0
    CORRELATION_SET 3937379
    EB_TRX_STATUS 0
    EB_EVENT_ATTR 0
    SWIFT_ACK_RECON 0
    DOC_EDIT_EXTN 0
    WF_INST_S 244918
    ACH_RETURN_INFO 0
    EB_TRX_SIGN 0
    WORKFLOW_LIFESPAN 0
    SWNET_DISTLIST 0
    DOCUMENT_CLONE 371576
    TRANS_DATA 6399578
    SWNET_MSG_INFO 0
    FS_OUTBOUND_HISTY 0
    MSGMDNCORRELATION 0
    EB_ORD 0
    EB_MESSAGE 0
    EDIINTDOC 0
    SWNET_MSG 0
    EB_DOC_INFO 0
    WORKFLOW_CONTEXT 4491613
    DOCUMENT_LIFESPAN 0

    Error occured in online purging process.
    Online purging process is finished at: Wed May 20 05:01:28 BRT 2020

    ------------------------------
    Douglas Rezende
    ------------------------------

    #SupplyChain
    #B2BIntegration


  • 2.  RE: Schedule_PurgeService Error

    Posted Wed May 20, 2020 03:15 PM
    ​Hi,

    Did you check these links:
    https://www.ibm.com/support/pages/schedulepurgeservice-fails-error-occured-online-purging-process
    https://www.ibm.com/support/pages/purge-cycle-exceeded-maxpurgeservicecycletime

    Could you check your workflow log to see if there are any SQL errors reported?

    Regards,
    Indu

    ------------------------------
    INDUBHARATHI Routhu Lead Consultant
    ------------------------------



  • 3.  RE: Schedule_PurgeService Error

    Posted Thu May 21, 2020 01:12 PM
    Hi,
    In the logs I find a sql error, this very strange, now this purge service is work very well, I'll check this links.


    Regards,
    Douglas Rezende

    ------------------------------
    Douglas Rezende
    ------------------------------



  • 4.  RE: Schedule_PurgeService Error

    Posted Fri May 22, 2020 03:17 PM
    First we need to validate why it ran for 15 hours? Is it common to run more than 5-6 minutes?
    What is the schedule of your purge service?
    Was there any issue with DB?
    Have you fixed your backup process before start of this purge?

    I think this Purge did not error.. all the others erred with lock error.

    -Dhiraj Patil

    ------------------------------
    Dhiraj Patil
    ------------------------------



  • 5.  RE: Schedule_PurgeService Error

    Posted Fri May 22, 2020 04:20 PM
    The purge service is work well, but take 30 minutes to complete
    Schedule_PurgeService   Completed   05/22/2020 3:43:55 PM   05/22/2020 4:10:33 PM 

    every 1 hour is execute purge service
    backup service execute just in daybreak


    I think this happen because this enviromet store more than 400k of the documents in mailbox, and now we start deletion of documents.

    I'll investigate DB

    ------------------------------
    Douglas Rezende
    ------------------------------



  • 6.  RE: Schedule_PurgeService Error

    Posted Mon May 25, 2020 04:03 PM
    Can I suggest u to use the external purge instead?

    external purge (HPP) or High Performance Purge is faster than Schedule_Purge, it uses its own JVM and communicates directly the database.

    ------------------------------
    Alejandro Rodriguez
    ------------------------------



  • 7.  RE: Schedule_PurgeService Error

    Posted Tue May 26, 2020 08:57 AM
    Agree with Alejandro on External Purge. You might have tried that already, and due to high volume got blocked sessions on DB. Some tuning is needed to External purge on high volume systems. In high volume, you need to ignore IBM's suggestion on increasing batch size and tune it by increasing the number of threads and decreasing batch size... Enable debug on external purge and then tune it, the logs are huge so run them for short time.

    -Dhiraj Patil

    ------------------------------
    Dhiraj Patil
    ------------------------------



  • 8.  RE: Schedule_PurgeService Error

    Posted Tue May 26, 2020 10:09 AM
    Yes you're right... When we had a DB using around 85% the Schedule Purge did n't help... It only maintained the DB with the same usage... However with HPP in mabe 4 or 5 weeks we returned at least 75% of DB usage  (without tuning the HPP)

    ------------------------------
    Alejandro Rodriguez
    ------------------------------