Salesforce.com as Available Data Source

[Former Member]

Salesforce is showing as an available data source when creating a new report in Crystal Reports, but when I enter the salesforce login information I recieve the error message

"Invalid Argument Provided

Details: Java Server startup failure. Please verify the PATH (JDK), CLASSPATH and IORFileLocation properties in the CRConfig.xml file. In addition, please verify you are using JDK1.4"

Could anyone please provide some help with this? We have used salesforce for a long time but I am new to Crystal Reports.

[Former Member]

That message implies that there's a configuration or installation issue that is preventing the driver from loading; however, it's difficult for me to say what the exact cause of the problem is just from the error message. If you're using Crystal Reports XIR2 and installed the "Crystal Reports Report Pack for salesforce.com", you may want to try uninstalling and re-installing the report pack.

If you're using Crystal Reports 2008, or the problem still exists after reinstalling, please contact our support team:

Please use the following URL below to submit a support request for the issue you are having. The support team will review your issue to determine what type of support you are entitled to and then determine the team or resources you need assistance from. Use the "Email support" option from the "Support for crystalreports.com" section.
http://www.ondemand.com/support/default.asp

Hope that helps,

Charles

[marioquintana]

Hi LeeAnne,

Adding to the re-installation suggestion for the Salesforce.com Driver, you should look into the following items:

1. Confirm you are using Crystal Reports XI R2 and not Crystal Reports XI.

2. Review the system requirements or confirm any prerequisite requirements for the version of your Crystal Reports (XI R2 or 2008) to determine if you have any incompatibility issues that you may need to address. For Crystal Reports 2008 the driver is installed by default but you should continue to read for the configuration of the CRConfig.xml file.

3. After you have uninstalled and reinstalled the u201CCrystal Reports Report Pack for salesforce.comu201D for Crystal Reports XI R2, you should download and install the latest service pack for Crystal Reports XI R2 - Service Pack 5.

You can download the latest service pack for CR XI R2 using the following link:

http://service.sap.com/sap/bc/bsp/spn/bobj_download/main.htm

As for the error message, the CRConfig.xml contains settings for any additional drivers installed for Crystal Reports. In this case, the salesforce.com driver requires access to the u201CDataDriverCommonu201D section of the CRConfig.xml file. The settings contain access to the following parameters: u201CJVMMaxHeap, JVMMinHeap, CacheRowSetSize, QueryBatchSize, SocketTimeout, and UseCacheJoinu201D. All parameters can be configured to use by the Salesforce.com 3.0 driveru201D.

The CRConfig.xml file can be found using a default installation for the following versions:

For Crystal Reports XI R2:

<Install Drive>:Program FilesBusiness Objectscommon3.5java

For Crystal Reports 2008:

<Install Drive>:Program FilesBusiness Objectscommon4.0java

If you would like to know more about configuring these parameters for the Salesforce.com driver for Crystal Reports, please check out the following document called u201CCrystal Reports SalesForce 3.0 Driver Installation Guide.pdfu201D which should come with the installation of the Report Pack, if not you cannot find the document, please use the following URL:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/003fb3b7-7f64-2b10-7fb6-dbff49c0...

Or search access the following URL and then select the u201CBI OnDemand Articlesu201D from the u201CBusiness Intelligence OnDemandu201D section of the main content page.

https://www.sdn.sap.com/irj/boc/ondemand

As for the error message, it references PATH (JDK), CLASSPATH and IORFileLocation within the CRConfig.xml file and these are very important parameters for the Java executable. Below is the u201CHelpu201D from Crystal Reports on the u201CCRConfig.xmlu201D file.

NOTE: You can search for the topic of u201Ccrconfig.xmlu201D which will result in the topic u201CParameter referenceu201D:

Under the "DataDriverCommon" section:

JavaDir

The JavaDir tag contains the directory of your Java executable. If you have multiple versions of the Java Runtime Environment installed, this tag points to the version that you want to use; for example:

<JavaDir>C:appsj2sdk1.4.2in</JavaDir>

Alternatively, the path information may be configured as a user or system environment variable. In this case, if JAVA_HOME is defined as a variable, you can use $ as in this example: <JavaDir>$in</JavaDir>

Classpath

The Classpath tag contains a list of the classpaths to the following .jar files:

CRDBJavaServer.jar

All database-specific JDBC driver .jar files

For the Oracle JDBC driver, for example, classpath to ojdbc14.jar is required.

Alternatively, the classpath information may be configured as a user or system environment variable. If this variable is not defined, it is equivalent to <Classpath>$</Classpath>. Environment variables can also be included in a mixed path, as shown in this example: <Classpath>c:javalibxerces.jar;$"/Business Objects/4.0/bin/CRDBJavaServer.jar";$</Classpath>

When using classpaths with long folder and/or file names that contain spaces, ensure that they are enclosed within quotation marks. For example, "C:Program FilesBusiness ObjectsCommon4.0inCRDBJavaServer.jar".

IORFileLocation

The IORFileLocation tag provides a temporary directory for use by the JDBC driver. This location must exist and be accessible by the system; otherwise, the driver will fail to work.

JavaServerTimeout

The JavaServerTimeout tag specifies the maximum amount of time your Java server will continue processing your request until it shuts itself down. The default value is 1800 seconds (30 minutes).

JVMMaxHeap

The JVMMaxHeap tag specifies the maximum amount of heap space that the JVM can allocate for running the Java server. This tag is set to 64 MB of heap by default. Change this number to a higher value if you need to process a large amount of data.

JVMMinHeap

The JVMMinHeap tag specifies the minimum amount of heap space that the JVM can allocate for running the Java server. This tag is set to 32 MB of heap by default.

NumberOfThreads

The NumberOfThreads tag specifies the number of concurrent instances that can be run. This tag is set to 50 by default.

In short, you will need to confirm you have a Java Runtime Environment installed and have the "Path" parameter pointing to the installation location of this. The classpath which points to the location of the jar files which are needed as java functional libraries. I've attached a copy of my CRConfig.xml file for Crystal Reports XI R2 and Crystal Reports 2008 SP1.

I hope this helps and as mentioned from Charles, if this doesn't work, email the support team for crystalreports.com.

Thanks,

Mario Quintana