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

Is Server Log -getting Primary Key Constraint Error

  • 1.  Is Server Log -getting Primary Key Constraint Error

    Posted Wed April 18, 2007 06:00 PM

    We are getting this type of error in server log. Any one can help me out this violation of PRIMARY KEY constraint how to fix it!

    4/16/2007 2:44:26 PM DECIMonitoring.DocTracking.Db:insertState [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Violation of PRIMARY KEY constraint ‘idx_edcstate_p_cl_01’. Cannot insert duplicate key in object ‘tbl_edc_state’. tech.deci.com:5555

    4/16/2007 2:44:26 PM DECIMonitoring.DocTracking.Db:insertState [ADA.1.316] Cannot execute the SQL statement “INSERT INTO db_webmethods_support_edc.dbo.tbl_edc_state(stat_s tate_id, state_item_id, state_start_ts) VALUES (?, ?, ?)”. "

    (23000/2627) [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Violation of PRIMARY KEY constraint ‘idx_edcstate_p_cl_01’. Cannot insert duplicate key in object ‘tbl_edc_state’.

    (HY000/3621) [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The statement has been terminated."

    [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Violation of PRIMARY KEY constraint ‘idx_edcstate_p_cl_01’. Cannot insert duplicate key in object ‘tbl_edc_state’. tech.deci.com:5555

    4/16/2007 2:44:26 PM DECIMonitoring.DocTracking.Db:insertState [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Violation of PRIMARY KEY constraint ‘idx_edcstate_p_cl_01’. Cannot insert duplicate key in object ‘tbl_edc_state’. tech.deci.com:5555


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


  • 2.  RE: Is Server Log -getting Primary Key Constraint Error

    Posted Fri April 20, 2007 02:19 PM

    Those tables do not appear to be ones used by webMethods products. Review the error log to see which service(s) is(are) causing the duplicate key errors and contact the developers to correct the issue.

    Mark


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


  • 3.  RE: Is Server Log -getting Primary Key Constraint Error

    Posted Fri April 20, 2007 03:17 PM

    Thanks a lot!


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


Related Content