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

  • 1.  Error while creating a document type

    Posted Fri June 05, 2015 07:04 PM

    Hi Team,

    We are trying to create a document type and getting the below error, could you please help.

    9999:wm.tn.portal.doctype:add encountered execution error. Database error while adding type 6lrcbt0a9n212pmd00002ul2: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-02291: integrity constraint (P1WM9TN.FK_BDOCTYPATT_ATTID_BDOCATTDEF) violated - parent key not found . (0) java.sql.SQLIntegrityConstraintViolationException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-02291: integrity constraint (P1WM9TN.FK_BDOCTYPATT_ATTID_BDOCATTDEF) violated - parent key not found

    Thanks,
    Pawan


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


  • 2.  RE: Error while creating a document type

    Posted Sat June 06, 2015 09:55 AM

    Are you still with the error? or solved?


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


  • 3.  RE: Error while creating a document type

    Posted Mon June 08, 2015 05:53 AM

    Hi Error,

    We still have this issue.

    -Pawan


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


  • 4.  RE: Error while creating a document type

    Posted Mon June 08, 2015 06:11 AM

    Sorry Mahesh.

    Wrongly type the name… edit is not working, getting error.


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


  • 5.  RE: Error while creating a document type

    Posted Mon June 08, 2015 06:18 AM

    Hi Error,

    The problem was that the system document type was not all available. The BizDocAttributeDef table should contain all the 8 system document attribute types (refer the TN guide for more details)

    Please backup database before proceeding.

    1. Go to /IntegrationServer/packages/WmTN/bin directory.

    2. Execute below command in your OS console (.sh/.bat)
      “tnimport.bat -xml init.xml -db”

    3. This will add/update standard metadata to your TN db.

    4. Reload WmTN package after importing the metadata.


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


  • 6.  RE: Error while creating a document type

    Posted Mon June 08, 2015 06:27 AM

    Its OK :slight_smile:


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


  • 7.  RE: Error while creating a document type

    Posted Fri June 12, 2015 07:42 AM

    Thanks for the solution Mahesh… it worked


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


  • 8.  RE: Error while creating a document type

    Posted Fri June 12, 2015 08:37 AM

    Ok, happy weekend :smiley:


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


Related Content