Environment:
Ivend 6.6
Problem statement:
Unable to start iVend AddOn 6.6.3.0 x64 on SAP B1 10
Symptoms:
When try to start iVend AddOn 6.6.3.0 x64 on SAP B1 10 Below error message showing:
------------------------------------------------------------------------------------------
User :manager, Method :, Error Message :DataBase Script Running at , Date :12/5/2022 09:59:36.
------------------------------------------------------------------------------------------
User :manager, Method :HandleIndexForiVend, Error Message :Table Name : OINV, Field Name : System.String[], ErrCode : -2035, ErrMessage : Esta entrada ya existe en las tablas siguientes (ODBC -2035), Date :12/5/2022 10:06:30.
------------------------------------------------------------------------------------------
User :manager, Method :Main, Error Message :Table Name : OINV, Field Name : System.String[], ErrCode : -2035, ErrMessage : Esta entrada ya existe en las tablas siguientes (ODBC -2035), Date :12/5/2022 10:06:30
Reason/Cause:
This problem has been found due to indexes was created in SAP Database through Sql query in SAP Database.
Resolution/Work Around:
We recommend to fix this error with the SAP Partner first then after try to install iVend addon again.
Recommendations /Suggestion:
We strongly recommend please never create any indexes directly using SQL query on SAP database.