We are trying to upgrade GP 8 to 9 but get errors on our PO line tables. Does anyone know of a fix for this? We are using documentation from CustomerSource including 878449, 920900, 871973 and running the GP 9.0 Upgrade Scripts but we cannot find any detailed solutions for the following errors;
POP10110 error = Cannot insert the value NULL into column 'ADRSCODE', table 'GPI.dbo.POP10110'; column does not allow nulls. INSERT fails.
POP30110 error = Cannot insert the value NULL into column 'ADRSCODE', table 'GPI.dbo.POP30110'; column does not allow nulls. INSERT fails.
If we try to update these again, the tables don't get updated successfully or sometimes even get deleted! If we ignore them and continue through the update process, the company shows as having updated with errors.
POP10110 error = Cannot insert the value NULL into column 'ADRSCODE', table 'GPI.dbo.POP10110'; column does not allow nulls. INSERT fails.
POP30110 error = Cannot insert the value NULL into column 'ADRSCODE', table 'GPI.dbo.POP30110'; column does not allow nulls. INSERT fails.
If we try to update these again, the tables don't get updated successfully or sometimes even get deleted! If we ignore them and continue through the update process, the company shows as having updated with errors.