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
Proposed Solution
Customer created a UDF on purchase order detail and tried to update it by increasing its length due to which there was an error in the integration monitor. Suggested customer UDF once created can't be updated again.As a workground we update the length of udf through sql query.
Steps
Below are the steps for increasing UDF length in iVend.
1.Check column DataLength for Table CfgUserDefinedFieldDetail against given user defined field.
Example:
update CfgUserDefinedFieldDetail
set DataLength=50
where DataLength=15 and UserDefinedTableKey='5b81d90d-6989-43c1-b544-7f970d584b26'
2.Also required to alter length of associated Table UDF.
Example:
Alter table purpurchaseorderdetail alter column U_ItemCode nvarchar(50)
Constraints / Scenarios
NA
Related Articles
Item Group events stucked on Integration Failure Monitor String or binary data would be truncated
Environment : iVend 6.6 integrated With SAPB1 Problem Statement : Item Group add events stucked on Integration Failure Monitor from SAP Business one To iVend with below Message “System.Data.SqlClient.SqlException (0x80131904) String or binary data ...iVend Replication Events Generate Steps
Internal to Citixsys Support Team Environment: iVend 6.6 Problem Statement: In some cases we require to generate replication events like product add/update events to match the product data between Enterprise and store. Symptoms: N/A Resolution/Work ...iVend POS UDF Integration in iVend POS with SBO
What exactly is UDF (User Defined Field) Integration in iVend POS with SAP Business One (SBO)? The UDF is very useful tool when it comes to integrating static values entered in these fields from one application to the other application, apart from ...Violation of PRIMARY KEY constraint 'PK_TrxTransaction'. Cannot insert duplicate key in object 'dbo.
Product Version: iVend 6.5 Update 6 Replication Problem Statement: One of their store replication monitor logs is not moving from both sides (Enterprise and store) and its culminating in the replication monitor. Replication log file: Error message : ...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 ...