asked on

How to troubleshoot bad data from a sql query

Hello,

Running a sql query using a tool called query manager in people soft yields the error below. However, if I run this directly out of query analyzer in Sql server 2008 no problem. Note that the query manager is going off of our sql server 2008 data base.

[Microsoft]
[SQL Server Native Client 10.0]
Numeric value out of range
[Microsoft]
[SQL Server Native Client 10.0]
Numeric value out of range
[Microsoft]
[SQL Server Native Client 10.0]Numer
Failed SQL stmt

Any suggestions would be appreciated,

Nigluc

radcaesar

I believe it is because of the date field in your table. And its a common problem with your people soft I think.

http://peoplesoft.ittoolbox.com/groups/technical-functional/peopletools-l/db2-error-numeric-value-out-of-range-675579

But, I was sure It is not data issue.

Brock

ASKER

Hi radcaesar,

I have eliminated all date and numeric fields. I still can't find it. I will rebuild the query one by one to find the offending data in the tool the client runs their query from.

Thank you,
Nigluc

ASKER CERTIFIED SOLUTION

Alpesh Patel

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Brock

ASKER

Hi PatelAlpesh,

I have done len on the numerics fields to see if there is a field that is exceeding the value.

I will investigate more closely next week.

Thank you,
Nigluc

Brock

ASKER

Sorry I took so long to reply,
Nigluc