Failed record in SAP to iVend Integration Faliure Monitor for type product (source type 46)

************* Internal Article *************

Error:

Failed record in SAP to iVend Integration Faliure Monitor for type product (source type 46) with below error message:SAP DBTech JDBC: [339]: invalid number: [6930] attribute value is not a number;int comma(string jf(int isnull(string "Locked"), string 'N', string "Locked"), fixed12_15.6 jf(int isnull(fixed12_15.6 "MinStock"), fixed12_15.6 '0', fixed12_15.6 "MinStock"), fixed12_15.6 jf(int isnull(fixed12_15.6 "MaxStock"), fixed12_15.6 '0', fixed12_15.6 "MaxStock"), int jf(int isnull(int [here]int(string "U_CXS_TRTP")), int '0', int int(string "U_CXS_TRTP"))),(Locked = 'N'[string], MaxStock = 0.000000[fixed12_15.6], MinStock = 0.000000[fixed12_15.6], U_CXS_TRTP = ''[string]); checkNull false

Below is the screenshot for the same:

​

Resolution:

Check if there is Blank or Null value in column U_CXS_TRTP field in SAP table OITW for that corresponding item.
If yes, then replace the value with 0 (Zero) by running SQL queries.
And open the Item in SAP screen once.
Then Retry corresponding failed records in Integration Failure Monitor. Issue should be resolved.

• Related Articles

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

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

• SAP Business One - iVend Retail Integration Points

  Introduction SAP Business One software is created specifically for small and midsized businesses. It is a powerful application and iVend Retail seamlessly integrates with it to help retailers better manage every aspect of their daily retail ...

• Price update events (source type 1003) from SAP to iVend getting failed in Integration Monitor

  ********************************Internal to CitiXsys****************************************** Product Version 6.5 Update 6 Issue Price update events (source type 1003) from SAP to iVend getting failed with error below: System FormatException: Index ...

• ISSUES WHEN INTIALIZING MASTER TABLES FROM SAP: "iVend 6.*.*.* add-on failed to update the database"

  Product version 6.5 Update 6 Problem statement Getting Error "iVend 6.*.*.* add-on failed to update the database" when initializing master tables from SAP Reason CXSINTEGRATION DATABASE IS DELETED SAP database, already initialized with iVend database ...