Skip Headers
Oracle® Enterprise Data Quality for Product Data Oracle DataLens Server Administration Guide
Release 11g R1 (

Part Number E29138-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

7 Troubleshooting

This chapter describes common problems and solutions when working with EDQP and includes:

Web Pages Do Not Render

Messages similar to the following may displayed in your browser when logging in to an Oracle DataLens Server:

<div id="pt1:np1" class="xdc xhq" theme="dark 
   <div id="pt1:ptpsl2::c" role="navigation" 

This occurs when the Oracle DataLens Server is under a heavy processing load and its resources (CPU and memory) are near the limit, these Web pages may not render correctly. Oracle DataLens Servers should be sized to ensure that there are sufficient resources for correct performance.

Unable to Resolve Server Hostname

If the Oracle DataLens Server was installed with domain name system (DNS) name only and not the fully qualified path and it cannot be resolved without the fully qualified name, then you must add an entry in the host file on the client machine. Typically, the host file is located in:


Unable to Obtain a Database Connection Lock

The inability of your Oracle DataLens Server to obtain a database connection typically occurs when you are running a large number of data lens and DSA jobs. Your database connection cannot obtain a lock because there are no more available in the Web Logic Server PDQRepository connection pool using the default settings.

Surrounding text describes pdqconpool.png.

You must adjust the following PDQRepository settings to the values shown:

Surrounding text describes pdqconpool1.png.

For more information about changing these settings, see Oracle Fusion Middleware Oracle WebLogic Server Administration Console Online Help 11g Release 1 (10.3.6) at

Memory Allocation Problems on Clients

If memory allocation problems are experienced on client machines, an additional environment variable must be created for use by the EDQP Java Web Start client.

To add the necessary system environment variable and invoke it:

  1. Right-click Computer, and then select Properties.

  2. Click Advanced system settings.

  3. Click Environment Variables.

  4. From the System variables section, click New.

  5. Enter JAVAWS_VM_ARGS as the Variable name.

  6. Enter the Variable value to set the memory allocation values for the client using the following syntax:

    -Xms256m -Xmx2048m

    Where 256 is the minimum and 2048 is the maximum.

    Set these minimum and maximum memory values as appropriate for your client system.

    Surrounding text describes memsysvar.jpg.
  7. Click OK to close all dialogs.

  8. Invoke the increased memory allocation for the EDQP client applications, by initiating a connection and downloading the client software by browsing to:


    Where server is the hostname of the Oracle DataLens Server.


    If you have setup a different port number for your application server other than 2229, you must use that port number in the following URL when browsing to the Oracle DataLens Server to download the client applications.

    The application download and verification begins.


    If you receive a File Download message indicating that the .jnlp file is not associated with a program, you do not have the supported JRE installed. Click Cancel, install the supported JRE, and then return to this step.

    After the verification completes, the installation begins. Enterprise DQ for Product files are digitally signed by a trusted source and a security warning is displayed:

Problems Starting a Non-Administration Oracle DataLens Server

Two ports on the Administration Server need to be accessible from the Oracle DataLens Servers. These are

The following are the steps needed (on Windows) to open up these ports on the firewall if needed.

From the Windows Control Panel, start the Windows Firewall.

Surrounding text describes image070.jpg.

Select the Allow a program through the Windows Firewall link.

Surrounding text describes image071.jpg.

Select the Add port… button.

Surrounding text describes image072.jpg.

Enter PDQCMS Configuration Port in the Name: field and 1527 in the Port number: field.

Surrounding text describes image073.jpg.

Click OK.

Click the Add port… to create a second port.

Surrounding text describes image074.jpg.

Enter PDQCMS in the Name: field and 2229 in the Port number: field.

Surrounding text describes image075.jpg.

Click OK and the Oracle DataLens Servers will be able to communicate with the Administration server.