SAP Knowledge Base Article - Public

1738336 - Crystal Reports fails to connect to XML datasource

Symptom

The following error appears while trying to refresh Crystal Report connecting to XML datasource

"Failed to retrieve data from the database" error

 failed.jpg

followed by "Cannot determine the queries necessary to get data for this report. Details: Cannot open file Server returned HTTP response code: 401 for URL: ..."

 cannot.jpg

Environment

Crystal Reports 2008

Crystal Reports 2011

secured XML servlet

Reproducing the Issue

  1. Use XML native driver to create Crystal Report connecting to a servlet that retrieves data in XML format
  2. Save the report and close Crystal Reports designer
  3. Reopen the report and refresh it 

Cause

Crystal Reports is not prompting for user's credentials and attempts to log in to the datasource using an empty password

Resolution

This problem identified as product defect and escalated under ADAPT01645471

Keywords

KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011