1 2 Previous Next 19 Replies Latest reply: Mar 26, 2009 1:37 PM by ibyon RSS

    10.2.0.4 patchset is out

    19319
      F.Y.I
        • 1. Re: 10.2.0.4 patchset is out
          537159
          And what is the patchnumber, where can we find it on metalink, because I cannot find it.
          • 2. Re: 10.2.0.4 patchset is out
            19319
            7005587 for windows and linux, ~530MB
            • 3. Re: 10.2.0.4 patchset is out
              580108
              What are the benefits of 10.2.0.4 towards 10.2.0.1?

              Any advices would be appreciate.

              Best Regards,
              Steffen
              • 4. Re: 10.2.0.4 patchset is out
                David Allan-Oracle
                Hi Steffen

                There are a stack of bug fixes over the past 2 years from when OWB 10.2.0.1 was released. OWB 10.2.0.4 also works on Oracle database 11g.

                Cheers
                David
                • 5. Re: 10.2.0.4 patchset is out
                  birdy
                  HI Steffen
                  Yes there are a lot of bugs resolved in the latest patch. The one I found most useful was the case where upgrade table option failed with error "RTC-5270 Invalid Upgrade Plan"
                  This has been fixed now. There are a host of other bugs too which have supposedly been fixed

                  Resolved Issues
                  The following is a list of issues resolved in Oracle Warehouse Builder 10g Release 2 (10.2.0.4).

                  3992231 ERROR WHEN TRYING TO SEE THE COLUMN DATA TYPE IN KEY LOOKUP

                  4956010 ERRORS AFTER OPENING A MAP IN READ-ONLY MODE

                  5115574 PB IN EXPRESSION BUILDER WHEN USING PRIVATE FUNCTIONS WITH OBJECT TYPES

                  5242201 COMMIT FREQUENCY AND MAX ERRORS HAS NO EFFECT

                  5368252 MAPPING SEQUENCE TO TABLE WARNINGS ON DEPLOYMENT

                  5507628 TABLE IMPORT WITH MORE THAN 1000 PARTITIONS HANGS

                  5519895 VLD-1141 VALIDATION ERROR AFTER UPGRADING DESIGN REPOSITORY FROM OWB 10.1.0.4

                  5526905 INVALID MDL FILE AFTER COPY OF PLUGGABLE MAPPING FOLDER IN NEW PROJECT

                  5579903 CONSTANT API0259: THE OBJECT CANNOT BE EDITED IN READ ONLY MODE ERRORS

                  5605402 PROFILE TABLE HAVING TWO COLUMNS WITH NAMES SAME TO 26 CHAR FAILS API-0408

                  5631422 DEPLOY FAIL WHEN SET ACTION IS ''UPGRADE'' - /USR/LIB/HPUX32/DLD.SO: UNABLE TO F

                  5659356 QA: REG :JNP IMPORTING THE SAME MDL TWICE

                  5705198 LOADING PROPERTIES CHANGED AFTER MDL EXPORT/IMPORT (VLD-2750)

                  5708683 ORA-06502 NUMERIC OR VALUE ERROR WHILE PROFILING TABLES

                  5742116 ACTIVITY PARAMETER CAN BE BOUND TO ANOTHER ACTIVITIES OUTPUT - DEPLOY FAILS

                  5745966 INBOUND SYNCHRONIZATION OF TARGET TABLE DOES NOT WORK.

                  5864566 DATA VIEWER CANNOT GET CORRECT TIME WITH TIMESTAMP COLUMN

                  5864953 TOO OFTEN SHOWED: PRS-00503: YOU DO NOT HAVE PRIVILEGE:

                  5874426 TABLE UPGRADE FAILS WITH RTC-5270

                  5929001 DEPLOYMENT OF TABLE WITH UPGRADE PLAN FAILED WITH RTC-5270

                  5931375 OMBRETRIEVE COLLECTION DOES NOT WORK FOR VARYING_ARRAY AND NESTED_TABLE

                  5957354 MAPPING WITH TABLEFUNCTION VALIDATES BUT GENERATED CODE IS INVALID

                  5998179 KEY LOOKUP GIVES INCORRECT SQL WHEN USED WITH A CONSTANT OPERATOR AS SOURCE

                  6024930 IMPORT OF A PARTITION TABLE FROM TARGET DATABASE DOES NOT HOLD PERTAIN METADATA

                  6025865 AFTER IMPORTING PLSQL PACKAGE, OWB EXPRESSIONS RAISED VALIDATION ERRORS

                  6041726 REPOSITORY BROWSER CANNOT MANAGE A HUGE AMOUNT OF AUDIT DATA

                  6045890 LOADING HINT ON DIMENSION OPERATOR NOT WORKING PROPERLY.

                  6068821 CC_MIGRATE.SH NOT DETECTING TARGET LOCATION AS DEPLOY CANDIDATE

                  6113136 WRONG EXPRESSION IN EXPRESSION OUTGROUP ATTRIBUTE AFTER EXPORT/IMPORT

                  6121595 AFTER DROPPING USER, UNABLE TO ACCESS MAPPING OWNED BY THIS USER

                  6125093 EXPRESSION VALIDATION FAILS WITH CUSTOM PACKAGE USING TYPES

                  6147633 CODE GENERATED BY OWB 10.2 FOR VARIABLES WON'T EXECUTE IN PARALLEL

                  6174856 OWB10GR2 USES DB LINK WHERE AS OWB10GR1 USES SCHEMA NAME WHEN USING SQL*NET

                  6178565 OWB 10.2.0.1.0.DATA PROFILE WITH ROW RELATIONSHIP DISCOVERY IS FAILING

                  6192353 GETTING PLS-00201: IDENTIFIER 'WB_LOOKUP_NUM' MUST BE DECLARED

                  6208096 BACK-PORT FIX OF BUG 5664351 TO 10.2.0.4

                  6255056 VALIDATION OF TABLE FAILS WITH VLD-0005: ORACLE.WH.REPOS.SDK.EXCEPTIONS

                  6270894 OWB USERS ARE UNABLE TO ACCESS CONTROL CENTER OR EDIT LOCATIONS

                  6273371 FORWARD PORT BUG 6159644 TO 10.2

                  6278918 IMPORT OF TABLES FROM DB2/400 USING TG4DRDA FAILS: ORA-00604, ORA-28500

                  6310069 MAPPING DOES NOT GENERATED DATABASE LINK WHEN USING NET*SERVICE NAMES

                  6311981 HOW TO DISABLE HINTS FROM BEING AUTOGENERATED IN THE MAPPING CODE

                  6312387 REQUIRED COLUMN IS SET TO YES EVEN FOR INPUT PARAMETERS WHICH ARE NULL

                  6314767 RTC-5161 DEPLOYING PROCESSFLOWS AFTER UPGRADING TO OWB 10.2.0.2

                  6319584 ORA-2063 ORA-01002 WHEN PROFILING DB2/400 TABLE ACCESSED BY VIEW VIA OTG-DRDA

                  6326693 INCORRECT CODE GENERATED FOR MAPPING : NUMBER(0,0) LEADS TO ORA-01727

                  6328509 PLS PROVIDE ONE-OFF PATCH FOR BASE BUG 6314767 ON TOP OF 10.2.0.2 FOR WIN 2003

                  6370058 SCHEDULED PROCESS FLOWS ONLY EXECUTE ONCE

                  6408329 DESCRIPTION DOESNT ALLOW MORE THAN 2000 CHARECTERS FOR VARCHAR2(4000)

                  6411475 10.2.0.3 SCD TYPE 2 : INCORRECT VERSIONING OF THE CHILD LEVELS

                  6429462 VLD-1108 ERROR WHEN ATTEMPTING TO VALIDATE A MAPPING

                  6434510 OWB 10GR2 : OWF LOCATION REGISTRATION WIZARD - MISSING R12 VALUE IN THE LOV

                  6437978 UNABLE TO USE THE EXISTING DB LINK OPTION FOR THE DB CONNECTOR

                  6450227 GENERATED CODE FOR A MERGE USING A SEQUENCE IN AN EXPRESSION DOES NOT EXECUTE.

                  6474332 IMPORT DOES NOT PERSIST CFA'S DESPITE THE LOG SHOWING THEM AS ADDED

                  6497676 ERROR RAISED BY CUSTOMER PROCEDURE NOT DISPLAYED

                  6507476 MULTI-INSERT MAPPING - ROWS DUPLICATED IN THE TARGET TABLES

                  6508051 "AND" ACTIVITY IN PROCESS FLOW DOESN'T WAIT FOR ALL INCOMING PROCESSES TO FINISH

                  6508649 ERRORS GENERATED WHEN DEBUGGING A MAPPING IN OWB.

                  6510560 SLOW PERFORMANCE ON 2ND LOAD OF SCD TYPE2 DIMENSION WITH MANY RECORDS IN TARGET

                  6513102 CO_UK_NAME VIOLATION DURING MIGRATION OF RUNTIME AUDIT DATA

                  6522361 CC_MIGRATE FAILS WITH ORA-00904:"SDA"."ADAPTER_NAME": INVALID IDENTIFIER.

                  6601542 DEPLOYING PROCESS FLOW FAILED WITH ERROR RTC-5161

                  6622123 NO OPTION TO DEPLOY ADVANCE QUEUE IN OWB 10.2.0.2

                  6629079 10.2.0.3 : NULL POINTER EXCEPTION WHEN COMMIT CONTROL SET TO MANUAL

                  6642763 OWB 10G CERTIFICATION WITH DATABASE 11G

                  6645650 WHEN IMPORT A TABLE GOT ORA-00997: ILLEGAL USE OF LONG DATATYPE

                  6656454 PRIOR VALUE CALCULATIONS FOR MEASURES NOT WORKING PROPERLY

                  6658616 ENT-06972: ERROR WHILE DISPLAYING BIBEAN FOR DIMENSION DATAVIEWER.

                  6664381 BROWSER DOES NOT USE PLATFORM PROPERTIES TO MODIFY PURGE PROCESS

                  6667700 EXTRACTION HINT CAUSES INCORRECT CODE TO BE GENERATED

                  6670563 FORWARD PORT BUG 6527943 INTO 10.2.0.4

                  6671456 TABLE WITH "HASH BY QUANTITY" PARTITION DOES NOT GENERATE CORRECT CODE

                  6709113 RE-IMPORTING A MAPPING SETS THE LOCATION TO UNKNOWN VALUE

                  6726840 LOADING HINT CAUSES INCORRECT CODE TO BE GENERATED

                  6733019 ORA-00904 WHEN DEPLOYING MERGE MAP, HAVING SEQUENCE AS INPUT FOR NVL EXPRESSION

                  6797890 TARGET LOAD ORDER IS NOT CONSIDERED FOR ROW-BASED PROCESSING

                  6798489 MDL IMPORT OF A PLUGGABLE MAP FAILS WITH MDL1261: ERROR IMPORTING DUMMYCFA

                  6811099 OUI INSTALLER ERRORS: FILE NOT FOUND: DTUPG1102TO10203_10GR1.SH

                  6811383 11G PASSWORD CASE SENSETIVITY NOT WORKING, PASSWORDS ARE UPPERCASED

                  6815310 THE UPGRADE SCRIPTS DTUPGXXXTOXXX.SH DON'T HAVE EXECUTE PERMISSIONS

                  6815343 RAB WON'T DISPLAY RESULTS FROM 11G REPOSITORY.

                  6815718 PARENT LEVEL DATA MISSING AFTER EXECUTING TYPE 1 DIMENSION LOAD MAP

                  6815724 REG: MAP WITH TABLE FUNCTION - CARTISIAN PRODUCT GENERATED

                  6823539 INVALID OBJECTS WHEN INSTALLING 10.2.0.4 REPOSITORY ON 11G DATABASE

                  6823847 11G PASSWORD CASE SENSITIVITY NOT PROPERLY HANDLED BY LOCATIONS

                  6835094 11G PSWD IS CASE SENSITIVE, TARGET USER CREATION IS UPPERCASING SYS PASSWORD

                  6835155 REG: EXTRA RECORDS CLOSED WHEN LEVEL EFFECTIVE DATE CONNECTED FROM SOURCE

                  6835188 INCORRECT ABAP CODE GENERATED FOR SAP ECC6.0 PATCH LEVEL 7

                  6843461 DATA PROFILER IS GIVING ERRORS (ORA-00942: TABLE OR VIEW DOES NOT EXIST)

                  6843805 EXPORT OF PROCESS FLOWS WITH ALL DEPENDENCIES DOES NOT CONTAIN ALL DEPENDENCIES

                  6859419 REG: MAPS WITH PROCEDURE OR PREMAP TRIGGER - FAIL ROW_BASED EXECUTION

                  6864029 AFTER SYNCHRONIZING A TARGET TABLE OPERATOR, HINTS APPEND AND PARALLEL APPEAR

                  6865659 MAP TO LOAD SCD2 DIMENSION - BUFFEROVERFLOWEXCEPTION WHEN GENERATE

                  6868659 CO_FK_PARENT_CO PARENT KEY NOT FOUND DURING MIGRATION

                  6871036 BACKPORT OF FIX FOR 6871024 (CCM MESSAGE PERFORMANCE) TO PARIS

                  6897024 WAREHOUSE UPGRADE FAILS WITH 11G RDBMS, 11G PASSWD CASE PROBLEM

                  6897043 WORKFLOW INVALID USER/PASSWORD WHEN DEPLOYING A PROCESS FLOW ON 11G RDBMS

                  6897108 BIDEMO FAILS TO CREATE CONNECTOR WITH 11G RDBMS

                  6897128 UNABLE TO CREATE TIME DIMENSION IN BIDEMO ON 11G RDBMS

                  6897157 REG: OPTIMIZE MERGE IS NOT WORKING (REG FROM 10.2.0.3)

                  6900328 SINGLE LEVEL TYPE 2 DIMENSION LOAD - HANG ON MAP EXECUTION

                  6912718 UNABLE TO COPY/PASTE, SNAPSHOT PACKAGE INVALID IN 11G RDBMS

                  6927052 REG: REPOS VERSION IS NOT UPGRADED WHEN UPG102TO10204.SQL RUNS

                  6932465 LOCATION EDITOR FOR ORACLE DB DOES NOT SUPPORT 11.1 AFTER REPOS UPGRADE

                  6933909 UNABLE TO START CONTROL CENTER WITH 11G RDBMS

                  6950816 10.2.0.4 WITH 11G DB: CANNOT SET MODULE PL/SQL GENERATION MODE TO ORACLE11GR1

                  6954161 CANNOT DEPLOY ERROR TABLE FOR DATA AUDITOR

                  6966817 VALIDATION ERROR USING OMBDEPLOY

                  6970141 REG: UPGRADED DATA PROFILES FAILING - JNPES OR COMPILATION ERRORS

                  6976639 MIGRATION PATH FROM DB 10G TO DB 11G NOT AVAILABLE

                  7003209 CLONING REPOSITORY FROM WINDOWS TO LINUX : LOCATION_UTIL.SH FAILS

                  7005587 ORACLE 10GR2 WAREHOUSE BUILDER PATCH 10.2.0.4

                  7026206 NEED TO BE ABLE TO LOAD CONTROL CENTER METADATA INTO EXISTING CC-REPOSITORY

                  7146953 ./INSTALL_10204_PROFILES.SH (PERMISSION DENIED), DOES NOT HAVE EXECUTE BIT SET

                  7156085 ISSUE WITH OWB MAPPINGS FOR MOLAP DIMENSIONS AS TARGET

                  7193221 JAVA.SQL.SQLEXCEPTION RUNNING INSTALL_10204_PROFILES.BAT

                  7195786 TYPE 2 SNOWFLAKE DIMENSION LOADING WITH HIERARCHY VERSIONING NOT WORKING

                  7208261 REG: INSERT/UPDATE IS BROKEN,VLD-2750 WHEN TGT TBL KEY IS PROPERLY MAPPED

                  7208637 REG: DEFAULT TARGET LOAD ORDER IS BROKEN FOR FK RELATED TARGETS

                  7212104 CC_MIGRATE NOT WORKING PROPERLY ON WINDOWS



                  cheers
                  birdy
                  • 6. Re: 10.2.0.4 patchset is out
                    birdy
                    Hi Robert

                    I did not find any details for whether this patch is applicable to 64-bit Windows 2003 Itanium Servers as well. Any ideas?

                    Birdy
                    • 7. Re: 10.2.0.4 patchset is out
                      418849
                      Looks like patch is only available for Windows 32, Windows 64, and Linux right now. I am sure the patch for other platforms will be available in the new few months.

                      They released the 10.2.0.3 patch (6264457) in August last year but the Windows 64-bit Itanium wasn't available until January. I am waiting for the HP-Unix patch.
                      • 8. Re: 10.2.0.4 patchset is out
                        498518
                        Thanks for info
                        • 9. Re: 10.2.0.4 patchset is out
                          stevepence
                          We JUST put it in, going from 10.2.0.3 and have tons of queries going bananas. We put in a tar and support has been totally silent for two days.

                          I'd say test test test test before going live with this one.

                          Steve
                          • 10. Re: 10.2.0.4 patchset is out
                            birdy
                            Rightly said. Testing is required. Today I tried to perform an upgrade and it fails like it always used to.

                            But the same operation worked the other day on the same table just after I had applied the patch.

                            *Scratching head*

                            Wonder why OWB behaves differently each time.......???
                            • 11. Re: 10.2.0.4 patchset is out
                              115307
                              HI,
                              I am on Oracle R12 RUP4 and database is on 10.2.0.2 and wanted to upgrade database to 10.2.0.3, could you please share any metalink note.

                              thanks
                              Pravin
                              • 12. Re: 10.2.0.4 patchset is out
                                stevepence
                                An update on my query performance issue after going from 10.2.0.3 to 10.2.0.4. To state things more carefully, we've found about 30 queries, all with similar syntax, that have gone from 0.5 secs to around 200 secs under 10.2.0.4. Support has given me a set of init params that are "supposed" to return the optimizer's behavior to 10.2.0.3 if we restore pre-patch stats. Unfortunately, the patch must be purging stats as part of its upgrade process. The oldest stats I now have (per DBA_TAB_STATS_HISTORY) is the day we put in the patch. Not nice.
                                Be warned!
                                Steve
                                • 13. Re: 10.2.0.4 patchset is out
                                  640209
                                  Our experience - When upgraded 10.2.0.1 to 10.2.0.4 (Windows 2003),

                                  1. Database Control did not start up. Had to ask Oracle Support for starting DB Control.
                                  2. Then EM agent was not uploading metrics. Had to work with ORacle Support to get the EM agent to upload the metrices properly.
                                  • 14. Re: 10.2.0.4 patchset is out
                                    651714
                                    Hi,

                                    does anyone know a roadmap for patch 10.2.0.4 on other platforms? We need it on linux x86 - 64 bit.
                                    1 2 Previous Next