I am in the middle of the upgradation process and I have encountered error while upgrading customer company database.
Present Version : SAP Business One 9.0 PL07
Upgrade Version : SAP Business One 9.1 PL08
I have done the pre-upgrade check and it was successful.
My DB size is around 27 GB. Server Configuration, OS : Windows Server 2012, MS SQL Server 2012, 500GB Hard Disk and 24 GB Memory.
All the server components have successfully upgraded but the customer company database giving error.
It stopped while upgrading AITW table (Items- Warehouses - History).
So I have rollback to the present version SAP Business One 9.0 PL07.
Checked with SQL query: AITW table has more 20 million records.
customer company have around 21000 Item Master and 346 warehouses, so it giving huge volume data in the OITW table and log table AITW,
Kindly give your valuable suggestion on this.