Print Page | Close Window

Failed to retrieve data from the database.

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15700
Printed Date: 28 Apr 2024 at 1:58pm


Topic: Failed to retrieve data from the database.
Posted By: nkamp
Subject: Failed to retrieve data from the database.
Date Posted: 23 Feb 2012 at 4:22am
Hello,

We have the application 'Lodestar' for some years.
The frond-end is ASP and the database is Oracle 9. Lodestar has its own backend language "Rules language".
The crystal version is 10

Now we haven a new version of Lodestar with ASP and ASP.NET, Oracle 11g and Crystal 11.

But when we run some reports with the new version we get the error "Failed to retrieve data from the database. Details: [Database Vendor Code: 1652 ] Failed to retrieve data from the database." When I google on this error then it seems that it has something todo with tablespace.
We have changed the tablespace volume from 32Gb to 100Gb, but we still get this error.

Has anybody an idea what the cause could be?

Error
:
<REPORT_ERROR>
  <REPORT_NAME>G_GV_DEALLIST</REPORT_NAME>
  <REPORT_TYPE>CRYSTAL</REPORT_TYPE>
  <MESSAGE>Failed to retrieve data from the database. Details: [Database Vendor Code: 1652 ] Failed to retrieve data from the database. Error in File G_GV_DEALLIST{54DEAA95-37B9-495B-B7E8-76BC575FA75F} {A3D1B090-322B-47D3-A84F-F003FF482C48}.rpt: Failed to retrieve data from the database. Details: [Database Vendor Code: 1652 ]</MESSAGE>
  <STACK_TRACE>at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options) at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType) at Lodestar.crComGen.crCrystalNet.crAppNet.crGenerateReport(String connectstr, String qualifier, String guid, String altconn, String login, String url, StreamWriter sw)</STACK_TRACE>
  </REPORT_ERROR>




-------------
Thanks in advance.

With regards,

Nico



Replies:
Posted By: Emir_W
Date Posted: 23 Feb 2012 at 8:07am
Try to open the CR file using CR app and run it with the same params (if any).



-------------
Emir W



Print Page | Close Window