"This entry already exists in the following tables (ODBC -2035) [الرسالة 131-183]" error

[former_member520353]

"This entry already exists in the following tables (ODBC -2035) [الرسالة 131-183]" error while adding Approval Stages though coding.

Private Sub AddApprovalStages()

Try

Dim oApprovalStage As SAPbobsCOM.ApprovalStage

Dim oApprovalStageApprovers As SAPbobsCOM.ApprovalStageApprovers

Dim oFirstApprover As SAPbobsCOM.ApprovalStageApprover

Dim oSecondApprover As SAPbobsCOM.ApprovalStageApprover

Dim oApprovalStageParams As SAPbobsCOM.ApprovalStageParams

Dim oCompanyService As SAPbobsCOM.CompanyService

oCompanyService = oCompany.GetCompanyService Dim oApprovalStagesService As SAPbobsCOM.ApprovalStagesService

oApprovalStagesService = oCompanyService.GetBusinessService(SAPbobsCOM.ServiceTypes.ApprovalStagesService)

oApprovalStage = oApprovalStagesService.GetDataInterface(SAPbobsCOM.ApprovalStagesServiceDataInterfaces.assdiApprovalStage)

'oApprovalStageParams = oApprovalStagesService.GetDataInterface(ApprovalStagesServiceDataInterfaces.assdiApprovalStageParams)

' oApprovalStageParams.Code = 26 'oApprovalStage = oApprovalStagesService.GetApprovalStage(oApprovalStageParams) 'oApprovalStage.Code = 1 oApprovalStage.Name = "Sample_Repeat" oApprovalStage.Remarks = " Comment12115"

oApprovalStageApprovers = oApprovalStage.ApprovalStageApprovers

oFirstApprover = oApprovalStageApprovers.Add

oFirstApprover.UserID = 3

oSecondApprover = oApprovalStageApprovers.Add

oSecondApprover.UserID = 2

oApprovalStage.NoOfApproversRequired = 1

oApprovalStageParams = oApprovalStagesService.AddApprovalStage(oApprovalStage) 'Call oApprovalStagesService.AddApprovalStage(oApprovalStage) Catch ex As Exception MessageBox.Show(ex.Message & ex.StackTrace) End Try End Sub

This my code and error is coming on line

"oApprovalStageParams = oApprovalStagesService.AddApprovalStage(oApprovalStage)
"

[former_member520353]

I got the answer, the error was coming because of data curruption.

[former_member233854]

Check if there is any approval with the name "Sample_Repeat" in the database

[former_member520353]

No. There is no such named approval in database