Invalid Numeric Error

[Former Member]

Hello,

My Crystal Reports XI report is getting error message: "Failed to retrieve data from database." I know that something happened with my data source, however I cannot what exactly changed. Here is the error message:

"Failed to retrieve data from database. Details: S1000:[Knowledge Based Systems, Inc.] [Server API][V4.3]SQLExecute: Invalid NUMERIC(2,4) value [18], maximum of [-3] digits left of the decimal [Database Vendor Code: 852]

How do I read this message? Does it specify which value is having an issue? (i.e. invalid numeric(2, 4), value [18]). Any help is greatly appreciated!

Thanks.

[former_member183750]

Get the Midas guys to look at the database documentation and look up error 852 (Database Vendor Code: 852).

Also, Report XI is not enough info. Is is Crystal Reports 11.0.x, 11.5.x or 14.0.x? Depending on that applying a recent Service pack may be an idea...

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter

[Former Member]

I've logged Midas support request on the error.

I have Crystal reports 11.5.10.1263.

Thanks,

[abhilash_kumar]

Hi Andrey,

What database are you reporting against?

Also, what is the datasource:

- table

- stored procedure

- command object

You should search for more info about this error on the database vendor's site as they should have the right info about it.

-Abhilash

[Former Member]

Hi Abhilash,

Thank you for your response. The data sourse is a Table that's coming from Midas database. I'm working with them too, but so far no luck.

Thanks,

[DellSC]

I would open the report in Crystal, go to the Database menu and select "Verify Database".  This will go through and update any field types that might have changed, which should get rid of this error.

-Dell

[Former Member]

Dell,

I tried that. It goes through without a hitch, and says: "Database is up to date". Indicates nothing w/ regards to the error.

Thanks,