Note 1126517 - ORA-1445 or incorrect values with 10.2

Summary

Symptom

***********************************************************************
* This note is issued as a Hot News. *
Check the note regularly for updates. Otherwise, you will not be aware
of important changes regarding prerequisites, consequences and
solutions. *
A new Hot News is not issued if a note is updated.
*
***********************************************************************

The problem manifests itself in one of two ways:

1. You receive the following error:
ORA-01445: cannot select ROWID from a join view without a key-preserved table

or

2. You do not receive the error, but the system returns either incorrect values or no values.

Other terms

Oracle 10.2, inner join, bug 5188321, wrong results, incorrect values

Reason and Prerequisites

This is due to an error that occurs with the ANSI JOIN join syntax.

For example:

SELECT *
FROM ."VBAK" T_00
INNER JOIN SAPISA."VBPA" T_01 ON T_01."VBELN" = T_00."VBELN"
INNER JOIN SAPISA."VBUK" T_03 ON T_03."VBELN" = T_00."VBELN"
INNER JOIN SAPISA."VBAP" T_04 ON T_04."VBELN" = T_01."VBELN"
INNER JOIN SAPISA."VBEP" T_06 ON T_06."POSNR" = T_04."POSNR"
INNER JOIN SAPISA."KNA1" T_07 ON T_07."KUNNR" = T_01."KUNNR"
INNER JOIN SAPISA."VBBE" T_08 ON T_08."ETENR" = T_06."ETENR"
INNER JOIN SAPISA."MARC" T_10 ON T_10."MATNR" = T_08."MATNR";


This type of join syntax first occurs in the SAP environment with Oracle 10.2, because it was not used previously.

This problem involves the Oracle bug 5188321 that is
corrected with Oracle Release 10.2.0.4.

Solution

Install the bug fix that is relevant for your platform. The bug fixes are available in the Software Center on SAP Service Marketplace at:
http://service.sap.com/swcenter-3pmain
in the following directories:

AIX 5L 64-bit
/Oracle/Oracle 64-bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
AIX_5L_64/p5188321_10202_AIX64-5L.zip

SUN Solaris 64-bit
/Oracle/Oracle 64-bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
Solaris_SPARC_64/p5188321_10202_SOLARIS64.zip

SUN Solaris x86-64
/Oracle/Oracle 64-bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
Solaris_x86_64/p5188321_10202_Solaris86-64.zip

LINUX 32-bit
/Oracle/Oracle 32-bit/Oracle 10.2.0. 32-bit/Oracle 10.2.0.2/
Linux_32/p5188321_10202_LINUX.zip

Linux x86-64
/Oracle/Oracle 64-Bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
Linux_x86_64/p5188321_10202_Linux-x86-64.zip

LINUX Itanium 64
/Oracle/Oracle 64-bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
LINUX_IA_64/p5188321_10202_LINUX-IA64.zip

LINUX IBMPower 64-bit
/Oracle/Oracle 64-bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
Linux_ppc_64/p5188321_10202_IBMPower.zip

HP-UX PA-RISC 64-bit
/Oracle/Oracle 64-bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
HP-UX_64/p5188321_10202_HP64.zip

HP UX Itanium 64-bit
/Oracle/Oracle 64-bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
HP_IA_64/p5188321_10202_HPUX-IA64.zip

HP TRU64
/Oracle/Oracle 64-bit/Oracle 10.2.0. 64-bit/Oracle 10.2.0.2/
HP_TRU64/p5188321_10202_TRU64.zip

Windows 32-bit / 64-bit (Windows IA64 / x86-64)
The patch 5188321 is contained in patch 13 for Oracle 10.2.0.2.
For availability, see Note 871735.


This note will be updated accordingly as soon as the patches are made available for the platforms that are still missing.

Header Data

Release Status:	Released for Customer
Released on:	03.01.2008 13:32:16
Master Language:	German
Priority:	HotNews
Category:	External error
Primary Component:	BC-DB-ORA Oracle
Secondary Components:	BW-SYS-DB-ORA BW ORACLE