FAILED UPGRADE OF DATABASE TABLE ODOR

[eonsase]

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.

[ANKIT_CHAUHAN]

Dear ernestonsase,

Kindly refer to SAP Note 2369678 in this regards and confirm whether it helps or not.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[jitin_chawla]

Run the following detect query and see if in NumOfDays column as value as NULL:

Select * from ODOR

If yes, from the B1 loin and check if under Administration → Setup → Financials → Doubtful Debts, updating value to correct number or removing NULL value resolves the issue.

Test it on COPY database.

KR,

Jitin