Failed to retrieve data from the database. Database Vendor Code: 2812
We have upgraded the Crystal Reports 9 to 2008 and upgraded the runtime
to 12.05 on our web server. After that we began getting random errors:
Failed to retrieve data from the database.
Details: [Database Vendor Code: 2812]
During a day we have about 1-5 users running Crystal Report at
the same time. If the number of users is greater than 3 then one of them gets
2812 error (not each time but randomly). If error appears then this user will
get this error until the user logout from the web site. We’ve made a stress
test for 6 connections/reports. Once in a while (not every time) one of them
ends with 2812 error code and other 5 are finished fine at that time and
continue working fine after that.
To solve this problem we upgraded to Crystal Report 13 runtime (for
Visual Studio) and the error still exists with the same behavior.
The error happened at fourth line:
crExportOptions.DestinationOptions = crDiskFileDestinationOptions;
crExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
crExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
We are recording the parameters, *.rpt name, output file name and
they are looking fine. We have about 1000 reports in a day for 200 users and 50
random errors for 10 users. We are using third party SSCSDK80.dll for custom
graphics but still getting error with original one.
Any help would be really appreciated.
CR9 runtime is taking database name from *.rpt file even if ConnectionInfo.DatabaseName has a different value.
In CR12 and CR13 runtime is always using the ConnectionInfo.DatabaseName value and ignoring the database name from *.rpt file.
That's what we have in our environment. This could not be true in all of the cases.
Thanks everybody for your help!