Solved

Sybase 15: arithmetic overflow occurred

Posted on 2011-02-23
5
1,702 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Riverbed Technology's webinar discusses networking for the cloud era with simplified SD-WAN cloud connectivity.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

830 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