2 Replies Latest reply on Feb 6, 2019 8:26 PM by Christian Berg

    Data missing in random columns after in-place upgrade to 12.2.1.4.0

    JustTheFacts

      Note: this is a follow-up to this older discussion:Data missing in random columns in Analyses (12c 12.2.1.2) , intended to document a new bug with the 12.2.1.2 - 12.2.1.4 in-place upgrade.

       

      We had a bug back in 2017 regarding data missing randomly from analyses after upgrading from 11g to 12.2.1.2. See the discussion above for details.

       

      I just want to document here for any searchers that this problem can re-occur after an in-place upgrade to 12.2.1.4. There are no patches for it, as opatch will tell you that you don't need any of the patches that Oracle Support will suggest. An out-of-place upgrade will not exhibit the problem.

       

      Our own troubleshooting narrowed the problem down to this file:

       

           [DOMAIN HOME]/bi/config/fmwconfig/biconfig/core/ddpath.properties

       

      There is only a single line in that file:

       

           DD_PATH=[ORACLE_HOME]/bi/modules/oracle.bi.datadirect.odbc/8.0.1

       

      That value should be (but is not) updated by the Upgrade Assistant to this:

       

           DD_PATH=[ORACLE_HOME]/bi/modules/oracle.bi.datadirect.odbc/8.0.2

       

      Once we manually made that change and restarted, the missing columns reappeared. We have asked Oracle to issue a bug ticket for this issue, as Upgrade Assistant correctly updated all ODBC.INI entries to point to the new 8.0.2 drivers, but it failed to update ddpath.properties.