Retail Distribution Jobs 1040 , 1130 , session apply failed after increasing field String/Character length in Product Dimension ( Size)

Dear Friends,

I changed Field (String) Length of Size Product Dimension by adjusting length in EcoResSize EDT to 15 .

and also I changed String size in InventSizeID filed of ax.INVENTDIM and Name field of ax.ECORESSIZE Retail Channel Database accordingly.

but when I ran Job number 1040-Products and 1130-Product availability , I’m getting error in the process status messages saying that apply failed. and also I’m getting following error in Description

ERROR Job 1040:

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessTargetRequestHeaderException: ProcessTargetRequestHeader failed to execute all write requests. —> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessWriteRequestException: Write request on table:[ax].[ECORESSIZE] failed to execute. —> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Exception occured in GetPrimaryKeyColumnNames —> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.GetPrimaryKeyColumnNamesException: Primary key is not defined on table: ECORESSIZE, schema: ax

at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlMergeRequestRunner.GetPrimaryKeyColumnNames(SqlConnection connection, SqlTransaction transaction)

at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlMergeRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)

ERROR Job 1130:

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessTargetRequestHeaderException: ProcessTargetRequestHeader failed to execute all write requests. —> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessWriteRequestException: Write request on table:[ax].[INVENTDIM] failed to execute. —> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Exception occured in GetPrimaryKeyColumnNames —> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.GetPrimaryKeyColumnNamesException: Primary key is not defined on table: INVENTDIM, schema: ax

at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlMergeRequestRunner.GetPrimaryKeyColumnNames(SqlConnection connection, SqlTransaction transaction)

at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlMergeRequestRunner.Run(SqlConnection connection, SqlTransaction transaction)

Anyone faced same error before?, or I missed any steps?

Thanks & Regards,

Amith Prasanna