on 12-16-2010 3:48 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Dear Emanuele,
You have to upgrade it to SAP 8.8 SP 00 PL 15 instead, not PL 14.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.