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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  error while batch inserting data

    Posted 11/04/12 05:27 AM

    I am trying to execute a batch insert adapter service and I get the below error,

    [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service JDBCConnections:
    [ADA.1.316] Cannot execute the SQL statement “INSERT INTO

    (,,) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)”. "
    0(0)
    B [SQL0803] Duplicate key value specified. Cause . . . . . : An INSERT, UPDATE or ALTER TABLE statement was issued. Unique index or unique constraint
    _PK in exists over one or more columns of table
    in . The operation cannot be performed because one or more values would have produced a duplicate key in the unique index or constraint. [/b]

    Please advise if this an issue on the database side or should I be making a change to the adapter service.

    Thanks in advance!


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 2.  RE: error while batch inserting data

    Posted 11/05/12 03:22 PM

    Please do check the value that you are trying to insert is trying to replace with the private key value…

    Its definitely a data error, database is not accepting one of the field value which is unique and not altered


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: error while batch inserting data

    Posted 11/06/12 12:33 AM

    Thank you Sreekanth! I got it solved.


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 4.  RE: error while batch inserting data

    Posted 11/06/12 02:09 AM

    I had the same error , then i check the data and found the same reason ,thank you very much !


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB