Symptom
A publication that contains multiple reports, and is set to return the list of recipients as data, may fail with the following error messages:
"Database Connector" or "Unable to connect: incorrect log on parameters"
Environment
- Crystal Reports 2011
- Business Intelligence 4.0
Reproducing the Issue
- Create a Publication
- Include multiple Crystal reports within it (more than 20)
- Include a Crystal report which returns the recipients as data
- Merge the PDF
- Schedule the Publication
- Intermittently it fails
Cause
The problem happens when a connection to the database used by the report fails for some recipients. The publication retry mechanism attempts to the database again but fails to pass logon credentials for those recipients.
The issue has been identified and logged under Problem Report ID ADAPT01474452
Resolution
This issue has been addressed by Support Package 1
Keywords
ADAPT01474452,Database Connector, Unable to connect: incorrect log on parameters, publication error, publication fails, crystal reports , KBA , BI-RA-CR-DSL , Crystal Reports on Data Semantic Layer , Bug Filed
SAP Knowledge Base Article - Public