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.

 View Only
Back to discussions
Expand all | Collapse all

violation de contrainte unique (PRT.PRTPROCLOCK_PK)

  • 1.  violation de contrainte unique (PRT.PRTPROCLOCK_PK)

    Posted Thu July 17, 2014 12:30 PM

    **** SOLVED - see last entry ****

    in some Integration Server server.log the following message is written:

    java.sql.SQLIntegrityConstraintViolationException: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-00001: violation de contrainte unique (PRT.PRTPROCLOCK_PK)

    PRT.PRTPROCLOCK_PK indicates a problem with a primary key. But this table is not used on purpose.

    • The application, does not include a PRT process, at all.

    Is there a valid reason - why this table is used?


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


  • 2.  RE: violation de contrainte unique (PRT.PRTPROCLOCK_PK)

    Posted Thu July 17, 2014 02:06 PM

    Can you share the complete error message?


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


  • 3.  RE: violation de contrainte unique (PRT.PRTPROCLOCK_PK)

    Posted Thu July 17, 2014 02:13 PM

    Can you share the complete error message? webMethods version?

    Check if WmPRT package is enabled on IS admin page.


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


  • 4.  RE: violation de contrainte unique (PRT.PRTPROCLOCK_PK)

    Posted Fri August 08, 2014 10:41 AM

    Hello Mahesh,

    thank you for offering your help. I did never saw a full log.

    But the intention is, not to use the WmPRT package. We found that for some reason the “Storage Cleaner” has been set to enabled. After the “Cleanup Service Interval” was set to 0 (Reload WmPRT), the problem did no longer occur.

    Regards, Jörg


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


Related Content