Failed to Retrieve Data from Database

[nlaliberte]

I'm using Crystal XI with an OLE DB connection to a SQL server. I'm getting the 'Failed to Retrieve Data from Database: Arithmetic overflow error converting numeric to data type varchar' error but the odd thing is I can still run the proc just fine in SQL Management Studio. The error only fires when I run the report in Crystal, and only rarely (i.e. not for every set of parameters). The data source has been 'Verified' and like I said it runs properly 99% of the time.

Does anyone have any debugging tips here? I don't even know where to start looking...

 

[jdemmi]

When you get the error pay close attention to the record set to be retrieved. Perhaps there is an offending value in of the records. If you slowly constrain the data returned you should eventually be able to find the offending value(s), if any. From there you can address the issue.

-- Jason
"It's Just Ones and Zeros

 

[Turkbear]

Hi,
Also, look at the Sql that Crystal creates to access the data...It may be doing an implicit conversion that somehow fails when it hits the database...For instance, do you have any selection criteria that treats a number like a string?





To Paraphrase:"The Help you get is proportional to the Help you give.."