In Sage CRM, Component Manager allows Customizations done in one CRM to be saved and transfer it to another Sage CRM system. It enables Sage CRM developers to package and reuse implementation-specific customizations in future implementations. Also, it saves lots of time and efforts. It is available at Administration -> Customisation -> Component Manager as shown in below screenshot.
Component Manager Section has following 2 tabs.
1. Components: This tab list down all the available components to be installed in “Available Components” section. You can also add the Components using “Upload new component” button as shown in above screenshot.
2. Component Details: This tab list down the Current Component. Also, it shows the Existing Components in the system as shown in below screenshot. You can create new Component using “New” button from this section.
For one of our Client, we have installed Sage CRM 2018 R3. We have to do some Field and Screen level customizations, so we thought to record all the changes in CRM. To record the changes, we were trying to create new Component from “Component Details” tab. But, after entering Component Name and Description, whenever we clicked on save button, system throws below error.
As the error depicts that it is an SQL error, we checked SQL logs and found below error.
Whenever we try to insert data in Components table, large amount of data is being entered in the Version field irrespective of its size. Till Sage CRM 2018 R2, the value for Version field is being entered as “2018” only. But, in 2018 R3 it is trying to insert the value as “2018 R3”, which is greater than the specified size. To overcome this issue, we have to increase the field size of Version field. Run the below query in SQL to do the same.
Alter table Components
alter column Cmp_Version nvarchar(20)
Now, try to create Component and you will be able to do so without any error.