Error on deleting custom batch type: Violation of PRIMARY KEY constraint 'PK__#<some number>'. Cannot insert duplicate key in object 'dbo.@processingStageMap'. The duplicate key value is (<some number>). in method { call BatchType_Delete(?) }

Avatar

Tatiana Dyu

Symptoms

While trying to delete a custom batch type in the project on the ABBYY FlexiCapture 12 Application Server, the error occurs:
Violation of PRIMARY KEY constraint 'PK__#<some number>'. Cannot insert duplicate key in object 'dbo.@processingStageMap'. The duplicate key value is (<some number>). in method { call BatchType_Delete(?) }

Cause

This custom batch type has script stage/s in the workflow.

Resolution

Delete script stage/s from the workflow, and after that delete the batch type.

Have more questions? Submit a request

Comments

5 comments

Sort by Date Votes
  • Avatar

    Samir Waikar

    I tried this. There was no custom stage created or any script but still issue is occurring.

    0
  • Avatar

    Monique Mathay

    I have exactly the same error, I have no script on the workflow of the batch type (I force simple schema).

     

    0
  • Avatar

    Samir Waikar

    Hi Mathay,

    Abbyy has resolved this issue in the latest upgrade. I upgraded and no issue now.

    Thanks,

    Samir

    0
  • Avatar

    Monique Mathay

    Hi,

    To which version did you migrate ? We are actually in 12.0.4.734.

    Regards

    0
  • Avatar

    Samir Waikar

    Yes, till .734 this was an issue. In the recent release R4 .803, Abbyy has fixed this issue.

    Thanks,

     

    0

Please sign in to leave a comment.