Data missing in random columns after in-place upgrade to 12.2.1.4.0
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.
Answers
-
Answering my own post, as this is just for information for future searchers.
0 -
Tactical .
0