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