Solved

Sybase 15: arithmetic overflow occurred

Posted on 2011-02-23
5
1,767 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

With the rising number of cyber attacks in recent years, keeping your personal data safe has become more important than ever. The tips outlined in this article will help you keep your identitfy safe.
A look at what happened in the Verizon cloud breach.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

632 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