Column name 'DBName' in table 'dbo.IntegrationMapping' is specified more than once.

Environment :

iVend 6.6 

Problem Statement :

Getting an error "[ODBC Driver 13 for SQL Server][SQL Server]Column names in each table must be unique. Column name 'DBName' in table 'dbo.IntegrationMapping' is specified more than once" while installing iVend addon on SAP

Resolution/Work Around:

Kindly refer the below attached article: -

Problem Statement:

Unable to connect iVend add-on in SAP 10.0 PL2.

Error:

While connecting the add-on in SAP Business One system gives the below error.

iVend 6.6.0.14 add-on failed to update the database

Add-on Log Path: C:\Users\[Logged In User]\AppData\Local\CitiXsys\CXS.Retail\AddonLOG

Add-on Log Error: User: manager, Method: Main, Error Message :1). [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]CREATE DATABASE permission denied in database 'master'.

Solution:

1. Login in your System Landscape Directory, and check "Database User" for the Database in which iVend add-on is installed.

 2: Login in SQL Server with user ID SA.

Go to: Security>> Logins>> Right click on SAP Database User >>> Properties.

3: On the Login Properties window click on “User Mapping” Below window will appear.

Check the check box for “CXSINTEGRATION” and click on OK button.

4: Exit from SAP Business One and then Login and try to connect iVend add-on

In case if you are still facing the issue then please follow below steps: -

Login in SQL Server with user  SA.

Database >> CXSIntegration DB >> Right click >> properties >> permissions >> View server permissions

Give all necessary alter permission to SAP database user.

• Related Articles

• System.Exception MethodName SendPostRequest, WebException Invalid column name 'U_status1'.

  Environment: iVend 6.6 with SAP B1 Problem statement: System.Exception MethodName SendPostRequest, WebException Invalid column name 'U_status1'. At ReplicationSBOIntegrationWinSer.IntegrationObjects.Base.IntegrationBase.SendPostRequest(List 1 ...

• Udf events String or binary data would be truncated in table CXSRetail.dbo.PurPurchaseOrderDetail',

  *****************For Internal purpose********************* Product Version iVend 6.6 integrated with SAP B1 Problem Statement Used defined field events stuck on Integration Failure Monitor with error message from SAP to iVend ...

• error message:- Initialization Failure "invalid column name"

  Problem: Management Console could not be launched after initializing the store While Initialization a new store , getting error message “Invalid column name 'CustomerDisplayKey' or Invalid column name 'IsCustomerDisplayEnabled’” while launching the ...

• Integration failures : Cannot insert the value NULL into column 'SourceKey', table

  Environment iVend 6.5.6 and 6.6 with SAP B1 9.2 Problem Statement While updating the Item in SAP, you were getting the error "Internal Error occurred 3621". We checked the Integration Monitor and the Event Viewer and found the Error message as " ...

• SAPB1 AR invoice incorrect customer name.

  Environment: iVend 6.6 with SAPB1 9.2 Problem Statement: There was one sale performed on iVend POS but when it got integrated from iVend to SAPB1, SAPB1 AR Invoice displays the different customer name as compared to customer master. Symptoms : There ...