i-net Crystal-Clear

Known Problems

Aliases with space characters in it are not supported

Description

i-net Crystal-Clear does not support aliases that contains one or more space characters.

Solution

Remove the space character from the alias. You can do this in the Crystal Reports Designer dialog “Set Alias” (menu Database → Set Alias).

Out-of-memory conditions with JavaWebServer

Description

When rendering large reports, sometimes a out-of-memory exception is throws followed by a “null pointer exception”.

Solution

Increase the amount of memory available to the JavaWebServer by editing vmargs.txt located in the JavaWebServer root directory. 256MB (the option: -Xmx256M) is recommended.

Connection string for Oracle databases

Description

When trying to connect to an Oracle database, you get the following exception:

The DB connection to "jdbc:inetora:<hostname>:1521:ORCL" failed (see crystalclear.properties)

Solution

Please append the following parameter to the connection URL: host=<hostname>:1521:<SID>. The example: &dll=pdsora7.dll&host=host1:1521:host1db&user=scott&password=tiger&schema= assumes that oracle runs on host1, port 1521 and has the SID host1db. You can use the oracle netconfig or easyconfig to find out the required parameters.

Oracle Stored Procedures within a package

Description

For a report designed with Crystal Reports 8 or 8.5 i-net Crystal-Clear reads the package and schema name incorrectly, the values are switched.

Solution

If you have a package REF_PACK and are logged in as user SP2, then please append this at the end of the URL:

&user=SP2&schema=SP2&catalog=REF_PACK

Please enable the i-net Crystal-Clear logging. You should see something like: “schema, catalog, sprocedure: SP2, REF_PACK, Procedure” in the log. Please check if the procedure “Procedure” exists in REF_PACK.

Signed applets on MacOS

Description

The Internet Explorer emmits the message:

com.apple.mrj.JManager.JMAppletSecurityOld.checkPackageAccess(Compiled Code)

and then stops operating.

Solution

The MRJ JVM does not understand standard signed applets. You must use the old JDK1.1 javakey to sign the applet yourself. Please see this technology note for details.

Please also note this technical java Q&A.

To prevent the crash we generally use sun.net.www.protocol.http.HttpURLConnection on this platform.

Oracle 9i Version 9.0 and stored procedures

Description

Oracle error: PLS-00306. In combination with the oracle JDBC driver, the database version 9.0 does not support stored procedures.

Solution

Upgrade to Oracle 9.2 (or higher), downgrade to Oracle version 8 or use the JDBC driver i-net Auguro to connect to the 9.0 database.

Tomcat 4.1.29 is broken

Description

Tomcat 4.1.29 has a serious bug in that it changes the content type from application/crystalclear to application/crystalclear; charset=<nonsense>. It modifies the content type in all cases, even if you return an HTML page that contains the meta tag that specifies text; charset=UTF-8. This means that Tomcat 4.1.29 is not usable.

Solution

Please use Tomcat 4.1.27 or Tomcat 5.x instead (http://tomcat.apache.org/).

N of M fields and Total Page fields together with “can grow”

Description

The field will be can grow but the including section will not resize. The effect can be that the field to overlap the section.

Solution

This is a limit of the rendering engine. Resize the section in the designer to the needed size.

Using HTML Text Interpretation with <img> tags, there can be rare layout problems

Description

With especially large images, some images will not be embedded in the report with an element with HTML text interpretation. Also, text directly after an image combined with line break tags sometimes is positioned too far below the image.

Solution

With large images, either scale them down using the width / height attributes of the img, or scale down the images themselves - images larger than a report page are not supported.

With the layout problems, make sure you start a new paragraph with the p tag right after the image.

Rotation of elements with HTML text interpretation with IMG tags

Description

HTML text interpreted elements with embedded images will look strange when rotated, since i-net Crystal-Clear does not support rotation of images at this point.

Solution

At this point there is no workaround for this issue - it is not possible to correctly rotate an element with an embedded image in HTML text interpretation.

See Also:


i-net software strives to provide accurate product documentation. Please give us your feedback using the form below.
NOTE: This form is for documentation feedback only. For technical assistance, please send an email to crystalclear@inetsoftware.de.

 

© Copyright 1996 - 2010, i-net software; All Rights Reserved.