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.ReportApp Server.Dat aSetConver sion CrystalDecisions.CrystalRe ports.Engi ne.DataSou rceExcepti on: 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\LOCAL S~1\Temp\{ EB6E3639-D 168-4453-8 D12-70D4FD B65520}.rp t:
Database Connector Error ---> System.Runtime.InteropServ ices.COMEx ception (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\LOCAL S~1\Temp\{ EB6E3639-D 168-4453-8 D12-70D4FD B65520}.rp t:
Database Connector Error
at CrystalDecisions.ReportApp Server.Con trollers.R eportSourc eClass.Exp ort(Export Options pExportOptions, RequestContext pRequestContext)
at CrystalDecisions.ReportSou rce.EromRe portSource Base.Expor tToStream( ExportRequ estContext reqContext)
--- End of inner exception stack trace ---
at CrystalDecisions.ReportApp Server.Con vertDotNet ToErom.Thr owDotNetEx ception(Ex ception e)
at CrystalDecisions.ReportSou rce.EromRe portSource Base.Expor tToStream( ExportRequ estContext reqContext)
at CrystalDecisions.CrystalRe ports.Engi ne.FormatE ngine.Expo rtToStream (ExportReq uestContex t reqContext)
at CrystalDecisions.CrystalRe ports.Engi ne.FormatE ngine.Expo rt(ExportR equestCont ext reqContext)
at CrystalDecisions.CrystalRe ports.Engi ne.ReportD ocument.Ex port(Expor tOptions options)
at VGOVProcessPOBPO.VGOVPOBPO .CreatePDF (String strDocNo, Int32 iFiscal_yr, Int32 iDoc_dept, String strHdrKey, String strPrintType, ReportDocument MyReport)
CrystalDecisions.ReportApp
Failed to retrieve data from the database.
Failed to export the report.
Error in File C:\DOCUME~1\kpmgvgov\LOCAL
Database Connector Error ---> System.Runtime.InteropServ
Failed to retrieve data from the database.
Failed to export the report.
Error in File C:\DOCUME~1\kpmgvgov\LOCAL
Database Connector Error
at CrystalDecisions.ReportApp
at CrystalDecisions.ReportSou
--- End of inner exception stack trace ---
at CrystalDecisions.ReportApp
at CrystalDecisions.ReportSou
at CrystalDecisions.CrystalRe
at CrystalDecisions.CrystalRe
at CrystalDecisions.CrystalRe
at VGOVProcessPOBPO.VGOVPOBPO
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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