"Lot ID is not specified" error in Microsoft Dynamics AX 2009 data upgrade cockpit

This article provides a resolution for the Lot ID is not specified error that occurs during the Microsoft Dynamics AX 2009 upgrade.

Applies to:   Microsoft Dynamics AX 2009
Original KB number:   2463885

Symptoms

Microsoft Dynamics AX 2009 upgrade is stuck in the PostSynchronize process on a task with the description of TransferOrderLines method name updateInventTransferLine.

The job returns the error:

Lot ID is not Specified.

Cause

Usually the error Lot ID is not Specified is due to Database logging being enabled for the table(s) that the method is trying to update.

Check to see if you have database logging or Alerts setup in the InventTranferLine table in the version of Microsoft Dynamics AX you are upgrading from.

Resolution

Turn off database logging for the tables involved. For this method, turn off database logging for InventTransferLine, InventTrans, InventTransPosting, and InventSettlement.

So remove the database log for those table by removing the records pertaining to the tables from the databaselog table. You may want to make a copy of this table so you can re-setup the logging after the upgrade. Below is the associated log table ID:

  • InventTransferLine (1705)
  • InventTrans (177)
  • InventTransPosting (553)
  • InventSettlement (173)