Link to home
Start Free TrialLog in
Avatar of ams42870
ams42870

asked on

Crystal Report fails to export after moving to Oracle 10

Moved database from Oracle 9 to 10 Recently.  Report was fine before the move. The process is .net, it retrieves documents to process into a table.  Then each record is processed.  Crystal is called to create a pdf and export it to a local drive.  The application server has not been modified.  Here is the error:

 CrystalDecisions.ReportAppServer.DataSetConversion CrystalDecisions.CrystalReports.Engine.DataSourceException: Database Connector Error: ' [Database Vendor Code: 22835 ]'
Failed to retrieve data from the database.
Failed to export the report.  

Error in File C:\DOCUME~1\kpmgvgov\LOCALS~1\Temp\{EB6E3639-D168-4453-8D12-70D4FDB65520}.rpt:
Database Connector Error ---> System.Runtime.InteropServices.COMException (0x800002C3): Database Connector Error: ' [Database Vendor Code: 22835 ]'
Failed to retrieve data from the database.
Failed to export the report.

Error in File C:\DOCUME~1\kpmgvgov\LOCALS~1\Temp\{EB6E3639-D168-4453-8D12-70D4FDB65520}.rpt:
Database Connector Error
   at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
   at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
   --- End of inner exception 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.FormatEngine.Export(ExportRequestContext reqContext)
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Export(ExportOptions options)
   at VGOVProcessPOBPO.VGOVPOBPO.CreatePDF(String strDocNo, Int32 iFiscal_yr, Int32 iDoc_dept, String strHdrKey, String strPrintType, ReportDocument MyReport)
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
According to Oracle this error Is

Buffer too small for CLOB to CHAR or BLOB to RAW !!!

Do you have this kind of data on the report ? You may need to update also your .NET drivers