Table 'FRS_CIComponent' record count 6,021,070 exceeds the maximum allowed (1,000,000) for operations requiring changes in table schema. Please contact support to assist on schema changes for this object

Version 1

    Details

    When trying to change field size the following error occurs.

    Error 1: Table 'FRS_CIComponent' record count 6,021,070 exceeds the maximum allowed (1,000,000) for operations requiring changes in table schema. Please contact support to assist on schema changes for this object


    Resolution

     

    You can update the following key in HeatSoftware\Heat\appserver\web.config 


    First backup the webconfig before making any changes.

    Modify the below field for your needs.


       <add key="LimitSchemaChangesForAboveNRows" value="1000000" />


    Save changes