February 14, 2005 at 9:15 am
I recieve the following error when a scheduled job runs and cannot figure out where the overflow is occuring. Anyone have any ideals?
An Execution ERROR has occurred. Line:11 Error number: 6 Error Source: HLSSchedule Error Description: Overflow.
February 14, 2005 at 9:51 am
Check the job history of the job and it will tell you the step it failed at (click the show detail checkbox). From there you will have to examine WHAT that step was doing and more than likely start pawing through the data...
Good Hunting!
AJ Ahrens
webmaster@kritter.net
February 15, 2005 at 11:10 am
A common source of Overflow errors is the implicit conversion of a string to a number. If you have a where condition such as "WHERE integerfield = stringfield" SQL will try to convert your string to a number, which may be the source of the error.
There are about 700 other ways an overflow could happen, but hopefully this will give you some idea where to look.
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply