function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
WestwindWestwind 

Failure to connect via Crystal Reports

We're evaluating Crystal Reports and CrystalReports.com for generating reports from SF objects. I have properly installed CrystalReports.com within SF. I've downloaded and installed (separately) both CR XI (with SF Driver 3.0) and 2008 (without driver per CR's tech support) for developing reports.
 
When I attempt to Create New Connection/Salesforce.com, a pop-up window appears pointed to www.salesforce.com and prompting for my SF userID and password. I have several valid SF accounts. No matter which account I try, CR returns a "Login error: invalid UserID or Password."
 
After two hours waiting to talk to a CR tech support person, they had virtually nothing useful to say ... basically they told me to get an SAP/BO tech support account which requires submitting an application. Their forums were impossible to navigate. CR looks like a great solution, but I'm underwhelmed with their tech support.
 
Is anyone using CR XI or 2008 to access SF objects? If so, any suggestions/advice re: connecting to SF?
 
Thanks,
 
Mark
 
Best Answer chosen by Admin (Salesforce Developers) 
JoshAdvantixJoshAdvantix

Good news, there is a fix pack that can be installed after upgrading to Crystal 2008 SP2. To see the thread at sap.com visit: https://forums.sdn.sap.com/thread.jspa?threadID=1431217&tstart=0

 

To download the fix pack visit: https://smpdl.sap-ag.de/~sapidp/012002523100015097962009E/cr2008_fp22.exe

 

All Answers

Gemini@WorkGemini@Work
Try appending your security token to the end of your password.
dmchengdmcheng
Yes, you need to append your security token as Gemini said.  If you're not sure where that is in Salesforce, go to Setup -> My Personal Information -> Reset Security Token and SF will send it to you in an email.
1975Nova1975Nova

I have tried the suggested fix by appending my password with the security token but it replaces one error with another.

 

Logon failed.

Details: Unexpecteed error; nested exception is:

org.xml.sax.saxexception: invalid element in com.sforce.soap.partner.loginresult - metadataServerUrl

 

Am I using the wrong URL of www.salesforce.com

 

dmchengdmcheng
What version of Crystal Reports are you using?
1975Nova1975Nova

Crystal Reports 2008 CR Developer version 12.2.0.290 Product Type: Full

 

Thanks

JoshAdvantixJoshAdvantix

I can confirm that I too am having the same error with Crystal Reports 2008 CR Developer version 12.2.0.290 connecting to Salesforce.com.

 

This is the built in connector.

 

The last time this worked was 9/9/2009. Only variables that I *know* have changed is the recent service pack 2 was applied to Crystal. 

 

Has anyone solved this or gotten the current version of Crystal 2008 with all of the latest service packs to connect to Salesforce.com?

dmchengdmcheng

Have you tried posting a note on the SAP Crystal Reports forum?  I did some searching there but didn't find any obvious solution for what you're describing.

 

http://forumsa.sdn.sap.com/forum.jspa?forumID=300

JoshAdvantixJoshAdvantix

All,

 

Here is what I found. The issue relates to service pack 2 for Crystal Reports 2008. By downgrading (i.e. uninstalling/ reinstalling) to Crystal 2008 with service pack 1 everything is working fine.

 

Forums at SAP indicate this is a known issue and that a patch is being worked on. Nothing more at this point. 

 

Thanks,

Josh

 

BKMatTWMBKMatTWM

Just an FYI - I installed SP2 today and received the same errors.  I scoured the Crystal forums for two hours to no avail.  This problem still exists with no known patch as far as I can tell...

 

Does anyone know of a fix other than downgrading?

1975Nova1975Nova
I took the advice to uninstall and reinstall to SP1 and it works like a charm... I'll wait to download SP2 until they get the problem fixed but I have not heard of a fix for SP2 yet.
deborahmadeborahma

I just upgraded to SP2, and I'm now receiving the same error, as well. Anyone find a solution to this? Looks like it's been a few months.

 

I'd prefer not to downgrade back to SP1 because I was under the impression that SP2 was required for connecting to objects with multiple parents (per this page: http://forumsa.sdn.sap.com/thread.jspa?messageID=8354805#8354805). 

TBoneJCSITBoneJCSI
I'm getting the same problem here: Same version of CR, same error message (yes, I added the security token).  Any idea if this is going to get a fix soon?
JoshAdvantixJoshAdvantix

Good news, there is a fix pack that can be installed after upgrading to Crystal 2008 SP2. To see the thread at sap.com visit: https://forums.sdn.sap.com/thread.jspa?threadID=1431217&tstart=0

 

To download the fix pack visit: https://smpdl.sap-ag.de/~sapidp/012002523100015097962009E/cr2008_fp22.exe

 

This was selected as the best answer