Data Connectivity
 Crystal Reports Forum : Crystal Reports 9, X, XI, 2008, 2011 : Data Connectivity
Message Icon Topic: Failed to retrieve data from the database. Post Reply Post New Topic
Author Message
nkamp
Newbie
Newbie
Avatar

Joined: 23 Feb 2012
Location: Netherlands
Online Status: Offline
Posts: 1
Quote nkamp Replybullet Topic: Failed to retrieve data from the database.
    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
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Location: Indonesia
Online Status: Offline
Posts: 212
Quote Emir_W Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.

FREE ADVANCED
Crystal Reports Training!

Plus, free bonus PDF cheat sheet! Advanced Crystal Reports Training Give Me Advanced Training!