SAP Knowledge Base Article - Public

1219571 - Error: "Logon failed 'Schema file is invalid'" when reporting off web service

Symptom

  • Using the XML driver to report off a web service that returns an ADO.NET dataset.
  • Error message appears:

"Logon failed.

Details: Schema file is invalid

error: Element schema@http://www.w3.org/2001/XMLSchema not found".

Cause

This is a known issue with Crystal Reports XI.

The issue has been identified and tracked under ID ADAPT00525719.

Resolution

To workaround this issue, use one of the following options:

Managed Assembly

  1. Build a managed assembly that exposes a public method that returns a dataset or 'DataTable' object.
  2. Consume the web service and then return the appropriate object.
  3. In the Crystal Reports Designer, connect to the managed assembly using the '.NET Data Provider' and the report off the method in the managed assembly.

- OR -

Schema

  1. Retrieve the schema (.xsd) for the ADO.NET dataset and then create a report based on the schema file.
  2. In a .NET application, retrieve the dataset from the web service and then pass it to the report.

See Also

For information on implementing the managed assembly option, refer to the technical paper Using the .NET DataSet Provider In Crystal Enterprise.

For information on using reports based on ADO.NET datasets, refer to the following:

Keywords

ELEMENT SCHEMA XMLSCHEMA NOT FOUND XML DRIVER ADO.NET ADO .NET DOTNET DOT NET Crystal Reports Web Service Reporting .NET Dataset Error Message , c2018453 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2