1732693 - The system cannot find the path specified.at CrystalDecisions.ReportAppServer.Controllers.ReportSource Class.Export when using Datadirect XML ODBC driver 5.3

SAP Knowledge Base Article - Public

1732693 - The system cannot find the path specified.at CrystalDecisions.ReportAppServer.Controllers.ReportSource Class.Export when using Datadirect XML ODBC driver 5.3

Symptom

  • Visual Studio .NET application running a report report that uses Data Direct drivers to connect to an XML data source via ODBC
  • When two users attempt to load the same report at about the same time, the process locks and throws the following exception:

The system cannot find the path specified.at CrystalDecisions.ReportAppServer.Controllers.ReportSource Class.Export(ExportOptions pExportOptions, requestContext pRequestContext) 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.ExportToDisk (ExportFormatType formatType, String fileName) at ReportGenerator.ReportGenerator.exportReport(String xmldir, String crname, String pdfname, String termid, Boolean debug)

ODBC trace shows the following:

IAG [HY000] [Crystal Reports][ODBC XML driver][XML][Closed Integrator Base]A provider error occurred while calling the underlying provider.
IOpenRowset::OpenRowset[Closed XML ADO Provider] returned 80004005[Could not open table (Company)]. (-2147467259)

DIAG [HY000] [Crystal Reports][ODBC XML driver][XML][Closed Integrator Base]A provider error occurred while calling the underlying provider.
IOpenRowset::OpenRowset[Closed XML ADO Provider] returned 80004005[[XML Parser] The process cannot access the file because it is being used by
another process.

 

Environment

  • Crystal Reports for Visual Studio 2010
  • Visual Studio 2010
  • Data Direct ODBC driver version 5.3

Reproducing the Issue

  1. Create  an ODBC datas ource pointing at an XML file
  2. Create a report on the above
  3. Create a Windows application in Visual Studio 2010
  4. Use Crystal Reports for Visual Studio 2010 SDk to load and run the report
  5. Get two users to run the above report at about the same time 

Cause

  • This is a known issue with the Data Direct drivers, version 5.2

Resolution

  • Upgrade the Data Direct drivers to version 6.1 or 7.0
  • Note that these drivers are only available from Data Direct

See Also

  • Reference ADAPT01610636

Keywords

CR2010 2010 CR4VS2010 CR4VS VS2010 NET2010 Crystal Reports for .NET Framework 4.0 crforvs 13 progress xsd progres , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , Problem

Product

SAP Crystal Reports all versions ; SAP Crystal Reports, developer version for Microsoft Visual Studio ; SAP Crystal Reports, version for Visual Studio .NET 2008