Integration Error Change tracking is not enabled on table

Problem Statement 

Integration was not working from iVend to SAP and Vice-Versa. It shows status Not processed.

On Integration Event viewer we found  below error

“System.Exception: System.Data.SqlClient.SqlException (0x80131904): Change tracking is not enabled on table”

Proposed Solution

We found that the error was related to  change tracking on SAP.

Enabled change tracking on sap database with the help of sql query.

 

Steps: 

Below are  tables in which we require change tracking on SAP.

ALTER TABLE SPP1  ENABLE CHANGE_TRACKING

ALTER TABLE OSCN ENABLE CHANGE_TRACKING

ALTER TABLE OBTN ENABLE CHANGE_TRACKING

ALTER TABLE SPP2 ENABLE CHANGE_TRACKING

ALTER TABLE OPLN ENABLE CHANGE_TRACKING

ALTER TABLE OALI ENABLE CHANGE_TRACKING

ALTER TABLE OCRD ENABLE CHANGE_TRACKING

ALTER TABLE ITM1 ENABLE CHANGE_TRACKING

ALTER TABLE CRD8 ENABLE CHANGE_TRACKING

ALTER TABLE OSPG ENABLE CHANGE_TRACKING

ALTER TABLE OSPP ENABLE CHANGE_TRACKING

ALTER TABLE ORTT ENABLE CHANGE_TRACKING

ALTER TABLE OSRN ENABLE CHANGE_TRACKING

ALTER TABLE ITM9 ENABLE CHANGE_TRACKING

• Related Articles

• iVend to SAP Intgartion Error : Credit Card - CUSTOM not set neither for the warehouse nor on the Retail Tender in SBO

  Environment :  Ivend 6.6 Problem statement : iVend to SAP SAP B1 Integration Error : Credit Card - CUSTOM not set neither for the warehouse nor on the Retail Tender in SBO Symptoms: Sale Transactions is not integrating from ivend to SAP B1. Below ...

• 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 ...

• Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer"

  *****************For Internal purpose********************* Product Version: iVend 6.6 Issue: Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer": Integration Error: System.Data.SqlClient.SqlException (0x80131904): ...

• 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 ...

• General Settings in SAP Business One

  Introduction The iVend Add-on helps in setting up some configurations required for integrating iVend with SAP Business One. The following sections of this document capture the functionality of the new screens created and new fields added to the SAP ...