cancel
Showing results for 
Search instead for 
Did you mean: 

Error Upgrading: SBO 2005 PL 46 to SBO 8.8

Former Member
0 Kudos

Dear all,

I'm trying to update a database from SBO 2005 SP 01 PL 46 to SAP 8.8 SP 00 PL 14.

The upgrade failed.

Error:

Object: VAT Transaction

Result: Failed

Message: Money Overflow; cannot display all digits (ODBC - 104)

I have the same error if I try to upgrade to SBO 2007 SP 01 PL 05

What can I do?

Can someone help me, please?

Regards

Emanuele

Accepted Solutions (1)

Accepted Solutions (1)

ladislav_meszaros
Contributor
0 Kudos

Dear Emanuele,

You are facing a money overflow issue described in SAP Note [1303425|https://websmp130.sap-ag.de/sap(bD1odSZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1303425].

In order to handle this issue please log a support message via the Service Market Place. Please attach 'UpgradeLog' files to the message.

You will find the log files in the default log folder

"%USERPROFILE%\Local Settings\Application Data\SAP\SAP Business One\Log\UpgradeWizard" or any other folder configured for this purpose in "B1_Install_Folder\Conf\b1-config-path.txt". (BuisnessOneUpgradeUpgradeWizardPidxxxx_xxxxxxxxxxxxxx.txt; BuisnessOneUpgradeb1loggerPidxxxx_xxxxxxxxxxxxxx.txt; BuisnessOneUpgradeB1UpgradePidxxxx_xxxxxxxxxxxxxx.txt)

Regards,

Ladislav Meszaros

SAP Business One Forum Team

Former Member
0 Kudos

Dear Ladislav,

I run the query, but no row have been found.

Regards

Emanuele

Answers (3)

Answers (3)

ladislav_meszaros
Contributor
0 Kudos

Dear Emanuele,

Thank you for providing information. Reported issue needs a further investigation therefore please log a support message with a component SBO-BC-UPG via the Service Market Place.

Regards,

Ladislav Meszaros

SAP Business One Forum Team

ladislav_meszaros
Contributor
0 Kudos

Dear Emanuele,

In order to handle this upgrade issue please log a support message via the Service Market Place.

Please also attach all 'UpgradeLog' files to the message.

Regards,

Ladislav Meszaros

SAP Business One Forum Team

Former Member
0 Kudos

Dear Ladislav,

thank you for your suggestion.

This this the error messages in the log file:

20/12/2010 10:06:23:197750 SQLMessage Error I Technical DBMCSqlStatement::Execute SQLExecute failed. Error: -1, sqlState: 23000, nativeErr: 2627, errText:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'ODOX_PRIMARY'. Cannot insert duplicate key in object 'dbo.ODOX'. # # MID=-1 BOID=-1 BO= UserID= C:\temp\B18800_15-10003894\Wizard\Upgrade.exe Version=8.80.233 Area= PID=4132 TID=664 D:\depot\BUSMB_B1\8.8_REL\SBO\8.8_REL\Application\__Engines\DBM\__DBMC_Statement.cpp 287

20/12/2010 10:06:31:430171 SystemMessage Error I Business Business Object Flow: Upgrade failed, err number is -104 # # MID=-1 BOID=-1 BO=VAT Transactions UserID= C:\temp\B18800_15-10003894\Wizard\Upgrade.exe Version=8.80.233 Area= PID=4132 TID=664 D:\depot\BUSMB_B1\8.8_REL\SBO\8.8_REL\Application\ObjMgr\Hdr\_BusinessObjectMethods.h 35

20/12/2010 10:06:33:531734 SystemMessage Error I Business Numero non ammesso; impossibile visualizzare tutte le cifre (ODBC -104) [Messaggio 7001-21] # # MID=-1 BOID=-1 BO= UserID= C:\temp\B18800_15-10003894\Wizard\Upgrade.exe Version=8.80.233 Area= PID=4132 TID=664 -1

Regards

Emanuele

Former Member
0 Kudos

Dear Emanuele,

You have to upgrade it to SAP 8.8 SP 00 PL 15 instead, not PL 14.

Thanks,

Gordon

Former Member
0 Kudos

Dear Gordon,

I tried to upgrade to SBO 8.8 PL 15 but I have the same error.

Update failed.

I think I need to clean a numeric field in a table of the database.

This is the log file:

STACK:

Frame id=00: "C:\temp\B18800_15-10003894\Wizard\B1_EnginesSP.dll"; base=0x10000000, offset=0x103C1180

Frame id=01: "C:\temp\B18800_15-10003894\Wizard\B1_EnginesSP.dll"; base=0x10000000, offset=0x10377A16

Frame id=02: "C:\temp\B18800_15-10003894\Wizard\B1_EnginesSP.dll"; base=0x10000000, offset=0x10376702

Frame id=03: "C:\temp\B18800_15-10003894\Wizard\B1_EnginesSP.dll"; base=0x10000000, offset=0x1037667D

Frame id=04: "C:\temp\B18800_15-10003894\Wizard\B1_EnginesSP.dll"; base=0x10000000, offset=0x103743E4

Frame id=05: "C:\temp\B18800_15-10003894\Wizard\Upgrade.exe"; base=0x00400000, offset=0x00CA62D6

Frame id=06: "C:\temp\B18800_15-10003894\Wizard\Upgrade.exe"; base=0x00400000, offset=0x02600E8C

Frame id=07: "C:\temp\B18800_15-10003894\Wizard\Upgrade.exe"; base=0x00400000, offset=0x025FF419

Frame id=08: "C:\temp\B18800_15-10003894\Wizard\Upgrade.exe"; base=0x00400000, offset=0x025FB9D8

Frame id=09: "C:\temp\B18800_15-10003894\Wizard\Upgrade.exe"; base=0x00400000, offset=0x025FAA5D

Frame id=10: "C:\temp\B18800_15-10003894\Wizard\Upgrade.exe"; base=0x00400000, offset=0x025F979D

Frame id=11: "C:\temp\B18800_15-10003894\Wizard\Upgrade.exe"; base=0x00400000, offset=0x02DFC329

Frame id=12: "C:\temp\B18800_15-10003894\Wizard\Upgrade.exe"; base=0x00400000, offset=0x02DF986C

Frame id=13: "C:\temp\B18800_15-10003894\Wizard\Upgrade.exe"; base=0x00400000, offset=0x02E28AE8

Frame id=14: "C:\temp\B18800_15-10003894\Wizard\Upgrade.exe"; base=0x00400000, offset=0x02E2A1D0

Frame id=15: "C:\temp\B18800_15-10003894\Wizard\B1_EnginesSP.dll"; base=0x10000000, offset=0x1017E411

Frame id=16: "C:\Windows\syswow64\kernel32.dll"; base=0x77260000, offset=0x77273677

Frame id=17: "C:\Windows\SysWOW64\ntdll.dll"; base=0x77910000, offset=0x77949D72

Frame id=18: "C:\Windows\SysWOW64\ntdll.dll"; base=0x77910000, offset=0x77949D45

C:\temp\B18800_15-10003894\Wizard\Upgrade.exe PID=2288 TID=2616

17/12/2010 12:54:33:341398 Upgrade NoteLogAlways FromVersion=680320 ToVersion=880233 Ending the company upgrade C:\temp\B18800_15-10003894\Wizard\Upgrade.exe PID=2288 TID=2616

Regards

Emanuele