Skip to Content

CR: Database Connection Error


Hi!

I have developed a report in Crystal Reports 2008, which uses SAP B1 tables.

The report is run from SAP, from the menu: TOOLS -> Preview External Crystal Reports File.

It works well. The data source is a set of Stored Procedures (SQL Server), let's say sp1, sp2, sp3 etc

I have created copies of these SP's , let's call them xsp1, xsp2, xsp3

I want to change the datasource location in my CR from the former sp1 etc, to the new xsp1, etc.

The reason for doing so is to keep an original sp, and make modifications on the new xsp.

I do this from the CR menu: DATABASE -> SET DATABASE LOCATION --> Replace with ---> Update

I did this procedure successfully in the past, but this time CR stubbornly refuses to accept the new xsp's

I get this error message:

Database Connector Error: '22003:[Microsoft][SQL Server Native Client

10.0] [SQL Server] Arithmetic overflow error converting numeric to data

type numeric. [Database Vendor Code: 3621] '

I have no idea what this could mean.

If there were errors in my report, I would not have been able to run it.

Could anyone tell me what the msg could mean?

Thanks

Leon Lai

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 10, 2014 at 02:52 PM

    Hi Leon,

    Moving your post to the B1 forums. It's an OEM ( custom ) build of CR.

    Don

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.