B2B Integration

Sterling B2B Integration

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  Reset of the Process ID (WF_ID)

    Posted 01/09/26 02:02 PM

    Hi all,

    Could anyone share the recommended procedure for performing a controlled reset of the Process ID (WF_ID) in Sterling Integrator? We are planning a reset during a maintenance window and want to ensure it's done safely.

    Thanks in advance for your guidance!

    Nisam



    ------------------------------
    Nisam PH
    ------------------------------


  • 2.  RE: Reset of the Process ID (WF_ID)

    Posted 01/12/26 07:30 AM
    Hi Nisam,

    Bring entire system down. And then depending on your DB run the appropriate comman to reset the ID.

    For DB2 I have used:

    alter table MBX_MESSAGE_GUID alter NEXT_MESSAGE_ID RESTART WITH 1
                
    Hope this helps!
    Attila





  • 3.  RE: Reset of the Process ID (WF_ID)

    Posted 02/11/26 01:56 PM

    Thank you for the Help. It worked.



    ------------------------------
    Nisam PH
    ------------------------------

    Original Message


  • 4.  RE: Reset of the Process ID (WF_ID)

    Posted 01/13/26 09:13 AM

    Hi Nisam,

    If your WF_ID has reached its maximum limit (999999999), the following solution might help:

    Scale down your system and request your DB team to execute the queries below:

    TRUNCATE TABLE WF_GUID;

DBCC CHECKIDENT ("WF_GUID", RESEED, 1);



    ------------------------------
    kallagunta mallikarjuna
    ------------------------------



Related Content