Error upgrading company db from patch45 to 47

[Former Member]

Hello, Im having an error upgrading my company database to patch 47 from patch 45. while on the upgrade screen, I can see on the status bar that the upgrade process cannot find a "Department" object

Ive done upgrades before with no problem, but this time I had to run it twice because the first time an error showed up that it couldnt upgrade the b1_share folder.

Here is the log file.

UPG_DoObjectUpgradeInt 2, error in object index=124, object name=Departments, object ID=119

STACK:

Frame id=00: "C:\Program Files\SAP\SAP Business One\SAP Business One.exe"; base=0x00400000, offset=0x02AD2460

Frame id=01: "C:\Program Files\SAP\SAP Business One\SAP Business One.exe"; base=0x00400000, offset=0x028A1606

Frame id=02: "C:\Program Files\SAP\SAP Business One\SAP Business One.exe"; base=0x00400000, offset=0x028A0322

Frame id=03: "C:\Program Files\SAP\SAP Business One\SAP Business One.exe"; base=0x00400000, offset=0x028A029D

Frame id=04: "C:\Program Files\SAP\SAP Business One\SAP Business One.exe"; base=0x00400000, offset=0x0289E2F4

Frame id=05: "C:\Program Files\SAP\SAP Business One\SAP Business One.exe"; base=0x00400000, offset=0x02273CCA

Frame id=06: "C:\Program Files\SAP\SAP Business One\SAP Business One.exe"; base=0x00400000, offset=0x029146C1

Frame id=07: "C:\WINDOWS\system32\kernel32.dll"; base=0x7C800000, offset=0x7C80B50B

C:\Program Files\SAP\SAP Business One\SAP Business One.exe PID=3220 TID=256

28/03/2009 13:10:19:443910 Upgrade NoteLogAlways FromVersion=800180 ToVersion=800181 Ending the company upgrade C:\Program Files\SAP\SAP Business One\SAP Business One.exe PID=3220 TID=1640

[former_member583013]

Please report to SAP Support for further direction on this. There could be a corruption as the upgrade errored half way the first time

[Former Member]

Thank you for reply, I found out the reason, there was a record missing in the departments table (record num -2).... i dont know why... we added the record and then the upgrade proceeded as expected.

Thank you.