Crytal Reports and Salesforce Error message

[Former Member]

I have the following applications loaded

Java: Java Plug-in 1.6.0_07

Using JRE version 1.6.0_07 Java HotSpot(TM) Client VM

Crystal Reports: Crystal Reports 2008 12.0

Driver: Salesforce Driver 3.0

Everytime I try to connect crystal reports thru salesforce I get the following error message:

Invalid argument provided, java server startup failure, verify the path (jdk), classpath,and IORfilelocation in the crconfig.xml file, In addition verify you are using JDK 1.5

I have tried backing up the Crconfig.xml file, and then deleting it, then deleting any old drivers I had and loading the SFDC 3.0 Driver, that did not seem to work. I also have removed crystal reports and downloaded again, that didnt seem to work either. I have also searched this forum for similar issues to no avail

Here is what the CRconfig.xml file looks like on my machine (note - I took out the product key code for security reasons)

<?xml version="1.0" encoding="utf-8" ?>

<CrystalReportEngine-configuration>

<reportlocation>../..</reportlocation>

<timeout>10</timeout>

<ExternalFunctionLibraryClassNames>

<classname />

<classname />

</ExternalFunctionLibraryClassNames>

<keycode>keycode</keycode>

<Javaserver-configuration>

<DataDriverCommon>

<JavaDir>C:\Program Files\Business Objects\javasdk\bin</JavaDir>

<Classpath>C:\Program Files\Business Objects\Common\4.0\java/lib/crlovmanifest.jar;C:\Program Files\Business Objects\Common\4.0\java/lib/CRLOVExternal.jar;C:\Program Files\Business Objects\Common\4.0\java/lib/CRDBJDBCServer.jar;C:\Program Files\Business Objects\Common\4.0\java/lib/CRDBXMLServer.jar;C:\Program Files\Business Objects\Common\4.0\java/lib/CRDBJavaBeansServer.jar;C:\Program Files\Business Objects\Common\4.0\java/lib/external/CRDBXMLExternal.jar;C:\Program Files\Business Objects\Common\4.0\java/lib/external/log4j.jar;C:\Program Files\Business Objects\Common\4.0\java/lib/CRDBSForceServer.jar;C:\Program Files\Business Objects\Common\4.0\java/lib/external/CRDBSForceExternal.jar;$</Classpath>

<IORFileLocation>$</IORFileLocation>

<JavaServerTimeout>1800</JavaServerTimeout>

<JavaServerStartupTimeout>30</JavaServerStartupTimeout>

<JVMMaxHeap>64000000</JVMMaxHeap>

<JVMMinHeap>32000000</JVMMinHeap>

<NumberOfThreads>100</NumberOfThreads>

</DataDriverCommon>

<JDBC>

<CacheRowSetSize>100</CacheRowSetSize>

<JDBCURL />

<JDBCClassName />

<JDBCUserName />

<JNDIURL />

<JNDIConnectionFactory />

<JNDIInitContext>/</JNDIInitContext>

<JNDIUserName>weblogic</JNDIUserName>

<GenericJDBCDriver>

<Default>

<ServerType>UNKNOWN</ServerType>

<QuoteIdentifierOnOff>ON</QuoteIdentifierOnOff>

<StoredProcType>Standard</StoredProcType>

<LogonStyle>Standard</LogonStyle>

</Default>

<Sybase>

<ServerType>SYBASE</ServerType>

<QuoteIdentifierOnOff>OFF</QuoteIdentifierOnOff>

<DriverClassName>com.sybase.jdbc2.jdbc.SybDriver</DriverClassName>

<StoredProcType>Standard</StoredProcType>

<LogonStyle>MySQL</LogonStyle>

</Sybase>

</GenericJDBCDriver>

</JDBC>

<XML>

<CacheRowSetSize>100</CacheRowSetSize>

<PreReadNBytes>4096</PreReadNBytes>

<MaxCacheXMLSize>153600</MaxCacheXMLSize>

<XMLLocalURL />

<SchemaLocalURL />

<XMLHttpURL />

<SchemaHttpURL />

<RepositoryPath>C:\Program Files\Business Objects\Common\4.0\java/lib/external</RepositoryPath>

<ExternalNamespace>C:\Program Files\Business Objects\Common\4.0\java/xsd/wsdl.xsd;C:\Program Files\Business Objects\Common\4.0\java/xsd/wsdl_encoding.xsd</ExternalNamespace>

<SocketTimeout>60000</SocketTimeout>

</XML>

<JavaBeans>

<CacheRowSetSize>100</CacheRowSetSize>

<JavaBeansClassPath />

<CallBackFunction>CrystalReportsLogoff</CallBackFunction>

</JavaBeans>

<SForce>

<CacheRowSetSize>100</CacheRowSetSize>

<QueryBatchSize>2000</QueryBatchSize>

<SocketTimeout>600000</SocketTimeout>

<UseProxy>FALSE</UseProxy>

<ProxyAddress />

<ProxyPort />

<BatchLookupCacheJoinSize>200</BatchLookupCacheJoinSize>

</SForce>

</Javaserver-configuration>

</CrystalReportEngine-configuration>

Any help would be greatly appreciated!

[ted_ueda]

So have you verified that the Java Server is starting up using Java version 1.5?

Use [Process Explorer|http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx] to make sure the java.exe is using the correct version of the Java JVM.

The CRConfig.xml is used to specify which JVM to use.

Sincerely,

Ted Ueda

[Former Member]

I was able to disable my firewall, and then I tried to reconnect to crystal reports. When I did this, I was prompted for my logon credentials and I was able to successfully connect to crystal reports and this issue was resolved, thanks.

Fahad

[aasavaribhave]

Hi,

This forum is dedicated to Custom JavaJRC Applications for Crystal Report. From your description it looks like you are facing the issue in Crystal Report Designer. If that is correct then please post this thread to the following forum.

This is Crystal Report Design Support forum and includes discussion on DB connectivity as well.

Thanks

Aasavari