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.

JustTheFacts

Answering my own post, as this is just for information for future searchers.

Christian Berg-0racle

Tactical .