Server Msg 8115, Level 16, State 5, Line 1 Arithmetic overflow error converting numeric to data type varchar

Posted on 2006-06-07
Medium Priority
Last Modified: 2007-11-27
We are using SQL Server 200 sp3
The application is called KRONOS.

 It was recently updated and now DBCC is providing the following error.  I beleve that it is a rounding bug in the application but wanted to get some input before I call them has anyone seen this error before?

Microsoft likes Server Msg 8115, Level 16, State 2  but no Info on state 5
Question by:SherylN
  • 2
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 16856354
>Arithmetic overflow error converting numeric to data type varchar
without seeing the code it will be impossible to suggest something...

Author Comment

ID: 16856485
I can not see the code as well  This is why I threw it to the wind. I am just after some "expert" feelings on this question.

The support for the program suggested re indexing ?????  (I have no Idea why) But before I start this I wanted to see if ALL thought this was a programming problem.

We are tasked with maintaining the Server only.  There is no programming done in this office.  

Accepted Solution

LandyJ earned 750 total points
ID: 16856603
We can't venture a guess without knowing what code is throwing the error.  You'll need to contact the vendor.  If this is the Kronos payroll application...

Customer Support
support@kronos.com or call (800) 394-4357


Author Comment

ID: 16856947
what I thought as well

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

862 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