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

Posted on 2006-06-07
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
    LVL 142

    Expert Comment

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

    Author Comment

    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.  
    LVL 7

    Accepted Solution

    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 or call (800) 394-4357


    Author Comment

    what I thought as well

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how the fundamental information of how to create a table.

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now