I retrieved a update set to test instance and preview was successful but when i committed it it got an error. ERROR: FAILED TRYING TO EXECUTE ON CONNECTION glide.0 (connpid=47761): com.glide.db.BatchStatement$StatementContainer@bd2466,com.glide.db.Ba

[shashidhar2]

I retrieved a updateset to test instance and preview was successful but when i committed it, it got an error.

ERROR: FAILED TRYING TO EXECUTE ON CONNECTION glide.0 (connpid=47761): com.glide.db.BatchStatement$StatementContainer@bd2466,com.glide.db.BatchStatement$StatementContainer@19a4f2 java.sql.BatchUpdateException: (conn=47761) Duplicate entry 'sn-va-sp-widget-icon.svg' for key 'db_image_index0'

[Ankur Bawiskar]

Hi Shashidhar,

Can you try to retrieve it again, preview it and then commit

Regards

Ankur

[Sanjay Bagri1]

Hi ,

 You can remove again try to retrieve the Update set by retrieve update set module and the you can review and commit the update set.

Might be fix the issue.

Please mark correct and helpful.

Thanks

Sanjay 

[apurvasharma]

Hi,

Can you check "Commit Log" to find out errors during commit. Look for errors that indicate which records failed to commit and why. Create a new update set to address those failures, if necessary.

Regards,

Apurva

[shashidhar2]

This is the error i found in commit log.But the state is set to commited instead of this error also

ERROR: FAILED TRYING TO EXECUTE ON CONNECTION glide.0 (connpid=47761): com.glide.db.BatchStatement$StatementContainer@bd2466,com.glide.db.BatchStatement$StatementContainer@19a4f2 java.sql.BatchUpdateException: (conn=47761) Duplicate entry 'sn-va-sp-widget-icon.svg' for key 'db_image_index0'