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:
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!
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?
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.
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.
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)
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?
That's exactly the point I wanted to get you to
Now check what is underneath in the RPD
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
Trace it top down. Column logic/formula, LTSs, physical source, source settings, SQL, explain plan...
Ok! Thanks I'll trace all of this and inform about results.
Hello experts
In that report....if I check this option:
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
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.
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
The user icon in the upper-right corner of OAC (DV) is displaying more menu options for our non-admin users than we wish to display. We would like to restrict these to only "Profile" and "Sign Out" for regular users. Is there a way to customize these menu items? Especially if we can control this via security, that would be…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
