Solved

Sybase 15: arithmetic overflow occurred

Posted on 2011-02-23
5
1,681 Views
Last Modified: 2012-05-11
When I attempt to run the following code I get an arithmetic error in interactive SQL
error code 3606

Can someone tell me what this means and what I am doing wrong here?

thanks,

K

use database42
go
exec sp_dbextend 'listfull', 'threshold', database42

Open in new window

0
Comment
Question by:kabaam
  • 2
5 Comments
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 250 total points
ID: 34967302
Unless you have replaced the built-in version of sp_dbextend with your own in-house version, it means you have found a Sybase bug and need to talk to Sybase Tech Support.

The error means a number was too large for the datatype holding it. If this occurs in a Sybase-supplied proc, then it's a bug. :)

Doesn't look like you're doing anything wrong.
0
 
LVL 11

Author Comment

by:kabaam
ID: 34975390
Thanks Joe,  I will look at the SP a bit to determine if it has been modified
0
 
LVL 11

Author Comment

by:kabaam
ID: 35486461
ahh...forgot all about this one.  I have not looked at the sql file yet but it is a custom build so I am certain that is the concern.

Thanks,

K
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 35510897
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Importing data to Sybase, getting "EOF encountered" error 3 752
SyBase SQL Querry Syntax 1 259
How do I get SCOPE_IDENTITY working correctly. 3 845
sql statement error sybase 2 49
An article on effective troubleshooting
Each year, investment in cloud platforms grows more than 20% (https://www.immun.io/hubfs/Immunio_2016/Content/Marketing/Cloud-Security-Report-2016.pdf?submissionGuid=a8d80a00-6fee-4b85-81db-a4e28f681762) as an increasing number of companies begin to…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question