Symptom
The following error appears while trying to refresh Crystal Report connecting to XML datasource
"Failed to retrieve data from the database" error
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: ..."
Environment
Crystal Reports 2008
Crystal Reports 2011
secured XML servlet
Reproducing the Issue
- Use XML native driver to create Crystal Report connecting to a servlet that retrieves data in XML format
- Save the report and close Crystal Reports designer
- 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