on 12-11-2011 12:17 AM
Dear all,
I just encountered a problem while upgrading a DB.
The log part regarding the problem is as follows:
**Error FromVersion=800234 ToVersion=880238 table=@PCK1, qurStr=, file=D:\depot\BUSMB_B1\8.8_REL\SBO\8.8_REL\Application\ObjMgr\POGen01.c line#1404, errString=[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting numeric to data type numeric.**
It seems that there was a problem with a conversion of some data in one of the user defined tables.
Any idea how can I approach this?
Thanks!
Hi,
If it is only due to one UDT, your simplest solution would be export all its records and delete before upgrade. Then recreate it after successful upgrade.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you both for your answers!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Alternative option is :-
One option available that export all data in excel form UDT then upgrade it and after upgrade import data in same table.
Right Option is:-
Once you upgrade find the exact problem otherwise it will occur life time whenever you will upgrade the SAP server.
Thanks
Manvendra Singh Niranjan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.