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

integrity constraint violated - parent key not found Error in IS logs

  • 1.  integrity constraint violated - parent key not found Error in IS logs

    Posted Thu March 03, 2016 05:11 AM

    Hi ,

    I have installed the IS freshly on one of the 9.8 server and created DB components as well. I am getting the below error while restarting IS instance. How to get rid of this?

    com.wm.app.tn.err.EXMLException: 0003.4073 Could not set binary object for partner (id=000000000000000000000000). com.wm.app.tn.profile.ProfileStoreException Error encountered adding binary objects to the database. (0) java.sql.SQLIntegrityConstraintViolationException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-02291: integrity constraint (WMTN.FK_PTNRBIN_PTNRID_PTNR) violated - parent key not found java.sql.SQLIntegrityConstraintViolationException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-02291: integrity constraint (WMTN.FK_PTNRBIN_PTNRID_PTNR) violated - parent key not found

    java.sql.SQLIntegrityConstraintViolationException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-02291: integrity constraint (WMTN.FK_PTNRBIN_PTNRID_PTNR) violated - parent key not found


    #B2B-Integration
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: integrity constraint violated - parent key not found Error in IS logs

    Posted Thu March 03, 2016 05:43 AM

    Hi,

    Please check if you have the selected the latest script while running the scripts.

    There will be a parent key PK_PTNR_PTNRID set for this foreign key FK_PTNRBIN_PTNRID_PTNR on PARTNER & table.

    Inshort just cross check if you are running the latest version of the scripts or not.

    Regards,
    Syed Faraz Ahmed


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration


Related Content