IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

Invalid DB-Trigger WMPRCSSSSC_RAIU after Migration from 9.5 SP1 to 9.12

  • 1.  Invalid DB-Trigger WMPRCSSSSC_RAIU after Migration from 9.5 SP1 to 9.12

    Posted Thu February 21, 2019 12:06 PM

    Hi,

    I just found this invalid trigger (WMPRCSSSSC_RAIU) in a migrated audit database schema.
    Migration was from 9.5 SP1 to 9.12.

    Might it be that this trigger has been overseen during renaming the process audit tables in 9.6?
    When comparing with a databases schema which was directly created for 9.12 usage, there is no such trigger.
    Looks like this trigger has been replaced by trigger PRA_CUSTOM_PROCESS1.

    For the moment I have disabled this trigger to prevent it from logging error messages in the server.log.

    Is it save to delete this trigger in the database?

    Regards,
    Holger


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods-Upgrade


  • 2.  RE: Invalid DB-Trigger WMPRCSSSSC_RAIU after Migration from 9.5 SP1 to 9.12

    Posted Tue February 26, 2019 04:44 PM

    better open a ticket with SAG :slight_smile:


    #webMethods-Upgrade
    #webMethods-General
    #webMethods
    #Integration-Server-and-ESB


  • 3.  RE: Invalid DB-Trigger WMPRCSSSSC_RAIU after Migration from 9.5 SP1 to 9.12

    Posted Wed February 27, 2019 12:38 PM

    Hi Tong,

    sure, I will do.

    Just wanted to know if others have already noticed the same during their migrations.

    As pointed out I assume an issue in the migration script where this trigger has been overseen during the renaming and redefinition of the tables in wM 9.6.

    Regards,
    Holger


    #Integration-Server-and-ESB
    #webMethods-Upgrade
    #webMethods-General
    #webMethods


Related Content