SalesForce and Crystal error
When I try to run a report created with Crystal 2008 V188.8.131.521 that uses data from SalesForce, I get the following two errors.
- Failed to retrieve data from the database.
- Database Connector Error: 'Unexpected'
This report also contains multiple subreports that also pull from SalesForce and when I run those by themselves, they work just fine. The query/report on the main report that errors out in Crystal runs just fine in SalesForce.
I have reviewed some postings about changing the CRConfig file and those changes have not helped fix the error.
Specifics for my computer:
Win 7 - 64-bit
465 GB free HD space
Crystal Reports 2008 v184.108.40.2061*
* I have also tried running the report a Win 7 - 32bit with 4GB memory & 297 GB free HD space using CR 2011 and get the same error.
All reports reside on a network server.
I have attached the CRconifg file. Is there something else that I need to change in here like a java path?
After reading some of the posts, I contacted our SalesForce IT team and they informed me they renamed some database fields that are in my report. I remapped the fields and now the report works.