4 Replies Latest reply on Jul 2, 2013 5:51 PM by David Allan-Oracle

    Join condition validation error in owb 10gR2

    Mini

      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-Oracle

          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

            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

              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-Oracle

                Hi Mini

                 

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

                 

                Cheers

                David