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

12c Direct SQL Analysis Issue

Received Response
11
Views
5
Comments
User_2NI9B
User_2NI9B Rank 3 - Community Apprentice
edited Aug 13, 2024 5:56PM in Oracle Analytics Cloud and Server

Hi All.

We have many direct sql analyses on our 11g environments. All run absolutely fine without any issue.

Recently we migrated to 12c. And we noticed there are issues with direct sql analyses, not all but some random ones.

A simple query like the below will produce results but one of the column is blank, means, as if there is nothing stored in that column in the table even though there is.

Select emp_id, emp_name, emp_address, emp_position, salary from employees;

The results shows emp_position as blank column (empty or null). On 11g I can see there are records for that column.

Now, if I swap emp_address with emp_position, then the results show emp_position but emp_address is now empty!

Any idea any one what's going on?

No formatting has been applied. Nothing is hidden. Tried both table and pivot. Same issue.

Thanks

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Did you try building a new analysis from scratch with the same query?

    Also maybe worth searching the forum here as I remember something similar (actually the same) some time ago.

    PS: it always help if you clearly identify the versions you talk about (full version number + bundle patch)

  • User_2NI9B
    User_2NI9B Rank 3 - Community Apprentice

    Hi Gianni,

    Yes we have tried creating new analysis from scratch.

    Details of version: Oracle Business Intelligence Product Version 12.2.1.2.0 (Build BIPS-20160923092103 64-bit)

    Please note that the issue is only for direct sql queries. Normal queries from subject areas have no problem.

    You meant this post? Data missing in random columns in Analyses (12c 12.2.1.2)

    Thanks

  • Gianni Ceresa
    Gianni Ceresa Mod

    Yes, that's the post I had in mind

    As you have the same version you maybe want to have a look into the linked bug/patch. The bugs not being public if you want to see more you will need to open a SR.

    The patch is available publicly in MOS, so you maybe want to give it a try ...

  • User_2NI9B
    User_2NI9B Rank 3 - Community Apprentice

    That particular post was related to queries from subject areas.

    But nevertheless, it's the same issue, will have a look at the patch.

  • Gianni Ceresa
    Gianni Ceresa Mod

    You are right but it's also the only thing I remember sounding like what you see, with columns just "empty".

    Also the patch has a name and replace a .so file which could also work for DDR.

    You can of course open a SR and follow the process there asking them if the fix cover your needs too or not. But if you have a sandbox around it's probably faster to try the patch (in general SR take time)