Symptom
-
Error 247 is returned when running sp_addthreshold on a database larger than the following:
- 4 terabytes on a 2k page ASE server
- 8 terabytes on a 4k page ASE server
- 16 terabytes on a 8k page ASE server
- 32 terabytes on a 16k page ASE server
-
For example:
sp_addthreshold mydb, "default", 110843980, 'sp_run_threshold'
go
Returns this error message:
Msg 247, Level 16, State 1:
Server 'ASE', Procedure 'sp_addthreshold', Line 220:
Arithmetic overflow during implicit conversion of UNSIGNED INT value '2216879616' to a INT field.
(return status = -6)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.5 and 15.7
- SAP Adaptive Server Enterprise (ASE) Business Suite
- SAP Adaptive Server Enterprise (ASE CE) Cluster Edition
Product
Keywords
unsigned int, bigint, CR787605, CR#787605, 787605, installmaster , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.