Hi everyone and compliments for the year ahead.
I am having a problem in Sage CRM 2018R3. When I try and create a new component in the component in order to record some changes I am going to make on the company screen, the new component fails to create. There is a message: SQL code: 8152.
I have checked the SQL logs and get the following:
String or binary data would be truncated:
Components(Cmp_Name,Cmp_Description,Cmp_Writing,Cmp_Version,cmp_CreatedBy,cmp_CreatedDate,cmp_UpdatedBy,cmp_UpdatedDate,cmp_TimeStamp) VALUES (N'CasesWorkflow',N'this is for the latest workflow to be moved from dev to live',N'Y',N'2018 R3',1,'20181205 10:49:48',1,'20181205 10:49:48','20181205 10:49:48')
I am not sure where the problem lies in order to fix
Thank you in advance for any ideas to resolve
This is a known issue.
In 2018 R3 it is not possible to create a new component to record changes made to CRM . There is a SQL Error due to the cmp_version column that is only 5 char and "2018 R3" that CRM is trying to insert.
This is going to be fixed in Sage CRM 2019 R1. (Ref: 0-171173-QA)
Thank you Jeff. I have fixed it manually in order to proceed with project
© The Sage Group plc 2017All Rights Reserved