Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12c - TimesTen hint causes inflated data

Question
1
Views
0
Comments
Johan (South Africa)
Johan (South Africa) Rank 3 - Community Apprentice
edited Aug 13, 2024 7:17PM in Oracle Analytics Cloud and Server

Hi

We are in the process of upgrading from OBIEE 11g to OBIEE 12.2.1.2.0 and noticed that some queries that are routed to our in-memory TimesTen database is showing inflated (double the correct value) data.

Upon closer investigation I noticed that it is the hints in the queries that are causing the issues. Here is an example of the hint:

TT_ROWLOCK(0) TT_TBLLOCK(1) TT_MERGEJOIN(0) TT_NESTEDLOOP(1) TT_FASTPREPARE(1)

I cannot find any documentation on this.

Any suggestions or comment from anyone?

Thanks

Johan