When trying to create a promotion in Store MC the system shows error message
Problem Statement
when trying to create a promotion in Store MC the system shows the following error message
'Error de confirmación. Tipo de objeto: PromotionBy,Clave:2000000000000001'.
In English this error message is
‘Error the confirmation. Type Obtject> PromotioBy,Clave> 200000000001’
Complete Error Message
<InnerExceptionInfo>
<Type>System.Data.SqlClient.SqlException</Type>
<Message>Violation of PRIMARY KEY constraint 'PK_ProPromotionBuySide'. Cannot insert duplicate key in object 'dbo.ProPromotionBuySide'. The duplicate key value is (2000000000000001).
The statement has been terminated.</Message>
<Source>.Net SqlClient Data Provider</Source>
Environment
iVend 6.5 Update 6 with SAPB1 9.2
Symptoms
when trying to create a promotion in Store MC the system doesn't allow to save the promotion objects in iVend MC
Resolution/Work Around
We have checked and verified the sysnextnumber table and found that next number id's were missed for 'Table.PromotionBuy' and 'Table.PromotionGet' on store database while it exists on HO database. We have inserted those next number id's in sysnextnumber table using sql statements and after restarting the iVend MC, promotion is created successfully without any error message.
Recommendations /Suggestion
Such Scenarios are enhanced in iVend 6.6 and suggest to use iVend 6.6 with latest patch.
Related Articles
Require to make the inventory as Zero for particular store
Environment: iVend 6.6 with SAP B1 10 Problem statement: Require to make the inventory as Zero for particular store. Symptoms: products Inventory show in negative and some are in positive numbers. Resolution/Work Around: There is need to check if SAP ...Email showing error message through schedule "Failure sending mail"
Environment: iVend Version 6.6 with SAPB1 10 Problem Statement: Email showing error message through schedule "Failure sending mail" Symptoms: Email showing error message through schedule "Failure sending mail". The error is displayed in schedule log ...Integration Error "System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB"
Environment: iVend 6.6 integrated with SAPB1 HANA Problem Statement: Integration was not working and its showing below message on Event Viewer Log “System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General ...Getting integration error "System.Exception: DI:To generate this document, first define the number
Problem Statement Integration error "generate this document, first define the numbering series in the Administration module" Issue in detail Getting integration error "System.Exception: DI:To generate this document, first define the numbering series ...IVend GRPO creation issue When customer trying to create a GRPO from management console
Product version: 6.6 Problem statement INC0016944 When user trying to create a GRPO from management console when customer click new and choose any PO it does not show any error and revert back to GRPO search screen. Proposed solution: - As a ...