Data Conversion hangs on IM_LotSerialTransactionHistory in Sage 100 2020 Product Update 1 (2020.1)

Solution Properties

Solution ID:

220924560107126

Last Modified Date:

Tue Apr 04 10:59:58 UTC 2023

Taxonomy Path:

Category//Installation

Author:

[email protected]

Data Conversion hangs on IM_LotSerialTransactionHistory in Sage 100 2020 Product Update 1 (2020.1)

Description

Cause

Resolution

[BCB:1:Backup warning:ECB]

Download Program Fix IM6000T for Sage 100 2020.1 resolves this issue.

Possible Workaround:

Let conversion run until complete.
- Caution: This may take hours. For those with several hundreds of thousands of records in the table, this may take a day or more.
If this is an upgrade, consider upgrading to just Sage 100 2020 for now, rather than Sage 100 2020 with Product Update 1

DocLink: What's New in Sage 100 Version 2020.1

[BCB:155:Chat 100 US:ECB]

Defect ID

112421

Steps to duplicate

Steps to Duplicate* NOTE: Requires company data with over 100K records in IM_LotSerialTransactionHistory 1. Open Library Master, Main, Company Maintenance 2. Select Company 3. Click Convert 4. Click Proceed NOTE: Deborah Burke tested using customers data and discovered it took 3 minutes to convert\update 637 records in IM_LotSerialTransaction.