This discussion is archived
4 Replies Latest reply: Jul 2, 2013 10:51 AM by David Allan RSS

Join condition validation error in owb 10gR2

Mini Journeyer
Currently Being Moderated

Hi friends,

 

When I tried to validate the join condition in the mapping im getting the below error like

 

an error occurred during expression validation, bad expression return type

 

When I googled for the above error, I got the below link mentioning like a bug for that join condition validation problem

 

https://forums.oracle.com/thread/717194

 

In which it is mentioned like a BugNo: 7417869 for that issue.

Is there any fix for that bug??

 

Thanks in advance.

 

Brgds,

Mini

  • 1. Re: Join condition validation error in owb 10gR2
    David Allan Guru
    Currently Being Moderated

    Hi Mini

     

    Apparently it is fixed, the bug has details of the patch on ARU.

     

    Cheers
    David

  • 2. Re: Join condition validation error in owb 10gR2
    Mini Journeyer
    Currently Being Moderated

    Dear Allan,


    Happy to get reply from you and sorry for my late reply as im been stuck with other work


    Like you said, I downloaded the required patch 4898608 for the validation bug in mapping with owb 10.2.0.4. By viewing the readme.txt file of the patch I followed the below steps like

     

    • Set the ORACLE_HOME environment variable to point to the OWB Home
    • Add $ORACLE_HOME/OPatch  in the PATH
    • Stopped the runtime service using the supplied SQL*PLUS script stop_service.sql as a rep_owner
            OWB_HOME/rtp/sql/stop_service.sql

    After the above three steps I applied the opatch like below in cmd prompt

    C:\orahome\10gR3_1\OPatch>opatch version
    Invoking OPatch 10.2.0.4.9

    OPatch Version: 10.2.0.4.9

    OPatch succeeded.


    C:\OraHome_1\OPatch>opatch apply
    Invoking OPatch 10.2.0.4.9

    Oracle Interim Patch Installer version 10.2.0.4.9
    Copyright (c) 2009, Oracle Corporation.  All rights reserved.

    Oracle Home       : C:\OraHome_1
    Central Inventory : C:\Program Files (x86)\Oracle\Inventory
       from           : n/a
    OPatch version    : 10.2.0.4.9
    OUI version       : 10.2.0.1.0
    OUI location      : C:\OraHome_1\oui
    Log file location : C:\OraHome_1\cfgtoollogs\opatch\opatch2013-06-24_18-14-27PM.
    log

    Patch history file: C:\OraHome_1\cfgtoollogs\opatch\opatch_history.txt

    Failed to load the patch object.  Possible causes are:
      The specified path is not an interim Patch shiphome
      Meta-data files are missing from the patch area
      Patch location = C:\OraHome_1\OPatch
      Details = PatchObject constructor: Input file "C:\OraHome_1\OPatch\etc\config\
    actions" or "C:\OraHome_1\OPatch\etc\config\inventory" does not exist.

    ApplySession failed: PatchObject constructor: Input file "C:\OraHome_1\OPatch\et
    c\config\actions" or "C:\OraHome_1\OPatch\etc\config\inventory" does not exist.
    System intact, OPatch will not attempt to restore the system

    OPatch failed with error code = 73

    C:\OraHome_1\OPatch>

    Im not sure why the above error is occuring, kindly help me with that error.

     

    Thanks in advance.

     

    Brgds,

    Mini

  • 3. Re: Join condition validation error in owb 10gR2
    Mini Journeyer
    Currently Being Moderated

    Dear Allan,

     

    Seemed like i have wrongly downloaded the patch. As this is the right patch 7654824.


    Have applied the patch and validation issue got solved successfully. Thanks for your time:-)

     

    Brgds,

    Mini

  • 4. Re: Join condition validation error in owb 10gR2
    David Allan Guru
    Currently Being Moderated

    Hi Mini

     

    Thanks for circling back to the thread with an update that makes the content here much more useful.

     

    Cheers

    David