Fix (APAR):                IZ08025

Status:                    Fix

Product:                   WBI

Release:                   6.0.2.3

Operating System:          All operating systems

Supersedes Fixes:          

Pre-requisite Fixes:       

Exclusive-requisite Fixes: 

CMVC Defect:               IZ08025

Byte size of APAR:         3155470

Date:                      2008-01-17

Abstract:                  Query API: ORA-00918: column ambigously defined if a query specifies order clause and threshold and columns with the same name

Description/symptom of problem:

If you define a query with an order clause and a threshold, and if you use the same view name more than once regardless if 
this column name is defined in different views, an error is raised by the Oracle database: ORA-00918: column ambigously defined.

Example:
If you specify the following input parameters for the query API
select clause: "PROCESS_INSTANCE.NAME, PROCESS_ATTRIBUTE.NAME"
order clause : "PROCESS_INSTANCE.NAME"
threshold    : 10
then a query similar to the following will be generated and sent to the Oracle database.
SELECT * FROM (SELECT PI.NAME, PA.NAME FROM PROCESS_INSTANCE PI, PROCESS_ATTRIBUTE PA ... ORDER BY PI.NAME) WHERE ROWNUM < 10
This query will be rejected by Oracle with the following message: ORA-00918: column ambigously defined.


Directions to apply fix:

1) Copy pak file to the directory maintenance in the UpdateInstaller directory

2) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure
   that all transactions have completed, before installing the fix.

3) Follow the Fix installation instructions that are packaged with the Fix Installer on how to install the Fix.

4) Restart WebSphere


Directions to remove fix:
NOTE:  FIXES MUST BE REMOVED IN THE ORDER THEY WERE APPLIED.  DO NOT REMOVE A FIX UNLESS
       ALL FIXES APPLIED AFTER IT HAVE FIRST BEEN REMOVED.  YOU MAY REAPPLY ANY REMOVED FIX.

Example:  If your system has fix1, fix2, and fix3 applied in that order and fix2 is to be
          removed, fix3 must be removed first, then fix2 may be removed

1) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure
   that all transactions have completed, before installing the fix.

2) Follow the Fix instructions that are packaged with the Fix Installer on how to uninstall and reinstall the Fix.

3) Restart WebSphere

Directions to re-apply fix:

1) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure
   that all transactions have completed, before installing the fix.

2) Follow the Fix instructions that are packaged with the Fix Installer on how to uninstall and reinstall the Fix.

3) Restart WebSphere


Additional Information: