cancel
Showing results for 
Search instead for 
Did you mean: 

CR: Database Connection Error

leon_laikan
Participant
0 Kudos


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

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi Leon,

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

Don