2502573 - How to return the error description from the database client/server using Crystal reports for Visual Studio

Symptom

In Crystal for Visual Studio C# API we are unable to receive the error description raised with Raiserror in the report's stored procedure.

Environment

Crystal Reports for Visual Studio SP 20 and earlier
Businessobjects .NET
Crystal Reports Server .NET
Crystal Reports Server Embedded ( OEM ) .NET

Reproducing the Issue

Please take a look at description

Cause

The CL187526 mentioned “As part of the initiative for better error handling CRPE clients want to expose the native errorcode of the vendor, but they do not want to expose the native error message as this might contain information that could be used to attack the network on which the database resides.”

Resolution

This ability has been enabled again in Crystal Reports for Visual Studio SP 21 with the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\DatabaseOptions - String value = "ReturnVendorError" = "Yes"

Checking with R&D to see if this change will migrate into all .NET Packages for BOE, CRS and CRSE .NET SDK.

For a complete list of registry key available see the Master KBA:

2165260 - *** Master KBA *** List of Registry Keys used in Crystal Reports, Crystal Reports for Visual Studio and BOE 4.x .NET SDK to fix, change or correct behavior.

Keywords

cr for vs, ReturnVendorError, raiseerror, , KBA , BI-RA-CR-SDK , SDK related, including Java/.NET etc. , Problem

Product

SAP Crystal Reports, developer version for Microsoft Visual Studio