cancel
Showing results for 
Search instead for 
Did you mean: 

FAILED UPGRADE OF DATABASE TABLE ODOR

eonsase
Participant
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert

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
Advisor
Advisor
0 Kudos

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