Weird issue when I open a report — Oracle Analytics

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

Weird issue when I open a report

Received Response
101
Views
14
Comments
Alex1
Alex1 Rank 4 - Community Specialist
edited Aug 13, 2024 5:50PM in Oracle Analytics Cloud and Server

Hello experts,

I'm using obiee 11.1.1.9 and I have a report that when I want to open I obtain this error:

pastedImage_0.png

It's weird because if I click on "Refresh" I can see my report perfectly. It's only first time that I open this report.

Any help??

Thanks!

«1

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    It somehow complain about incompatible types. Does the analysis ("report" = Publisher, "analysis" = the one you are opening ) contain a UNION?

    Is that something you copy/paste edited, migrated or moved around for a while?

    Does the same happen if you create a new (from scratch) analysis with the same logic?

  • Alex1
    Alex1 Rank 4 - Community Specialist

    Hello @Gianni Ceresa

    Thanks for your reply.

    Is an analysis (answers analysis) and not contain any union

    This analysis is migrated from a test enviroment (In test enviroment works fine).

    If I create a new analysis from 0 with exact columns I obtain same error that I posted before.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Non-compatible types errors really point to a calc/logic issue.

    Recreate the analysis step by step or prune away columns one by one until you find the issue.

  • Alex1
    Alex1 Rank 4 - Community Specialist

    It's weird because when I open report first time I have this issue, then I refresh and I see report perfectly (only If I click on refresh)

    pastedImage_0.png

    If I recreate analysis I can see that are one columns that cause the error. That column I need to use to filter all analysis, when I create a filter for that column error appears. Then I don't know what to do. Maybe I have to modify something in Administration layer?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    That's exactly the point I wanted to get you to

    Now check what is underneath in the RPD

  • Alex1
    Alex1 Rank 4 - Community Specialist

    Ok, Now I know that issue is in admin layer but how can I havbe to fix? Aparently I have checked between prod and test exactly and I have same connections

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Trace it top down. Column logic/formula, LTSs, physical source, source settings, SQL, explain plan...

  • Alex1
    Alex1 Rank 4 - Community Specialist

    Ok! Thanks I'll trace all of this and inform about results.

  • Alex1
    Alex1 Rank 4 - Community Specialist

    Hello experts

    In that report....if I check this option:

    pastedImage_0.png

    my report works fine (load at first time without any error) but it slow to load (20 seconds instead 1 sec) My customer woudn't approve it...

    This option is any clue to fix my issue?

    Thanks

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Do you have any special characters in the table name/columns etc.. in the report? If so remove them and see if the same issue occurs again.