Skip to Content
0
Jun 18, 2021 at 12:06 PM

FAILED UPGRADE OF DATABASE TABLE ODOR

311 Views

Hi Team,

We are upgrading two databases from SAP B1 version 920183 to 1000150 for SQL and below is the full error message:

2021-06-17 22:44:55.118925 Stp Err FromVersion=920183ToVersion=1000150table=ODOR, qurStr=UPG_UpdateOneTable() - error in GetFromTempTable() file:d:\depot\busmb_b1\sbo\10.0_rel\source\client\application\objmgr\pogen01.c line#2844, errString=[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot insert the value NULL into column 'NumOfDays', table 'ke-sapb1-ground-test.dbo.ODOR'; column does not allow nulls. INSERT fails.