The Sage CRM Component Manager fails to create a new component

This question has suggested answer(s)

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

All Replies
  • Hello

    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